Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server driver issue??

Author  Topic 

flashg
Starting Member

1 Post

Posted - 2004-11-30 : 09:51:04
Hi I have transferred a SQL Server database from my online host to my local server. Having changed the connection configuration etc... and all connects fine BUT I am getting some odd errors like this :

quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Wrong number of arguments used with function in query expression 'tblTracks.trackID=IsNull(398,20)'.

/wsr_sql/pages/result.asp, line 170


I have figured out that the server is trying to translate the SQL using VB but I am stumped to figure out why. Any help would be appreciated =D
   

- Advertisement -