var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Ways of connecting to remote databases
I need to know which are the best ways to connect to a remote SQL SERVER 2000 from inside a VB6 application. By remote I mean on a dedicated server outside my LAN that I can access by IP address.
Any opinion would be appreciated.
You cannot do this using NT Authentication because the remote machine will not be on the same Domain.
Use a connection string like this:
"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=YourDataBase;Data Source=YourServer"
KBA - http://support.microsoft.com/default...NoWebContent=1 to connect SQL using VB.
thanks for your reply.
In the connection string
what do I replace YourServer with ?
Do I use http://IPAddress or what ?
Thanks a lot.
Review the knowledgebase article listed above.