I am using SQL 7.0 to establish connection with my ISP SQL ,using the correct UserName/Password given by my ISP.However I encounter this error message and my ISP technical support say that no problem with the server.
Error Source:Microsoft OLE DB Provider for SQL Server
Error Description:Client unable to establish connection [DBNMPNTW]ConnectionOpen [CreateFile()]
Are you saying you can connect to enterprise manager but when you use the dts import wizard you receive this error ? Is the sql server running where on the isp side - and this sql server is version 7 ? If you can connect to enterprise manager ok, can you access tables ... ?