Hi
Which ODBC driver did you used? We have the open source IBPhoenix driver and is OK.
In Firebird 1.5 you can use database aliases, by editing aliases.conf file in firebird root folder.
Connection string that works, with IBPhoenix driver:
FBSqlCon = SQLSTRINGCONNECT([PROVIDER=MSDASQL;DRIVER=Firebird/InterBase(r) driver;DBNAME=localhost:c:\test\test.fdb;UID=SYSDBA;PWD=masterkey])
or if you edited aliases.conf and you have a line :
test = c:\test\test.fdb
FBSqlCon = SQLSTRINGCONNECT([PROVIDER=MSDASQL;DRIVER=Firebird/InterBase(r) driver;DBNAME=localhost:test;UID=SYSDBA;PWD=masterkey])
Using DSN to connect should work, I don't have any problems with that.
Dorin
>Hi Dorin
>I successfully installed Firebird 1.5, and tested the connection to the sample EMPLOYEE database, using the command-line tools ( isql ).
>In VFP, i played a bit with it. I tried to create a DSN then a remote view, and i can see the tables and fields in the view designer, but when saving i get an error ( Invalid Cursor State or something like that ). I guess i'll need to use SPT, but after playing for an hour with connection strings giving me all "Syntax Error", i tend to let it fall. Do you have a sample connection string i could use, or what method do you use?
>
>Thanks,
>Jaime
>