I'm making the switch from DreamWeaver to VStudio 2005. It's killing me ...
All i want to do is develop on a local machine to a SQL 2005 server on a remote host. Here is the connection string i'm attempting to use ... no good.
Provider=SQLOLEDB;Data Source=<Remote SQL Server IP ADDRESS>,1433;UID=SA;Password=pww;Initial Catalog=DBSQL;Network Library=DBMSSOCN;
The connection string inside DreamWeaver - THAT WORKS is:
Provider=SQLOLEDB.1;Data Source=U15169771\SQLSERVER;UID=SA;Password=pww;Initial Catalog=DBSQL;
you'll notice that the name of the SQL server on the reomte server is U15169771\SQLSERVER. So ... I've tried to include that in the new "Data Source'" tag using UNC path like ...
Data Source=<Remote SQL Server IP ADDRESS>,1433/U15169771\SQLSERVER - doesn't work ... obviously.
What am i doing wrong or what do i need to do to make a connection to the remote SQL server.
I need a connection string that works.