Firebird Database Testing
Hello, My application runs with Firebird db. In current task i need to fire queries and check and compare the results. Please let me know how do i connect to the db and execute the task. ...
Forum Discussion
Hi Nisha,
ODBC has no idea about .Net, that is why its provider is not listed in the list of available drivers.
I would recommend IBprovider (free, from http://www.ibprovider.com/) which worked for me.
Its ADO connection string looks like this:
Provider=LCPI.IBProvider.3.Free;Password=<pwd>;Persist Security Info=True;User ID=<userID>;Location=<server>:<full path to .fdb relative to server>;auto_commit=True;dbclient_library=fbclient.dll;dbclient_type=fb2.0
ODBC has no idea about .Net, that is why its provider is not listed in the list of available drivers.
I would recommend IBprovider (free, from http://www.ibprovider.com/) which worked for me.
Its ADO connection string looks like this:
Provider=LCPI.IBProvider.3.Free;Password=<pwd>;Persist Security Info=True;User ID=<userID>;Location=<server>:<full path to .fdb relative to server>;auto_commit=True;dbclient_library=fbclient.dll;dbclient_type=fb2.0
