BigInt Type Name is Invalid

Hi. I am using .asp and appending a parameter to a SQL statement

Set objCmd3 = Server.CreateObject("ADODB.Command")
With objCmd3
  .ActiveConnection = mainpipe
  .CommandType = 1
  .Prepared = True
  .CommandText = "select Link from tblDirectoryListing where ListingID = ?;"
End With
objCmd3.Parameters.Append objCmd3.CreateParameter(,20,1,4)

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.


thanks,
Marc
mrferrariAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

amit_gCommented:
Check the definition of table tblDirectoryListing in production server. Column ListingID is BigInt or Int?
mrferrariAuthor Commented:
The database sits on a seperate server. Both prod and dev servers point to the same database.

thanks,
Marc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

mrferrariAuthor Commented:
That seems good. Ill get back to you with the points probably tomorrow. My SA is a slower than a turtle on vacation.

thanks.
amit_gCommented:
They all are ;)
Anthony PerkinsCommented:
Change this:
objCmd3.Parameters.Append objCmd3.CreateParameter(,20,1,4)

To:
objCmd3.Parameters.Append objCmd3.CreateParameter(,20,1,8)

Or:
objCmd3.Parameters.Append objCmd3.CreateParameter(,20,1,0)
mrferrariAuthor Commented:
no dice. didnt work. but tell us what that means?
Anthony PerkinsCommented:
>>but tell us what that means?<<
Set parameter = command.CreateParameter (Name, Type, Direction, Size, Value

BigInt is 8 bytes
Integer is 4 bytes.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.