Problems execuiting a stored procedures in SQL Server 2005

W

wardellcastles

I have a Visual Basic application that works fine under SQL Server
2000. However I am having problems with it under SQL Server 2005.

Here's the code in abbreviated form.


Set QryPost = New ADODB.Command
....


With QryPost
.CommandText = "ctsp_insert_fulfillment_Acquisition"
.CommandType = adCmdStoredProc
.ActiveConnection = ADOcon
End With
...


With QryPost
.Parameters.Refresh
.Parameters(1).Value = 'ABC'
.....


When I run this application connecting to a SQL Server 2000 database,
the QrtPost object shows 17 parameters in the Debug screen. This is
correct. However when I run this same application against a 2005
SQL Server database, the QryPost object contains 0 parameters and of
course subsequently fails on the .Parameters(1).Value = 'ABC' as
there
are no parameters in the QryPost Object.


My MDAC version is 2.8


Any suggestions will be welcome
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run a SQL Stored Procedure from VBA 0
Passing dates to Sql Server 2005 stored procedure 3
Run SQL Server stored procedure in Excel macro 1
Does a Pivot External Source to SQL Server stay connected? 0
Access update query 2
Excel returning a record set from a stored procedure. 3
SQL Stored proc - passing parameters 1
Return Values from SQL Server to MS Access 1

Top