Solved

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

Posted on 2006-10-23
3
560 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
Comment Utility
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
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
hasOne  challenge 59 87
countX 22 68
File.WriteAllLines problem at random C# ASP.NET 6 52
Counting documents in a Domino View 3 31
RIA (Rich Internet Application) tools are interactive internet applications which have many of the characteristics of desktop applications. The RIA tools typically deliver output either by the way of a site-specific browser or via browser plug-in. T…
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

762 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now