100% strange: cannot execute/edit some of my stored procedures in ADP file

  • Thread starter Thread starter Jacques
  • Start date Start date
J

Jacques

Hi there,

I'm facing quite a weird thing with an ADP file (backend is SQL server
2000).

Among the various stored procedures I have, just some of them can be
executed from the database window (by double-clicking it).

The others give various error message, depending of the parameters
structure I have. Possible error messages are:
-ADO-fout: Line1: Incorrect syntax near ')'. Must declare the variable
'@P1'. Statement(s) could not be prepared.
-ADO-fout: Line1: Incorrect syntax near ','. Must declare the variable
'@P1'. Statement(s) could not be prepared.
-ADO-fout: Column or parameter #1: Cannot find data type OUTPUT.
Parameter '@P1' has an invalid data type. Statement(s) could not be
prepared.

When trying to EDIT them in design mode, it gives me the same error
message!!!

The strange thing is that it perfectly works on other clients, using
the same ADP file and the same SQL database. The list of references is
the same too. I suspected different versions of the ADO 2.1 library
but had not a chance to check this yet (I doubt it has something to do
with this).

Can it be related to the fact that the client has local admin
permissions or something?

I can't see what makes these SP look different (that is, those which
work vs those which does not).

I'm totally lost! Would be great if you could help.

Thanks,
Jacques.-
 
ADO2.1!? What a clean computer! You must haven't put anything onto it
besides Ofice2K and Win98(maybe?).

Anyways, since Access Project talks to SQL Server through ADO, and since you
use SQL Server2K (when ADO2.1 was current, SQL Server is in its 6.5), I'd
suggest you first update ADO to newer version (2.8 is the latest, and may be
the last) to see what happens.
 
Good idea, I'll check this. Is there any place I can get ADO 2.8 library?
The version of Access I have only shows version up to 2.7.

J.
 
hello

M le Martien said:
Good idea, I'll check this. Is there any place I can get ADO 2.8 library?
The version of Access I have only shows version up to 2.7.

J.

may
Click to expand...
 
Back
Top