Vbscript question : how to create a sqloledb connection on a client pc ?

Is there a function for this purpose.
itbabeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ostdpConnect With a Mentor Commented:
Have a look at this reference from Microsoft for using ADO with vbscript.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadoinvbscript.asp

for some example of the above technology usage see

http://www.activexperts.com/activmonitor/windowsmanagement/adminscripts/enterprise/databases/

Hope this helps.
0
 
Si_HibbardCommented:
Also see this tutorial on connection strings -> http://www.tnsites.com/support/s_databaseconn.asp

Example taken from above link VBscript in an ASP page:

<%
Set Cnn = Server.CreateObject("ADODB.Connection")
Cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=D:\html\users\yourdomaincom\database\mydatabase.mdb"
%>
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.