DSN-Less problem

[fnaidek]

Hello i'am facing a problem in connection,,, i'am using DSN-LESS :
'DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=f:\Inetpub\wwwroot\facultydb\db\DB.mdb' its working well on my local
machine,, but when i upolad the files to the net i found this error : 'Error
Type: Provider (0x80004005) Unspecified error' please tell me what is the
problem? is there any solution ?

[twocans]

You mention "When I upload these files" , you need to check with your isp
the path to your database, it is not the same as is on your pc .

regards

twocans







"fnaidek" <webforumsuser@macromedia.com> wrote in message
news:d3008d$l8k$1@forums.macromedia.com...

> Hello i'am facing a problem in connection,,, i'am using DSN-LESS :
> 'DRIVER={Microsoft Access Driver (*.mdb)};
> DBQ=f:\Inetpub\wwwroot\facultydb\db\DB.mdb' its working well on my local
> machine,, but when i upolad the files to the net i found this error :
> 'Error
> Type: Provider (0x80004005) Unspecified error' please tell me what is the
> problem? is there any solution ?
>

[CarlGrint]

if the path in your string is for your local machine, it is not going to work
on the live server will it.

You need to make a 2nd version for the live site with the live path set, I
always have a connection file for my test server, then a copy prefixed live_
which is uploaded, then renamed without the live_

You will need to find the path to your live site database.

Originally posted by: fnaidek
Hello i'am facing a problem in connection,,, i'am using DSN-LESS :
"DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=f:\Inetpub\wwwroot\facultydb\db\DB.mdb" its working well on my local
machine,, but when i upolad the files to the net i found this error : "Error
Type: Provider (0x80004005) Unspecified error" please tell me what is the
problem? is there any solution ?

[fnaidek]

i chnaged the path as in the server but still not working may be i have to change the connection type???

[twocans]

dsnless is far better then a dsn. if you asked your isp as to the correct
path, and still not getting your connection show us the comple connection
like I have below maybe that might help.


<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connFabPicSite_STRING
MM_connFabPicSite_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
yourdatabase path here\fabio.mdb;"
%>







"fnaidek" <webforumsuser@macromedia.com> wrote in message
news:d30aj9$8u0$1@forums.macromedia.com...

>i chnaged the path as in the server but still not working may be i have to
>change the connection type???

[fnaidek]

i used your code but it did not work also any way the connection code that
i'am using is : <% ' FileName='Connection_ado_conn_string.htm' ' Type='ADO' '
DesigntimeType='ADO' ' HTTP='false' ' Catalog='' ' Schema='' Dim
MM_fact_db_STRING MM_fact_db_STRING = 'DRIVER={Microsoft Access Driver
(*.mdb)}; DBQ=databasepath' %>

[twocans]

so did u get it working or not.

[url]http://www.basic-ultradev.com/articles/dsnlesscoldfusion/index.asp[/url]
or check out the free ole extension
[url]http://www.tom-muck.com/extensions/[/url]

may be of some help.



"fnaidek" <webforumsuser@macromedia.com> wrote in message
news:d30f2l$foa$1@forums.macromedia.com...

>i used your code but it did not work also any way the connection code that
> i'am using is : <% ' FileName='Connection_ado_conn_string.htm' '
> Type='ADO' '
> DesigntimeType='ADO' ' HTTP='false' ' Catalog='' ' Schema='' Dim
> MM_fact_db_STRING MM_fact_db_STRING = 'DRIVER={Microsoft Access Driver
> (*.mdb)}; DBQ=databasepath' %>
>