I have a VB6 full application suite that we have migrated from dBaseIV to SQL 2008 R2. Some modules have been re-written in VB2012 but many of the more complex ones are still in VB6. In the VB6 apps, we are currently using MS ActiveX Data Objects 2.7 library and haven't experienced any KNOWN problems.
However, now I am trying to access a remote SQL Server. No problem in VS2012. I just changed the server settings and it works. In VB6 it is not working, at least on my W7 dev machine.
I have defined a DSN using the SQL Server Native Client 11 (also used 10) and it was successful. However, trying to set one up using the SQL Server driver (SQLSRV32.DLL) does not work.
In VB6, when I try to connect to the database using the DSN, I get an error that the DSN contains an architecture mismatch between the driver and application.
I am sure I have something mismatched . . but I'm not sure what it is. Any help would be sincerely appreciated!