Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Error connecting to existing database using Windows Server 2008 R2 / 64 bit [ODBC93] #91

Closed
firebird-automations opened this issue Nov 4, 2010 · 5 comments
Closed

Error connecting to existing database using Windows Server 2008 R2 / 64 bit [ODBC93] #91

firebird-automations opened this issue Nov 4, 2010 · 5 comments
Assignees
@alexpotapchenko
Labels
affect-version: 2.0 RC1 priority: blocker resolution: wontfix type: bug

Comments

@firebird-automations
Copy link

Submitted by: Sue Allen (sallen)

We have an existing ODBC connection to a database on our production server. We are in the process of setting up a new server and are not able to set up an ODBC connection to the same database. We are using the same userid, password, and database.

Creating the base ODBC connection information succeeds, but all attempts to actually test / connect to the database fail.

Upon clicking the "Services" button and going to the "Users" tab, we receive the following error:

"sql code \-904, fbcode 335544375 \- Unable to connect to data source: library 'gds32\.dll' failed to load"

I did download the version of ODBCFB.DLL from issue #⁠ ODBC72 this morning; this did not fix the error.
@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Do you have 64-bit gds32.dll (fbclient.dll) in system32?
Unable to connect to data source: library 'gds32.dll' failed to load" - ODBC driver can not load (find) a client library.

@firebird-automations
Copy link
Author

Commented by: Sue Allen (sallen)

No.

The only "gd..." dll in c:\windows\system32 is gdi32.dll.

Should I try copying gds32.dll there? If so, where would it have installed to?

Thanks!

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

In my environment:
c:\Program Files\Firebird\Firebird_2_1\bin\fbclient.dll - Firebird client library.
You can copy fbclient.dll to system32 with name - gds32.dll.
Also you can select Firebird client library in the Firebird ODBC driver settings.

@firebird-automations
Copy link
Author

Commented by: Sue Allen (sallen)

DONE! It worked. Thank you so much!!!

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Closed [ 6 ]

resolution: Won't Fix [ 2 ]

assignee: Alexander Potapchenko [ lightfore ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@alexpotapchenko alexpotapchenko

Labels
affect-version: 2.0 RC1 priority: blocker resolution: wontfix type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@alexpotapchenko @firebird-automations