error '80004005'

No problem. ;o)

I found that when I switched to a DSN-less connection from DSN I was,
lazily, cut and pasting the connection script and just changing the
connection string.
Then I noticed:

1) FileName="Connection_odbc_conn_dsn.htm"
2) FileName="Connection_ado_conn_string.htm"

Anyway, glad you got it sorted.

Nath.

"eltucan" <webforumsuser@macromedia.com> wrote in message
news:ebcuk6$jup$1@forums.macromedia.com...
> Thank you I have being trying to get this to work for ages, I used your
> code and subsituede the local path with the server path and it works -
> FANTASTIC

Thank you I have being trying to get this to work for ages, I used your code and subsituede the local path with the server path and it works - FANTASTIC

Altering your own connection file though, have you tried this, assuming you
have a DSN (called "industrious") set up on your local machine or web
server:

<%
' FileName="Connection_ado_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_industrious_STRING = "dsn=industrious;"
%>

If the DSN is set up on your local machine or web server, you shouldn't need
to add the data source location, as far as I know.
Could be wrong like! :o)

Also, I changed the FileName from odbc to ado. I'm no expert, but I'd be
giving this a try. Hope this is useful anyway.

Nath.

"eltucan" <webforumsuser@macromedia.com> wrote in message
news:ebcsd7$h6d$1@forums.macromedia.com...
>I am creating a website using asp and VBscript and haven't had any problems
>in
> the past, but I keep getting the following error message -
> [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path.
> Make sure that the path name is spelled correctly and that you are
> connected to
> the server on which the file resides.
> having read some of the other posts regarding this problem I tried
> changing
> the code in the connections file and now get the following error message
> which
> makes me think I am getting close
> Microsoft][ODBC Driver Manager] Data source name too long
>
> Here is the connection file I am trying to alter PLEASE HELP
> <%
> ' FileName="Connection_odbc_conn_dsn.htm"
> ' Type="ADO"
> ' DesigntimeType="ADO"
> ' HTTP="false"
> ' Catalog=""
> ' Schema=""
> Dim MM_industrious_STRING
> 'MM_industrious_STRING = "dsn=industrious;"
> MM_industrious_STRING = "Data Source=" &
> Server.MapPath("../data/Industrious.mdb")
> %>
>

Hello.

Have you tried this for your string?

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_industrious_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\wwwroot\data\Industrious.mdb;Persist Security Info=False;"
%>

HTH
Regards
nath.

"eltucan" <webforumsuser@macromedia.com> wrote in message
news:ebcsd7$h6d$1@forums.macromedia.com...
>I am creating a website using asp and VBscript and haven't had any problems
>in
> the past, but I keep getting the following error message -
> [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path.
> Make sure that the path name is spelled correctly and that you are
> connected to
> the server on which the file resides.
> having read some of the other posts regarding this problem I tried
> changing
> the code in the connections file and now get the following error message
> which
> makes me think I am getting close
> Microsoft][ODBC Driver Manager] Data source name too long
>
> Here is the connection file I am trying to alter PLEASE HELP
> <%
> ' FileName="Connection_odbc_conn_dsn.htm"
> ' Type="ADO"
> ' DesigntimeType="ADO"
> ' HTTP="false"
> ' Catalog=""
> ' Schema=""
> Dim MM_industrious_STRING
> 'MM_industrious_STRING = "dsn=industrious;"
> MM_industrious_STRING = "Data Source=" &
> Server.MapPath("../data/Industrious.mdb")
> %>
>