Re: [Firebird-odbc-devel] ODBC Connection

[Helen B. <he...@ii...>]

At 12:02 PM 8/12/2010, Woody wrote:
>Hello,
>
>Was directed here from firebird-support group.
>
>I've never connected to FB using ODBC so I downloaded the driver from the
>FirebirdSQL.org site and installed it in an XP virtual machine. My main
>machine is running FB SS 1.5 and using normal client connections
>(fbclient.dll) everything works fine.
>
>When trying to configure an ODBC connection through the Windows control
>panel, I can connect to the local (in the VM) FB server but it won't connect
>to my main computer FB server.
>
>I'm using the IP connection string format:
>
>    myserver:d:\databases\wonderware.fdb
>
>Windows firewall is turned off in the virtual machine. IBOConsole connects
>fine using normal client so I know everything is working normally. I just
>can't get the ODBC driver to connect.
>
>Any suggestions on what else I can try or whether I need to supply more
>information?

Does your datasource setup look anything like this? 
Note, this connection is made using a database alias for that database on the remote server. 

The client entry should point to fbclient.dll on the *client* computer.
Emacs!


The cursor in this screenshot is sitting on the "Test" button and the test was ok.

No drama, either, using dBrowser (free download from dbSoftlab, http://www.dbsoftlab.com/database-editors/database-browser/overview.html ).

Emacs!

I'm rather pleased with this. :-) My first test of Alexander's RC2, no dramas!

Helen