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

>Hi
>I searched myself for something like this in the past, but no luck.
>Firebird is well known in Delphi world because its compatibility with Interbase but I didn't found much informations about its use with Foxpro.
>Fortunately, all things regarding the use of VFP with a database server applies here.
>We have an application ported to use it as database server and currently I work on another project.
>
>Dorin
>
>>Thanks Esparta. I am also looking for specific samples or case studies of VFP with FireBird...
>>
>>Jaime
>>
>>>If do you want documentation about HOWTO: VFP+< YourServer > you will not get it in the Help of the product, luckyly VFP doesn't care about wich batabase server are you using, it only need a ODBC Driver (to work with Remote Views and SQL Pass Through -SPT-) or an OLEDB Provier (to work with ADO+RecordSets), or any of both if you are planning to use the CursorAdapter.
>>>So, you only need a to see VFP Help about the topics Client-Server or a generic HOWTO:VFP+RemoteView, HOWTO:VFP+SPT or HOWTO:VFP+ADO to solve this issue:
>>>
>>>--- Client-Server and VFP ---
>>>http://www.tedroche.com/Present/1999/E-CTECDoc.htm
>>>
>>>--- ADO JumpStart for VFP Developers ---
>>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp
>>>
>>>http://fox.wikis.com/wc.dll?Wiki~CategoryClient/Server
>>>http://fox.wikis.com/wc.dll?Wiki~ProgrammaticallyCreatingDSNs
>>>
>>>--- Why You Should Do Client-Server Development ---
>>>http://www.advisor.com/Articles.nsf/aid/FALIJ01
>>>
>>>--- Migrating Your Visual FoxPro Application to a Client/Server Platform ---
>>>http://www.eps-cs.com/pdf/whitepaper_migrating.pdf
>>>
>>>Of course, you will need to learn how your Database Server deal with internal stuffs like Stored Procedures, Integrity Rules, ANSI-SQL 92, etc.
>>>
>>>HTH.
>>>
>>>
>>>>Hi All
>>>>I am playing with the idea of tighting these two together. I saw some threads from Dorin, but i would appreciate some information about ways of implementing this.