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
<*> 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/
