Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


use vbscript locally, how to access mdb?

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,1501
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> use vbscript locally, how to access mdb?
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
use vbscript locally, how to access mdb? - 10/20/2004 10:12:45 PM   
  xtian

 

Posts: 1
Score: 0
Joined: 10/20/2004
From:
Status: offline 		Hi,

I need to do some changes on an access-MDB file (to prepare it for further use) and thought of using vbscript for this. Unfortunately, there`s as good as none information about how to use vbscript locally, NOT using any server.
At the moment, I have the following code:

dim conn
dim rs
dim query

set conn= createobject("ADODB.Connection")
set rs= createobject("ADODB.Recordset")

conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\test.mdb"

query = "select * from tab"

rs.Open query, conn, adOpenKeyset, adLockOptimistic, adCmdText

(...)

But keep getting following error:

ADODB.Recordset error '800a0bb9' The application is using arguments that are of the
wrong type, or are out of acceptable range, or are in conflict with one another.

Can anyone help me? Thanx!
 
 
Post #: 1
 
Re: use vbscript locally, how to access mdb? - 10/27/2004 8:13:18 AM   
  bobbob

 

Posts: 5
Score: 0
Joined: 10/27/2004
From:
Status: offline 		did you add an odbc data source under Administrative Tools, Data Sources (ODBC)

(in reply to xtian)
 
 
Post #: 2
 
Re: use vbscript locally, how to access mdb? - 10/28/2004 2:49:31 AM   
  tinus

 

Posts: 2
Score: 0
Joined: 10/26/2004
From: Netherlands
Status: offline 		try removing ', adOpenKeyset, adLockOptimistic, adCmdText' from the line where you open the query.

(in reply to xtian)
 
 
Post #: 3
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> use vbscript locally, how to access mdb? Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI