I have a VB6 app that has to connect to SQL server 2005 located on another machine.
Now I use a connection string like this
"Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=test1;Network=DBMSSOCN;Server=100.100.100.100;Integrated Security=SSPI"
and it works from my laptop.
The question is, when I move the VB6 app to another machine, what do I need installed there for the same connection string to work?
What stays behind "Provider=SQLOLEDB.1" ?
Is it a single .dll that I only have to put on the other machine and regsvr32 , or it's something more complex?
View Complete Post