Thank you. Very helpful
Firebird is installed to run its application by the vendor, I just need to
make connection from Access.

App is 32 bit, running on remote desktop.

if you have any thought on the syntax for the DB path I would be grateful.
I expect to try to resolve this matter on Friday.
Peter

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Michael Möhle
Sent: 18 January 2012 08:58
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] MS Access ODBC to Firebird




Installation Order:

- Firebird Server (only client)

- ODBC Driver 32 Bit

- ODBC Manager is in Control Panel -> 32 Bit Control Panel

The ODBC driver depends only on the “Bits” of the application not on the
“Bits” of the operating neither on the “Bits” of the Firebird Server

32 Bit APP -> 32 Bit ODBC Driver -> 32/63 Bit Operating
System/Firebird Server

64 Bit APP -> 64 Bit ODBC Driver -> 32/63 Bit Operating
System/Firebird Server

And the ODBC Driver depends on the gds32.dll/fbclient.dll for that you need
the Installation Package of the Firebird Server, corresponding to

the “bitness “ of the ODBC driver. If you install the Server there is a
dropdown box where you can choose “client only” install.

Michael

From: firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com>
[mailto:firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com> ] On Behalf Of Peter M
Sent: Tuesday, January 17, 2012 12:36 PM
To: firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com>
Subject: [firebird-support] MS Access ODBC to Firebird

Hello,

A cli e nt recently had their application changed to run firebird rather
than paradox . It worked fine, with MS Access apps connecting to provide
data feeds from firebird. It is version 1.5 I am told.

Then it was moved to a windows server 2008.

I can no longer get MS Access to connect to the the firebird tables.

The problem seems to be in the ODBC setup, I can't run an effective test
that sets up and stores the user name and password.

The connection to the MS Access dbs is via remote desktop as well, in case
that matters.

My questions are these.
What ODBC driver should I install on the server, and should it be under
remote desktop session or directly form eth console.?

Firebird is version 1.5 I am told, what ODBC driver is best.?
Should it be 32 bit or 64 bit driver?

Is there any other clues you may be bale to offer to get this connected?
there eseems to be an issue in how the path to the data source is
described, it workd sometimes as " localhost: p:\ dir1\dir2zapp.xyz", and
sometimes without the localhost bit, which i think relates to it being a
remote connection.

Any help greatly appreciated.

Best
Peter Marshall

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

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






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