millbor5
asked on
"Type name is invalid" error when executing stored proceedure.
When executing the following code. I get an error "Type name is invalid" #-214?????? on the last line. The command object is executing a stored proceedure on a SQL server 2000 database. The odd thing is that this code works flawlessly on the development machine but errors on test machines.
dim LastUpdateStamp as long
Dim UpdateCheckCmd As New ADODB.Command
Dim UpdateTbl As New ADODB.Recordset
UpdateCheckCmd.CommandText
UpdateCheckCmd.CommandType
UpdateCheckCmd.ActiveConne
UpdateCheckCmd.Parameters.
UpdateCheckCmd(1) = LastUpdateStamp
Set UpdateTbl = UpdateCheckCmd.Execute
Are the test machines missing resources? Any ideas would be appreciated
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
glad it helped, and thanks for the grade :)
ASKER