Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a VFP ODBC Programmatically
Message
 
To
08/02/2000 12:17:53
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Windows API functions
Miscellaneous
Thread ID:
00328732
Message ID:
00329026
Views:
24
thanks.
I found it. Here it is:

DECLARE INTEGER SQLConfigDataSource IN odbccp32.DLL INTEGER, ;
INTEGER, STRING, STRING

settings= "DSN=mydsn" +CHR(0)+;
"Description=my description" +CHR(0)+;
"SourceDB=c:\data\mydb.dbc" +CHR(0)+;
"SourceType=DBC"

x = SQLConfigDataSource(0,1,;
"Microsoft Visual Foxpro Driver",settings)


The same API, when used with SQL server, has the attributes:
SERVER=servernam DATABASE=pubs, etc., in the settings.
Bharat Sanghvi
Vice President, Information Technology
Deyta
Continuous Quality Measurement Systems
Previous
Reply
Map
View

Click here to load this message in the networking platform