Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLstringconnect vfp6.0
Message
From
25/04/2002 11:18:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQLstringconnect vfp6.0
Miscellaneous
Thread ID:
00649164
Message ID:
00649164
Views:
44
Hello group

This is an example from MSDN Audat is a training server with no password

lcDSNLess="DRIVER = {SQL Server};" ;
+ "SERVER=Audat;" ;
+ "UID=sa;" ;
+ "DATABASE=PUBS;"
lnConnHandle=sqlstringconnect(m.lcDSNLess)

When I run it all it does is open a open file dialog called select Data
Source and asks me to select a data source.
I would like it to just create the connection handle and let me run some
commands in the Pubs database

Also if I was connecting to a remote server with just an ip address instead of audat would i just use

lcDSNLess="DRIVER = {SQL Server};" ;
+ "SERVER=255.255.255.64 ;" ;
+ "UID=sa;" ;
+ "DATABASE=PUBS;"
lnConnHandle=sqlstringconnect(m.lcDSNLess)

instead??
Next
Reply
Map
View

Click here to load this message in the networking platform