We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Microsoft VBScript compilation error '800a03ee'

WebSpyder
WebSpyder asked
on
Medium Priority
535 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

Comment
Watch Question

Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
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

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
.accdb is the extension for an ACCESS 2007 (ACE format) database.

.mdb is the extension for earlier version (2003 or before, Jet format) database.
Sorry I did not know that. Thanks for the information. I have not used Access 2007.
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
My suggestion here: http:#a24731833 would solve this issue. The syntax was wrong; I corrected it.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.