> 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 <maury.markowitz@...> 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
>
>
>
>