Subject | Re: [firebird-support] MS Access ODBC to Firebird |
---|---|
Author | Reinier Olislagers |
Post date | 2012-01-20T10:14:52Z |
On 20-1-2012 11:03, Magnus Titho wrote:
In addition, try to see whether the FB server actually is running etc by
doing
tasklist ==> & look for Firebird process
netstat -a to see if Firebird is listening; default port 3050
telnet myserver 3050 ==> or whatever the port is it is listening on
If it is not 3050, you'll have to specify the port in the ODBC setup.
There's a help file included with the odbc install which should explain how.
and try connecting using e.g. FlameRobin
http://sourceforge.net/projects/flamerobin/files/flamerobin-snapshots/0.9.x/
to see if it is an ODBC problem or a Firebird/connectivity issue.
HTH,
Reinier
> Peter M wrote:Also regular troubleshooting steps:
>> 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
>>
> Is P: a local drive of the server or a mapped drive?
> Don't use mapped drives as pathnames!
>
In addition, try to see whether the FB server actually is running etc by
doing
tasklist ==> & look for Firebird process
netstat -a to see if Firebird is listening; default port 3050
telnet myserver 3050 ==> or whatever the port is it is listening on
If it is not 3050, you'll have to specify the port in the ODBC setup.
There's a help file included with the odbc install which should explain how.
and try connecting using e.g. FlameRobin
http://sourceforge.net/projects/flamerobin/files/flamerobin-snapshots/0.9.x/
to see if it is an ODBC problem or a Firebird/connectivity issue.
HTH,
Reinier