Howto create a DSN

Posted by dragon on Friday, 30 September 2011

Follow the next procedure: close VWD if opened.
First case. Client Server structure:
First install a Firebird ODBC build from Firebirdsql.org.
Start>Settings>control Panel>Administrative tools>Data source OBDC>"User DSN" tab>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.
Seconf doowload embedded server package from Firebirdsql.org. Unpack it in a custom folder.
Start>Settings>control Panel>Administrative tools>Data source OBDC>"User DSN" tab>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.

Goodbye.

{ 0 comments... read them below or add one }

Post a Comment