Syntax for TCP Connection (1 Viewer)

Meltdown

Registered User.
Local time
Today, 08:54
Joined
Feb 25, 2002
Messages
472
Hi,

Does anyone know the correct syntax to create a TCP connection to a default instance of a Sql Server.

I've tried:

Code:
ODBC;DRIVER=SQL Server Native Client 11.0;SERVER=127.0.0.1,1433;DATABASE=myDatabaseName;Trusted_Connection=Yes;;TABLE=dbo.Customers

That doesn't work.

Regards
 

CJ_London

Super Moderator
Staff member
Local time
Today, 08:54
Joined
Feb 19, 2013
Messages
16,553
your post was moderated, has now been approved
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:54
Joined
May 7, 2009
Messages
19,170
try this connection strings:
https://www.connectionstrings.com/sql-server/
 

Meltdown

Registered User.
Local time
Today, 08:54
Joined
Feb 25, 2002
Messages
472
Thanks for the link...so the correct version is:

Code:
ODBC;DRIVER=ODBC Driver 13 for SQL Server;SERVER=tcp:127.0.0.1,1433;DATABASE=myDatabaseName;Trusted_Connection=Yes;TABLE=dbo.Customers

Can I just add that it's very important to get the lastest ODBC driver for the clients using Windows 10 connecting to a Sql Server back end -- a big increase in performance on a VPN.

https://www.microsoft.com/en-us/download/details.aspx?id=50420

Regards
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:54
Joined
May 7, 2009
Messages
19,170
I am unable to connect my odbc through 13 sql client. 11 is more stable it runs on both 32/64.
 

Users who are viewing this thread

Top Bottom