I have an application that connects to a SQL 2000 server though a File based
DSN located on a file server. The application behaves fine untill I install
MS Office it then returns no data from any queries that the application
requests. I have looked at the following.
Microsoft Data Access Components (MDAC) is version 2.5 Sp3 before the Office
install.
After the Office install MDAC is version 2.8 Sp1
When I look at the queries in Profilers the following is displayed
This Works
Exec sp_prepare @P1 output, NULL, N’SELECT Exitem_Desc FROM vtblProcess4
WHERE vtblProcess4.Exitm_No = ‘’39006590’’’,1
This does not Work
Exec sp_prepare @P1 output, NULL, N’SELECT Exitem_Desc FROM vtblProcess4
WHERE vtblProcess4.Exitm_No = ‘’39006590’’’
Am I looking at the right area with MDAC, is there any way to make the newer
version backwards compatible?
Thanks for any help,
Mark.
>> Stay informed about: Client’s_connection_behaving_dif