Avatar of anushahanna
anushahanna
Flag 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
Microsoft SQL Server

Avatar of undefined
Last Comment
anushahanna

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
derekkromm

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
anushahanna

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

what is the point of the msdn link?
SOLUTION
derekkromm

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
anushahanna

ASKER
>>On the left side of the page,
which tool? where?
SOLUTION
Olaf Doschke

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
anushahanna

ASKER
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")
------------------
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck