What DLL do I need to place at system32 to connect to remote MSSQL using VB6
This is the error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
I'm using 32bit, the server is configured to accept remote access, I can
even open it using management studio remotely.
My app is working perfectly in local but not in remote.
this is my connection string:
Provider=SQLOLEDB;Password=1234;Persist Security Info=True;User
ID=sa;Initial Catalog=test;Data Source=127.0.0.1
I just change the ip to the ip of remote server, but what dll will I need
w/o using ODBC and installing mssql to client unit?
No comments:
Post a Comment