Solved

OLE DB Version Property example

Posted on 2011-03-04
6
363 Views
Last Modified: 2012-05-11
how would use run the above with tsql statement?

http://msdn.microsoft.com/en-us/library/aa173525%28v=sql.80%29.aspx
thanks
0
Comment
Question by:anushahanna
  • 3
  • 2
6 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 333 total points
ID: 35041733
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
 
LVL 6

Author Comment

by:anushahanna
ID: 35041739
OK - do you test the above with access? if not , what tool?

what is the point of the msdn link?
0
 
LVL 15

Assisted Solution

by:derekkromm
derekkromm earned 333 total points
ID: 35041742
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 6

Author Comment

by:anushahanna
ID: 35041754
>>On the left side of the page,
which tool? where?
0
 
LVL 29

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 167 total points
ID: 35042970
"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
 
LVL 6

Author Comment

by:anushahanna
ID: 35063459
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now