anziga
01-13-2011, 02:37 PM
I try to connect from VBA/excel to solidDB, but have some problem to do that. I can almost read solidDB table to Excel worksheet, but the connection sting causes some problem. If it is like this: "varConnection = "ODBC; DSN=tcp 2315; DBQ=solid.db, 'dba', 'dba'"", then Select data source dialog pops out and ask to select Machine Data Source. Once I do that and provide username and password, I can read the database data into worksheet. Any ideas what I could do or try? I tried various different connection strings without luck.