Link to home
Start Free TrialLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of derekkromm
derekkromm
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anushahanna

ASKER

OK - do you test the above with access? if not , what tool?

what is the point of the msdn link?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>On the left side of the page,
which tool? where?
SOLUTION
Avatar of Olaf Doschke
Olaf Doschke
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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")
------------------