BDE and SQL 7 driver problem

[TidewaterJoe]

I have legacy Delphi 4 system. Until recently, we were using BDE 5.0 and SQL 6.5 and having no problems. However, experienced problems when moving to Win2000 machines, so upgraded to SQL 7.0 and BDE 5.1. Now, accessing app internally using BDE's MSSQL driver, we're doing great. However, when accessing from external location using ODBC's SQL Server driver, for some reason ALMOST everything works...except for some queries that use DATEPART function to report with month start and stop range...Get an error "q.Field Not Found Discover Month" I'm wondering if I have some issues with SQL Server 7.0 OR with the BDE 5.1? Any ideas greatly appreciated.

 

[mikeEd]

Have you tried updating the clients' MDAC?

 

[LucieLastic]

You should be able to run just the MDAC_TYP.EXE file but it's making sure you run the right one that can be a problem.

 

[mikeEd]

I'd go for 2.6 SP1.