Thursday, May 23, 2013


Howto create a firebird DSN for windows 7. Solved

Follow the next procedure: close VWD if opened.
First case. Client Server structure:
First install a Firebird ODBC build from Firebirdsql.org.
C:\Windows\SysWOW64>find odbcad32.exe>click on it>Add button>Select Firebird/Interbase(r) driver>in the textbox "Data source name" insert a cutom name>In Database textbox browse your database>In client DLL browse fbclient.dll from your Firebird Application folder>In user database textbox insert database admin username>in "password" textbox insert admin password>In "character set" combobox select NONE. Now test the connectiion>Press the confirm button.
Second case. Embedded server:
First install a Firebird ODBC build from Firebirdsql.org.
Second dowload embedded server package from Firebirdsql.org. Unpack it in a custom folder.
C:\Windows\SysWOW64>find odbcad32.exe>click on it>Add button>Select Firebird/Interbase(r) driver>in the textbox "Data source name" insert a cutom name>In Database textbox browse your database>In client DLL browse for fbembed.dll from the custom folder in which the embedded server has been unpacked>In user database textbox insert database admin username>in "password" textbox insert admin password>In "character set" combobox select NONE. Now test the connection>Press the confirm button.

2 comments :

Power cords said...
firebird DNS what is that? can you please tell me what is the firebird function in win 7?
Giovanni G said...
DSN are used to compose the connection string for Reports built with Reporting Services for Firebird databases