Thank you also. I have made a connection directly through teh access db, using machine data source. It appears to connec the table and opens repreatedly after ms Access is restrtaed.
It gives error 902 or 904 if I try to use a file data source. So, progress, but uncertain! Peter _____ From: [email protected] [mailto:[email protected]] On Behalf Of Reinier Olislagers Sent: 20 January 2012 10:15 To: [email protected] Subject: Re: [firebird-support] MS Access ODBC to Firebird On 20-1-2012 11:03, Magnus Titho wrote: > Peter M wrote: >> 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! > Also regular troubleshooting steps: 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 [Non-text portions of this message have been removed]
