Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create a ODBC DATASOURCE programmatically
Message
From
09/11/2001 06:23:17
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
09/11/2001 06:09:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00579560
Message ID:
00579565
Views:
28
>Hi all,
>
>How to create a ODBC DATASOURCE programmatically
>
>Thanks in advance
>Petros

Petros,
You coudl use create connection. ie :
create connection SQLNORTHWIND ; 
 connstring "DRIVER=SQL Server;SERVER=myserver;UID=user;DATABASE=northwind;PWD=password"
If you'd use SQL passthrough then you could have the same connection with SQLStringConnect :
lnHandle=SQLStringConnect("DRIVER=SQL Server;SERVER=myserver;UID=user;DATABASE=northwind;PWD=password")
Also check faq#8039 for another connection string to Access MDB.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform