Firebird News

Friday, February 04, 2005

Use firebird not access on server !

Had some problems with a windows server

[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.

I tested to see if the problem was from odbc (was not there ) then restarted the webserver ) - it seems was an exclusive lock problem (access "database" was not corrupt)

Long term solution:

database should be moved from access to real multi-threaded sql database (firebird) it have full odbc support and more scalable

Steps i have done to migrate from access to firebird

1.Downloaded access to firebird migration tool from this address

2.Downloaded and installed Firebird super server from sourceforge
project page

3. The conversion wizzard was run and data copied from access to
firebird (using the odbc connection) also installed odbc driver for firebird server (needed for asp)

4. Downloaded flamerobin tool for database administration and to see if
all was imported ok (auto incremental fields , tables , data)

5. Testing appliacation with new database created [work in progress]

No comments: