Hi. I am using .asp and appending a parameter to a SQL statement
Set objCmd3 = Server.CreateObject("ADODB.Command")
.ActiveConnection = mainpipe
.CommandType = 1
.Prepared = True
.CommandText = "select Link from tblDirectoryListing where ListingID = ?;"
20 refers to a variable type of bigint, this works fine on my development machine, but when I transfer the application to my production machine I am getting the following error.
Microsoft OLE DB Provider for SQL Server error '80040e30'
Type name is invalid.
If I change the datatype to 3 (int), in some cases where the number is small this will work.
Does this have to do with the driver, could it be that my driver on the production machine is not SQL 2000. Bigint is a new datatype in SQL 2000.