Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dsnless connection
Message
From
06/11/1998 02:54:37
Jeroen Naus
Harte-Hanks Europe
Hasselt, Belgium
 
 
To
05/11/1998 13:19:49
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00154851
Message ID:
00155128
Views:
25
I found some examples of DSN less connections on www.dejanews.com but they all refer to an access database, and I need to connect to SQL Server. Anyway I found the syntax so it is possible. Here it is !

lcTest = "DRIVER=SQL Server;SERVER=servername;UID=userid;PWD=password;APP=Microsoft® Visual FoxPro®;WSID=workstationid;DATABASE=databasename"
lnTest = sqlstringconnect(lcTest)
? lnTest
Previous
Reply
Map
View

Click here to load this message in the networking platform