


It is giving an ERROR (Error No.-2147467259 at Line No. We contacted our service providers they informed that they asked us to try with the SQL Server Instance adoConn.Open PROVIDER=MSDataShape Data Provider=SQLOLEDB.1 Persist Security Info=0 User ID=UserName Password=Password Initial Catalog=DatabaseName Data Source=servername/instancename

We had a Software application Developed using VB6 with MSSQL SERVER2005 as Database(Remote) in 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 adoConn.Open PROVIDER=MSDataShape Data Provider=SQLOLEDB.1 Persist Security Info=0 User ID=UserName Password=Password Initial Catalog=DatabaseName Data Source=servername
