Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC
Message
From
27/04/2000 03:25:30
 
 
To
26/04/2000 20:35:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: ODBC
Miscellaneous
Thread ID:
00363906
Message ID:
00364014
Views:
23
You can use SQLSTRINGCONNECT()

Here is an example for oracle:
h=SQLSTRINGCONNECT("DRIVER={Microsoft ODBC for Oracle};UID=DOB;PWD=runtime;SERVER=PDML;")

I don't know the name of the driver you are using and syntax exactly but

What I do is hard code the driver part:
DRIVER={Microsoft ODBC for Oracle};

Then append the server,login and username (UID=DOB;PWD=runtime;SERVER=PDML;")
) from my login dialog and pass it to
SQLSTRINGCON()

To get the syntax correct make a new database container in foxpro and then use the "connections" and create a connection string. You can test the connection here and get the exact syntax.

HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform