Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: ADO
Expertise: Beginner
Mar 22, 2000

ADO Connection String

Question:
What is the syntax for accessing a FoxPro 2.5 table using an ADO connectionstring? I want to be able use a DSN-less connection and access different tables depending on the user request.

Answer:
The easiest way to find out is to create a file DSN and then open the file in Notepad. You will find name value pairs separated by carriage returns, replace the carriage returns with semicolons and you will have a connectionstring.

FoxPro treats the directory as the database so you can access any of the tables by specifying the table name in the SQL statement.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap