Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Server Alias-Less connection
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00671908
Message ID:
00672789
Views:
9
This is my connection string
DRIVER=SQL Server;SERVER=Ovsps_TCP;uid=;pwd=;APP=Fap;DATABASE=fap;

Apperantly i have to read more about DSN-less connection.
Do you know where i could find detailed info on the DSN-less connection?
Thanks.
Kamil.

>I don't know how your DSN-less connection string looks like, but I think that what you are missing is the "address" and "network" parameters in the connection string.
>
>Address could be an IP address, followed by ",1433" which is the port that SQL Server listens to.
>
>Network indicates the network library that the SQL Server ODBC driver will use. It refers to the actuall DLL that the ODBC driver will use.
>
>For example a network value of "DBMSSOCN" will use "DBMSSOCN.DLL" to connect to SQL Server via TCP/IP. A value of "DBNMPNTW" will use "DBNMPNTW.DLL" to connect to SQL Server via Named Pipes.
>
>
>cConnStrin = "SERVER=123.123.123.123;DRIVER=sql server;" +;
>             "UID=sa; PWD=; DATABASE=northwind;" +;
>             "Address=123.123.123.123,1433;" +;
>             "Network=DBMSSOCN"
>
>nConnHandle = Sqlstringconnect( cConnString )
>
>
A moment of silence is our cosmic reset button.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform