• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 547
  • Last Modified:

"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 = "LookForUpdate"
    UpdateCheckCmd.CommandType = adCmdStoredProc
    UpdateCheckCmd.ActiveConnection = NetDB
    UpdateCheckCmd(1) = LastUpdateStamp
    Set UpdateTbl = UpdateCheckCmd.Execute

Are the test machines missing resources? Any ideas would be appreciated

  • 2
1 Solution
Hi millbor5,

Do you have the same mdac version installed on production and development?

millbor5Author Commented:
thanks friend
glad it helped, and thanks for the grade :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now