It sounds like you are using the wrong connection string, here is an example of a connection string I use from PDA to SQL server:
m_ConnectionString = "Data Source=1.2.3.4;Initial Catalog=DatabaseName;"
m_ConnectionString += " User ID=" & UserID
m_ConnectionString += "; Password=" & Password
If you are sure teh connection string is correct (especially yhe IP address) then maybe you have a firewall blocking the SQL port, the SQL port by default will be 1433 for SQL 2000 and for SQL 2005 you need to google finding the port, because it uses a dynamic port assignment thing. |