Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 ADO / ASP Output

Author  Topic 

SamC
White Water Yakist

3467 Posts

Posted - 2002-10-27 : 12:02:49
I have a stored procedure with an output parameter declared as

@OutputMessage VARCHAR (255)

There are several ADO character types that sound like a fit, but are not clearly defined.

adLongVarChar (A long string value)
adLongVarWChar (A longnull-terminated string value)
adBSTR (A null terminated character string)
adChar (A string value)
adVarChar (A string value)
adVarWChar (A Null terminated Unicode string )

Is there a map for these ADO strings into the corresponding SQL datatypes for me??

Sam

saglamtimur
Yak Posting Veteran

91 Posts

Posted - 2002-10-27 : 14:24:47
search BOL for "mapping ado data types" and you will see a line has titled "mapping data types" location "ado and sql server". it has complete listing.

Go to Top of Page
   

- Advertisement -