Michael,
I know the odbcfb.dll is installed.
I can pick firebird /interbase driver from the odbc setup.
I cannot get a result on the Test Connection. I have tried every syntax for
the db name, with no change.

Path is P:\AdminBase\Database\ADMINBASE32.GDB

I tried myserver.mydomain.local:P:\AdminBase\Database\ADMINBASE32.GDB, and
using teh ip address, using
myserver:P:\AdminBase\Database\ADMINBASE32.GDB
Nothing works!
very frustrating becasue I had this working in previous server.

install of ODBC driver was via term serv session logged in a administrator

If you have any clues I'd be grateful

Peter


_____

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




Is the Firebird Server really installed on the same machine?

DBNAME=ServerNameOrIP:PathToDatabaseOnTheServer

Eg. For a windows machine

DBNAME=MyServer.MyDomain.local:c:\database\MyDatabase.fdb

Or for a linux machine

DBNAME=MyServer.MyDomain.local:/var/firebird/MyDatabase.fdb (On linux all
names are casesensitive!)

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: Wednesday, January 18, 2012 10:13 AM
To: firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com>
Subject: RE: [firebird-support] MS Access ODBC to Firebird

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%40yahoogroups.com>
<mailto:firebird-support%40yahoogroups.com>
[mailto:firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com>
<mailto:firebird-support%40yahoogroups.com> ] On Behalf Of Michael Möhle
Sent: 18 January 2012 08:58
To: firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com>
<mailto:firebird-support%40yahoogroups.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%40yahoogroups.com>
<mailto:firebird-support%40yahoogroups.com>
[mailto:firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com>
<mailto:firebird-support%40yahoogroups.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>
<mailto:firebird-support%40yahoogroups.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]

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






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