Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

VBScript connection to DB

Comment:

I have an MS Access DB that I need to connect to and update through a VBScript file. I know how to do this in ASP, but the Server class which is used to create the connection object does not exist in VBScript. Is there any other way to create a connection to a DB through a VBScript file? Thanks

Name: Chi Happens
Date: May 7, 2005 at 05:58:55 Pacific

Reply:

you can use CreateObject("") instead of Server.CreateObject("") Chi They mostly come at night...mostly

0

QBasic APPEND or some oth...

Kernel32's Beep() to WAV/...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, My software uses ADO to log data to a MS Access database every 10 seconds or so. Also, queries are run every 5 minutes to compile the data. I open a transaction for the compilation every 5 minutes...

Summary: Hi All Can you please let me know how a VBSCript can connect to a SQL Server, run a pre-defined stored procedure (a simple select that returns a table results), then output the table into a file and s...

Summary: I have built MS-Access-based websites, and have had no problem establishing a connection to them. Here is typical code: myConnection = Server.CreateObject("ADODB.Connection") connectionString = "DRIVE...