Discussion:
[Firebird-odbc-devel] Open database failed FB1.5, ODBC, Win2008-64bit
CDMVSS
2010-07-19 22:28:59 UTC
Permalink
On a windows 2008 64bit machine, firebird 1.5.6 is installed.

Win 64-bit DLL .zip, 351 Kb OdbcFb_DLL_RC1_2-0-0148_x64.zip

is installed as the ODBC driver.

The file for now is on c:\data.fdb

Security.fdb and data.fdb both have everyone as full access.

fbclient.dll and gds32.dll are in win\sys32 directory.

Everytime you try to do a 'test connection' you get "open database <any
path> failed'.

a telnet to port 3050 is successful and firebird is running.

It does not matter what path you put in you will just get an open database
failed.

Any ideas?
--
View this message in context: http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2294710.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.
Michael Möhle
2010-07-20 22:42:02 UTC
Permalink
Maybe use the 32 Bit ODBC Driver?

Michael

-----Ursprüngliche Nachricht-----
Von: CDMVSS [mailto:***@eventsoft.com]
Gesendet: Dienstag, 20. Juli 2010 00:29
An: firebird-odbc-***@lists.sourceforge.net
Betreff: [Firebird-odbc-devel] Open database failed FB1.5, ODBC,
Win2008-64bit


On a windows 2008 64bit machine, firebird 1.5.6 is installed.

Win 64-bit DLL .zip, 351 Kb OdbcFb_DLL_RC1_2-0-0148_x64.zip

is installed as the ODBC driver.

The file for now is on c:\data.fdb

Security.fdb and data.fdb both have everyone as full access.

fbclient.dll and gds32.dll are in win\sys32 directory.

Everytime you try to do a 'test connection' you get "open database <any
path> failed'.

a telnet to port 3050 is successful and firebird is running.

It does not matter what path you put in you will just get an open database
failed.

Any ideas?
--
View this message in context:
http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200
8-64bit-tp2294710p2294710.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.

----------------------------------------------------------------------------
--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
CDMVSS
2010-07-20 23:21:03 UTC
Permalink
Yes I am able to switch the application pool to use 32 bit stuff then
use the odbc DSN from the 32 bit list.
Post by Michael Möhle
Maybe use the 32 Bit ODBC Driver?
Michael
-----UrsprÃŒngliche Nachricht-----
Von: CDMVSS [mailto:[hidden email]
</user/SendEmail.jtp?type=node&node=2296400&i=0>]
Gesendet: Dienstag, 20. Juli 2010 00:29
An: [hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=1>
Betreff: [Firebird-odbc-devel] Open database failed FB1.5, ODBC,
Win2008-64bit
On a windows 2008 64bit machine, firebird 1.5.6 is installed.
Win 64-bit DLL .zip, 351 Kb OdbcFb_DLL_RC1_2-0-0148_x64.zip
is installed as the ODBC driver.
The file for now is on c:\data.fdb
Security.fdb and data.fdb both have everyone as full access.
fbclient.dll and gds32.dll are in win\sys32 directory.
Everytime you try to do a 'test connection' you get "open database <any
path> failed'.
a telnet to port 3050 is successful and firebird is running.
It does not matter what path you put in you will just get an open database
failed.
Any ideas?
--
http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200
<http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200?by-user=t>
8-64bit-tp2294710p2294710.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.
----------------------------------------------------------------------------
--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=2>
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=3>
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------
http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296400.html
To unsubscribe from Open database failed FB1.5, ODBC, Win2008-64bit,
click here
< (link removed) =>.
--
View this message in context: http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296414.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.
Michael Möhle
2010-07-21 13:14:32 UTC
Permalink
I think the Problem is here:

FB 1.5 is 32 Bit only – fbclient.dll and gds32.dll are from this installation and also 32 Bit. The ODBC driver depends on them, and the 64 Bit version of the ODBC can’t use them. So no connect with 64 Bit drivers ;-)

Solution 1 (Tested):

Install 32 ODBC driver and use this one (Use the right ODBC Manager on 64 Bit Windows!)



Solution 2 (untested):

Install client only firebird 2.x in 64 Bit. Then you should be able to connect with 64 bit ODBC driver!



Solution 3 (untested):

Solution 1 + Solution 2: fbclient.dll + gds32.dll from FB 1.5 in c:\windows\syswow64, fbclient.dll + gds32.dll from FB 2.x 64 Bit in c:\windows\system32, both ODBC drivers installed – Connection should be possible from 64 bit ODBC Manager and 32 bit ODBC Manager!



Michael



Von: CDMVSS [mailto:***@eventsoft.com]
Gesendet: Mittwoch, 21. Juli 2010 01:21
An: firebird-odbc-***@lists.sourceforge.net
Betreff: Re: [Firebird-odbc-devel] Open database failed FB1.5, ODBC, Win2008-64bit



Yes I am able to switch the application pool to use 32 bit stuff then
use the odbc DSN from the 32 bit list.
Post by Michael Möhle
Maybe use the 32 Bit ODBC Driver?
Michael
-----UrsprÃŒngliche Nachricht-----
Von: CDMVSS [mailto:[hidden email]
</user/SendEmail.jtp?type=node&node=2296400&i=0>]
Gesendet: Dienstag, 20. Juli 2010 00:29
An: [hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=1>
Betreff: [Firebird-odbc-devel] Open database failed FB1.5, ODBC,
Win2008-64bit
On a windows 2008 64bit machine, firebird 1.5.6 is installed.
Win 64-bit DLL .zip, 351 Kb OdbcFb_DLL_RC1_2-0-0148_x64.zip
is installed as the ODBC driver.
The file for now is on c:\data.fdb
Security.fdb and data.fdb both have everyone as full access.
fbclient.dll and gds32.dll are in win\sys32 directory.
Everytime you try to do a 'test connection' you get "open database <any
path> failed'.
a telnet to port 3050 is successful and firebird is running.
It does not matter what path you put in you will just get an open database
failed.
Any ideas?
--
http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200 <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200?by-user=t>
<http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200?by-user=t <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200?by-user=t&by-user=t> >
8-64bit-tp2294710p2294710.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.
----------------------------------------------------------------------------
--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=2>
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=3>
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------
http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296400.html <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296400.html?by-user=t>
To unsubscribe from Open database failed FB1.5, ODBC, Win2008-64bit,
click here
<<Link Removed>>.
_____

View this message in context: Re: <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296414.html> Open database failed FB1.5, ODBC, Win2008-64bit
Sent from the firebird-odbc-devel <http://firebird.1100200.n4.nabble.com/firebird-odbc-devel-f1284633.html> mailing list archive at Nabble.com.
Loading...