Thanks Adam. Ill try that.



----- Original Message ----
From: Adam <s3057043@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, October 15, 2008 6:13:06 PM
Subject: [firebird-support] Re: Help i can't connect to a computer on my network using the odbc driver.


--- In firebird-support@ yahoogroups. com, "dewaineparker"
<dewaineparker@ ...> wrote:

>
> I created a data source on my server and connected to it fine. I then
> downloaded the odbc driver and setup a data source on a network
> computer but it won't connect. I turned ogg the firewall on the
> server and still couldn't connect. i then changed my settings and
> connected to a local database on my network computer. Basiclly i can
> connect localy but not over the network. i need to link some tables
> to ms access. Please help.

Firebird databases must be stored on a local volume not a network
share. So if your database file lives on a remote server, then that is
the server that must have Firebird installed.

Your ODBC connection database string must be of the form

Server Host Name:filename
or
Server IP:filename
or
Server Host Name:alias
or
Server IP:alias

The ODBC driver will talk to the Firebird client library on your local
machine, and the local Firebird client library will then talk to the
Firebird Server running on the database server.

Adam



[Non-text portions of this message have been removed]