> Is there a way to get more information? Yes, in Windows: Start, Settings, Control panel, Administrative Tools, Data Sources (ODBC), System DSN
Useful to know what ODBC driver we are dealing with here! RBS On 5/3/12, Maury Markowitz <[email protected]> wrote: > On 2012-05-02, at 6:32 PM, Bart Smissaert wrote: >> What is your ODBC driver? > > I don't know, it came with the Fishbowl system. Is there a way to get more > information? > >> strConn = "Driver={Firebird/InterBase(r) driver};" & _ >> "Dbname=c:\Program Files\Fishbowl\database\data\AS SOLAR.FDB;" >> >> OpenDBConnection strConn, "XXX", "YYY" > > Ahhh, progress, but not for the reason you think! > > I used the string above and it did not work - same "Automation Error". So > then I started suspecting that perhaps this was due to permissions. So I > opened the same code under an admin account. It still doesn't work, but at > least now I have more information! > > [ODBC Firebird Driver]Unable to connect to data source: library 'gds32.dll' > failed to load. > > I have noticed one difference between the ODBC manager setup and this > connection string: the ODBC setup includes a "client" line. However, > adding… > > Client=c:\Program Files\Fishbowl\odbc\fbclient64.dll; > > to the connection string didn't improve matters. > > I *suspect* this has something to do with 32/64 bit issues, or a > mis-registered DLL. > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > > ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
