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:

  1. firebird DNS what is that? can you please tell me what is the firebird function in win 7?

    ReplyDelete
  2. DSN are used to compose the connection string for Reports built with Reporting Services for Firebird databases

    ReplyDelete