Guest_imported
New member
- Jan 1, 1970
- 0
I have a stored procedure in SQL-Server 7.0 containing this :
CREATE PROCEDURE sdtest2 (@Tal int) AS
INSERT INTO TEST (Test) VALUES (@Tal)
SELECT MAX(ID) FROM TEST
--------------------------------------------
This works fine with ODBC. It returns the Max ID.
But it fails, when I switch to SQLOLEDB.
Does anyone have an idea, why it fails???
Regards,
Kenneth
CREATE PROCEDURE sdtest2 (@Tal int) AS
INSERT INTO TEST (Test) VALUES (@Tal)
SELECT MAX(ID) FROM TEST
--------------------------------------------
This works fine with ODBC. It returns the Max ID.
But it fails, when I switch to SQLOLEDB.
Does anyone have an idea, why it fails???
Regards,
Kenneth
