Monday, October 19, 2009

Howto create a firebird DSN for windows xp

Notice: this procedure is valid only for windows xp: For windows 7 read this post: http://firebird-vbnet.blogspot.it/2013/05/howto-create-dsn-for-windows-7.html
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.Done.
Goodbye.

1 comment:

  1. If you get "unavailable database" error try using the localhost: connection string rather than a physical path to the Firebird database

    ReplyDelete