Link to home
Start Free TrialLog in
Avatar of itbabe
itbabe

asked on

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

Is there a function for this purpose.
ASKER CERTIFIED SOLUTION
Avatar of ostdp
ostdp

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
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"
%>