Question: How can I tell what version of ADO I am using? [ Print this FAQ]
Answer: Use the
Version property of the ADODB.Connection object. In this quick and dirty example we'll create a Connection object and print out its
'Create Connection object
Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") 'Print out version property Response.Write("You are using ADO Version " & objConn.Version)
For more information on ADO, visit Microsoft's Universal Data Access site:
http://www.microsoft.com/data/. Or, to go directly to a reference manual for ADO, try this Microsoft site.
FAQ posted by Scott Mitchell at
9/24/2000 12:40:01 AM to the
Databases, General category.
This FAQ has been viewed 43,809 times.
Do you have a FAQ you'd like to suggest?
Suggestions? Comments? If so,
send it in!
Also, if you'd like to be a FAQ Admin (creating/editing FAQs),
let me know! If you are looking for other FAQs, be
sure to check out the 4Guys
FAQ and Commonly Asked Messageboard Questions!
Most Viewed FAQs: 1.) How can I format numbers and date/times using ASP.NET? For example, I want to format a number as a currency. ( 761643 views)
2.) I am using Access and getting a 80004005 error (or a (
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem?
3.) How can I convert a Recordset into an array? Also, how can I convert an array into a Recordset? ( 202549 views)
4.) How can I quickly sort a VBScript array? ( 196039 views)
5.) How can I find out if a record already exists in a database? If it doesn't, I want to add it. ( 156019 views)
6.) How do I display data on a web page using arrays instead of Do...While...MoveNext...???... ( 152331 views)
7.) When I get a list of all files in a directory via the (
FileSystemObject, they aren't ordered in any reasonable way.
How can I sort the files by name? Or by size? Or by date created? Or...
8.) For session variables to work, must the Web visitor have cookies enabled? ( 110162 views)
9.) Can I send emails ( without using CDONTS? 107083 views)
10.) How can I take the result of a ( SELECT...MULTIPLE or a group of same-named checkboxes and turn it into a query? That is, if the user selects 3 answers, how can I construct a query that looks for all 3? 106308 views)
Last computed at 9/17/2007 3:22:00 AM