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: [vba]"varConnection = "ODBC; DSN=tcp 2315; DBQ=solid.db, 'dba', 'dba'""[/vba], 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.
Reply With Quote