Re: Problems with Connection Strings

On Jun 14, 8:26 am, rich <r...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hello Everyone,

I am a newbie to web development. I am using FrontPage 2002/SP3 on XP and
IIS 6.0 on Win2K3 server. My Dev website is stored locally and I am
publishing to the IIS server.

I am attempting to connect to and query an Access database stored both
locally and on the IIS server. This is the code (and connection string that
I am using, (which I believe should be using the Microsoft Jet driver, pardon
if I am not 100% correct in this statement.)...

<%
dim oConn
dim strConn
dim strSQL
dim rs

Set oConn = CreateObject("ADODB.Connection")
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
Settings\rks.RPS.002\My Documents\My
Webs\richweb\GSDtest\OtherFiles\jettest.mdb
oConn.open strConn
%>

On my local XP box, the first time I hit the hyperlink to call this page
(jet.asp), IIS shows me all the code on the page. If I refresh the page, it
renders and displays correctly, except the query that I run does not appear
to execute, or at the very least, the results of the query are not
returned/displayed.

When I run this page on the IIS server, I get the following error message:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/GSDtest/Jet.asp, line 8

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
Settings\rks.RPS.002\My Documents\My
Webs\richweb\GSDtest\OtherFiles\jettest.mdb
----------------------------^

The ^ character is pointing to the "." (period) after OLEDB and before the
number 4. Can anyone tell me why I am having this problem and how to resolve
it?

TIA,
Rich

Your error returned can be the result of a break in the connection
string. And since the error is on line 8 and your connection string
begins on 7, it makes me think that is the issue -- please confirm.

I deal with lots of different flavors on databases. As such, I cannot
remember (nor do I make the attempt to remember jargon as long as I
know where to look it up) all the different string for which I'm
responsible. I use this website often:

http://www.connectionstrings.com/

.

Relevant Pages
Loading