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


http://www.dotnetfirebird.org/blog/2005/01/firebird-and-microsoft-jet-feature.html

Steps i have done to migrate from access to firebird

1.Downloaded access to firebird migration tool from this address
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=sql2gdb

2.Downloaded and installed Firebird super server from sourceforge
project page
http://prdownloads.sourceforge.net/firebird/Firebird-1.5.2.4731-Win32.exe?use_mirror=unc

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)
http://prdownloads.sourceforge.net/firebird/Firebird_ODBC_1.2.0.69-Win32.exe

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

http://prdownloads.sourceforge.net/flamerobin/flamerobin-0.2.0-setup.exe?download

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

No comments: