Hi
I don't have any problems. I can create remote views and update everything I need.
Maybe some system DLLs are outdated (I remember something about msvc6cp.dll). What OS you have?
We use remote views and SPT (mainly for reports or user defined searches)



>Hi Dorin
>I use IBPhoenix driver indeed. Your connection string works, but i still get an error message when trying to create a remote view with this connection to the EMPLOYEE.FDB sample database( Invalid Cursor State ). I get the error now when trying to save the view ( i see all the tables in the EMPLOYEE.FDB, and i can add fields ).
>Do you use SPT, or views?
>
>TIA
>Jaime
>
>>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
>>>