Solved

Microsoft VBScript compilation error '800a03ee'

Posted on 2009-06-28
7
474 Views
Last Modified: 2012-05-07
How could I correct this ASP code?

Microsoft VBScript compilation error '800a03ee'

Expected ')'

/testdatabase1.asp, line 35
Server.MapPath("/Server.MapPath("/mytestdatabase062509.accdb").mdb") & ";" &_
------------------------------------------------------------^
sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &_

Server.MapPath("/Server.MapPath("/mytestdatabase062509.accdb").mdb") & ";" &_

"User ID=********;Password=*******"

Open in new window

0
Comment
Question by:WebSpyder
  • 3
  • 2
7 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 24731833
Server.MapPath("mytestdatabase062509.accdb")

or

Server.MapPath("mytextdb.mdb")

Or whatever your database is named ... search on Server.MapPath for syntax examples, your's is munged badly.
0
 
LVL 16

Expert Comment

by:sunithnair
ID: 24736148
I think this should solve the problem provided the mdb file is named mytestdatabase062509.accdb and resides in the root folder.
sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &_

Server.MapPath("/mytestdatabase062509.accdb.mdb") & ";" &_

"User ID=********;Password=*******"

Open in new window

0
 
LVL 84
ID: 24736445
.accdb is the extension for an ACCESS 2007 (ACE format) database.

.mdb is the extension for earlier version (2003 or before, Jet format) database.
0
 
LVL 16

Expert Comment

by:sunithnair
ID: 24742963
Sorry I did not know that. Thanks for the information. I have not used Access 2007.
0
 
LVL 84
ID: 25960739
My suggestion here: http:#a24731833 would solve this issue. The syntax was wrong; I corrected it.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

747 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

16 Experts available now in Live!

Get 1:1 Help Now