Unanswered: Remote SQL Server Database Connection Problem using VB6 using OLEDB
Please Help me,
We had a Software application Developed using VB6 with MSSQL SERVER2005 as Database(Remote) in ZNet India® - Web Hosting, Dedicated Server & Reseller Hosting our web space provider , the application was working properly until they upgraded the Server configuration, Now we are not able to connect with the database using the normal OLEDB connection String
using Microsoft Data Link Provider It is not working and generating Errors.
When they tried in their system with the same connection string using Microsoft Data Link Provider it is connecting with the database without any problems. ( We also viewed through Team Viewer their system)
Please help us to solve this connection problem using OLEDB, because when we use SQL NATIVE CLIENT we will not be able to connect using Crystal Reports 10 because CR10 will not support SQL NATIVE CLIENT.
REWRITING THE ENTIRE APPLICATION TO USE SQL NATIVE CLIENT IS VERY DIFFICULT.
try using the oledb connection string utility here to build a working connection string, then paste the resulting connection string into your app (or a text file, etc.)
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert