HomeFlySpeed SQL QueryConnection to remote SQL server data base

Connection to remote SQL server data base


I need to connect to SQL server data base using TCP/IP.
I don't see this type of connection in FlySpeed SQLQuery menus.
Does it exist in this tool?
Thank you.
Eugene
Eugene | email
May 17 2012, 06:09 PM
Use the Generic OLE DB connection type, choose OLE DB Provider for SQL Server and specify the following connection string:

Provider=sqloledb;Network Library=DBMSSOCN;Data Source=xxx.xxx.xxx.xxx,1433;Initial Catalog=myDatabaseName;User ID=myUsername;Password=myPassword
Sergey Smagin | email
8 hours, 12 mins since original post
This topic is closed