Dreamweaver - Error: Invalid File Name

Author

Error: Invalid File Name

jaschulz

2005-03-30, 6:45 pm

Earlier, I posted a message under the heading Cannot find installable ISAM.
Now, that same connection string is yielding and Error: Invalid File Name. The
connection string is as follows: Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=Server.MapPath('./Datastores/mybase.mdb'); Persist Security Info=False
The weird thing about this is that the file in question is listed in the tree
for Remote view and Testing server, and, in fact, this same connection string
actually works in a non-Dreamweaver ASP app.

crash

2005-03-30, 6:50 pm

What's your connection string look like in your working app verses your
non-working app?

--

::-----::-----::

thanks,

Jon Parkhurst
PriivaWeb, Inc.
http://priiva.net

I don't wanna grow up, I'm a ToysRUs Kid....
"jaschulz" <webforumsuser@macromedia.com> wrote in message
news:d2eagq$nmc$1@forums.macromedia.com...
> Earlier, I posted a message under the heading Cannot find installable
> ISAM.
> Now, that same connection string is yielding and Error: Invalid File Name.
> The
> connection string is as follows: Provider=Microsoft.Jet.OLEDB.4.0; Data
> Source=Server.MapPath('./Datastores/mybase.mdb'); Persist Security
> Info=False
> The weird thing about this is that the file in question is listed in the
> tree
> for Remote view and Testing server, and, in fact, this same connection
> string
> actually works in a non-Dreamweaver ASP app.
>

jaschulz

2005-03-30, 6:50 pm

The two are identical. Well, in fact, in the string I cited in my message I
use forward slashes, and I have back slashes in the working app. But I have
tried it both ways in DW and I get the same error.

crash

2005-03-30, 6:51 pm

change both to have back slashes, I believe this is referenced on the server
(let's hope somebody corrects me if I'm wrong).

Is this on a remote or local server? Can you reboot the server? It looks
like file permissions are having problems on the file itself.

--

::-----::-----::

thanks,

Jon Parkhurst
PriivaWeb, Inc.
http://priiva.net

I don't wanna grow up, I'm a ToysRUs Kid....
"jaschulz" <webforumsuser@macromedia.com> wrote in message
news:d2f4p4$3u5$1@forums.macromedia.com...
> The two are identical. Well, in fact, in the string I cited in my message
> I
> use forward slashes, and I have back slashes in the working app. But I
> have
> tried it both ways in DW and I get the same error.
>

jaschulz

2005-03-30, 11:15 pm

Alas, it is a remote server and I cannot reboot it. What I don't understand is
how the DW Remote view and Testing server file trees can see
..\Datastores\mybase.mdb, but the Recordset connection dialog nevertheless finds
the filename to be invalid.

jaschulz

2005-03-31, 4:27 am

Some progress. The problem arises because Server.MapPath gives a different
result when DW calls it that it does in my non-DW ASP app. I discovered this
by putting the following line: <%
Response.Write(Server.MapPath('.\datastores\HWCHUM.mdb')) %> in to my DW ASP
VBScript page. the result was something like this:
D:/Inetpub/wwroot/xxxxxxxxx/xxxxxxxxx/xxxxxxxxx/datastores/HWCHUM.mdb this is
(apparently) not what DW is expecting, however, when I altered my connection
string as follows: Provider=Microsoft.Jet.OLEDB.4.0;Data
Source='D:/Inetpub/wwroot/xxxxxxxxx/xxxxxxxxx/xxxxxxxxx/datastores/HWCHUM.mdb';P
ersist Security Info=False Then the connection succeed, and I do not get the
'Invalid File Name' error. Can anyone explain what is going on here?

crash

2005-03-31, 6:31 pm

dunno. is ti working? leave it be. :O)

It might be a mapping isssue, or it could be that DW is looking for the
database locally.

--

::-----::-----::

thanks,

Jon Parkhurst
PriivaWeb, Inc.
http://priiva.net

I don't wanna grow up, I'm a ToysRUs Kid....
"jaschulz" <webforumsuser@macromedia.com> wrote in message
news:d2g25e$9vf$1@forums.macromedia.com...
> Some progress. The problem arises because Server.MapPath gives a
> different
> result when DW calls it that it does in my non-DW ASP app. I discovered
> this
> by putting the following line: <%
> Response.Write(Server.MapPath('.\datastores\HWCHUM.mdb')) %> in to my DW
> ASP
> VBScript page. the result was something like this:
> D:/Inetpub/wwroot/xxxxxxxxx/xxxxxxxxx/xxxxxxxxx/datastores/HWCHUM.mdb
> this is
> (apparently) not what DW is expecting, however, when I altered my
> connection
> string as follows: Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source='D:/Inetpub/wwroot/xxxxxxxxx/xxxxxxxxx/xxxxxxxxx/datastores/HWCHUM.mdb';P
> ersist Security Info=False Then the connection succeed, and I do not get
> the
> 'Invalid File Name' error. Can anyone explain what is going on here?
>