Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 374
  • Last Modified:

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
0
anushahanna
Asked:
anushahanna
  • 3
  • 2
3 Solutions
 
derekkrommCommented:
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
 
derekkrommCommented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
anushahannaAuthor Commented:
>>On the left side of the page,
which tool? where?
0
 
Olaf DoschkeSoftware 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now