Syntax for TCP Connection

[Meltdown]

Hi,

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

I've tried:

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]

your post was moderated, has now been approved

 

[arnelgp]

try this connection strings:
https://www.connectionstrings.com/sql-server/

 

[Meltdown]

Thanks for the link...so the correct version is:

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]

I am unable to connect my odbc through 13 sql client. 11 is more stable it runs on both 32/64.