ODBC Dumb-Bunny

[gothbabe55]

Hi

I know that I am probably being very silly here, but I have a database that I need to connect to in VFP. The database is Interbase. I have installed the ODBC drivers for it etc. and am able to connect to it in Word and Access. However, I just cannot see how on earth I connect to it in VFP!!! For example, do I go File>Open etc? I just cannot see an option for ODBC connectivity.
Please help this dumb little bunny..........

 

[Mike Gagnon]

gothbabe55

First try if the right ODBC driver is available to you. Create a textfile on your desktop and change the extension from ".txt" to ".udl". Double-click on the newly created file and see if you can connect to it that way. BTW next time try a more "professional sounding title for your post".

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[wgcs]

In VFP, there are multiple ways to connect to an ODBC data source. Remember, however, that VFP is a Developer's tool, not a User's Application: "File - Open" is rarely used in the IDE for work other than opening development files.

You should explore:
SQLConnect() (establish ODBC connection)
SQLStringConnect() (Better)
SQLExecute() (send SQL command across ODBC connection)
DBC Database Containers with Remote Views

Perhaps this will help:

http://fox.wikis.com/wc.dll?Wiki~SqlStringConnect

 

[gothbabe55]

Thanks for your replies - wgcs, your input has really helped - I now know what must be done. Thanks!

 

[wgcs]

You're welcome!