Very Computer

Hi!
We've had an application that has been running fine.  The NT Server is at
SP4.

NT Workstation    SQL Server
SP4                        SP4 ------------------- OK
SP4                        SP5a ----------------- FAIL
SP5                        SP5a ----------------- FAIL
SP6                        SP5a ----------------- OK

For a simple query with a where clause using MFC Recordset (MFC 6.0), Open
fails.  More specifically SQLExecute() fails with error code 37000.  "Syntax
error or Access Violation".  The extened text help is all blank.  Can
anybody throw any light on this situation?
Thanks
Aman

Handa - look at the version of sqlsrv32.dll on these workstations.  When you say SQL
Server version are you talking client or server?  Have you applied the SP to the
clients?  Have you applied MDAC to the clients?

Quote:> We've had an application that has been running fine.  The NT Server is at
> SP4.

> NT Workstation    SQL Server
> SP4                        SP4 ------------------- OK
> SP4                        SP5a ----------------- FAIL
> SP5                        SP5a ----------------- FAIL
> SP6                        SP5a ----------------- OK

> For a simple query with a where clause using MFC Recordset (MFC 6.0), Open
> fails.  More specifically SQLExecute() fails with error code 37000.  "Syntax
> error or Access Violation".  The extened text help is all blank.  Can
> anybody throw any light on this situation?
> Thanks
> Aman

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (391 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk

I am getting this error.  I am running NT4 w/service pack 4.  My driver is
3.70.0623.  Is this current?

Dave - relatively recent, but 3.70.0690 ships with SQL 7.0 SP1 and MDAC 2.1 SP2

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (412 entries) see

http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk