Home → FlySpeed SQL Query → Connection 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 |