I have an VB6 application developed on a 32-bit Windows XP machine that connected to a SQL Server Express 2005. The organization upgraded their workstations to 64-bit Windows 7 and their database application to SQL Server 2012.

To help me troubleshoot problems encountered, I built a development machine and installed VB6 Enterprise and SQL Server Express 2012. I have been successful in opening and compiling the VB6 application developed on the XP machine error free. When I try to execute the application, I receive the following error:
Name: VB6ConnectionError.gif Views: 3332 Size: 4.8 KB

I am using the following connection parameter: Private adoConnection As ADODB.Connection
My connection string is: "Provider=SQLNCLI11.1;Data Source=Computer\SQLExpress;Initial Catalog=RELIANT;Integrated Security=SSPI;Persist Security Info=False;User ID='';Initial File Name='';Server SPN='';Trusted_Connection=YES" [to test the connection string, I created a brand new VB6 project and was able to successfully connect to the database via an ADO controls]

When I use the same connection string in the application from the Windows XP machine, it bombs with error attached to this post. I have searched this forum and Internet hoping to find an answer to this particular connection issue, but nothing specific to my situation. I think it has something to do with either a reference not being enabled in the application or the application is not being executed in 32-bit mode.

If someone could point in the right direction, I would appreciate it.