Need help with 80040e14 error

[JennW]

I am not proficient with SQL and have run into a problem that has me baffled.

I upgraded an SQL database from 6.5 to 2000 and everything "appeared" to be working well. Then an enduser reported this error to me.

Adding User...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server] Procedure or function sp_adduser has too many arguments specified.


The tables, queries, and functions were only upgraded, nothing else. When searching Microsoft for a solution the site tells me that there are a number of possibilities.

Any suggestion where to start?

JennW

 

[balves]

sp_adduser has not changed. It still takes 1-3 parameters (and in fact has been obseleted by another proc).

Chances are that the error comes from a parameter with mismatched or missing quotes in it...hence the error message "too many parameters" when it fails.

The error might have nothing to do with the upgrade.

 

[tlbroadbent]

Canyou post the statement that causes the error? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.