Solved

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

Posted on 2006-10-23
3
563 Views
Last Modified: 2006-11-18
Is there a function for this purpose.
0
Comment
Question by:itbabe
3 Comments
 
LVL 4

Accepted Solution

by:
ostdp earned 500 total points
ID: 17788043
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
 
LVL 10

Expert Comment

by:Si_Hibbard
ID: 17788286
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

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
topping3 challenge 14 91
ejb wildfly example 2 25
Selenium docs api java index 3 48
Octopus Deploy: need a Time Event that fires every midnight 2 15
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question