OLE DB Version Property example

how would use run the above with tsql statement?

http://msdn.microsoft.com/en-us/library/aa173525%28v=sql.80%29.aspx
thanks
LVL 6
anushahannaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
derekkrommConnect With a Mentor Commented:
Its not something that you can find on the SQL Server. Its a property of the OLEDB connection you are using in your application.

You can do this:

Dim adoCmd
Set adoCmd = CreateObject("ADODB.Command")

Dim sBasePath
sBasePath = adoCmd.Properties("OLE DB Version")
0
 
anushahannaAuthor Commented:
OK - do you test the above with access? if not , what tool?

what is the point of the msdn link?
0
 
derekkrommConnect With a Mentor Commented:
It is a dynamic property of an ado/oledb connection

On the left side of the page, you can follow the arrows all the way up the "tree" of what it all means ("Dynamic Properties", "Programming ADO SQL Applications", etc)

0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Take the quiz
 
anushahannaAuthor Commented:
>>On the left side of the page,
which tool? where?
0
 
Olaf DoschkeConnect With a Mentor Software DeveloperCommented:
"which tool? where?"

The left side of the msdn page you mention.

The OLEDB Version is a property of the connection, not of the server or database.

"Applies To:Connection Object"

So this is not something that translates to t-sql or any other sql dialect. It's not querying the server or database, it's determining the supported general oledb version by the used oledb provider, so it's a query towards the driver.

Bye, Olaf.
0
 
anushahannaAuthor Commented:
OK - in that case, can we determine which is the highest "OLE DB provider" available for any connection on the server or for any DB?

perhaps through Dos command or Javascript code?

where(which tool) do you use to run derekkromm's code?
----------------

Dim adoCmd
Set adoCmd = CreateObject("ADODB.Command")

Dim sBasePath
sBasePath = adoCmd.Properties("OLE DB Version")
------------------
0
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.

All Courses

From novice to tech pro — start learning today.