ASP Access Database Connection Problem

[GavW]

Hey all!

I'm relatively new to using ASP and i am having difficulty connecting my
Access Database using the application window in Dreamweaver MX 2004.

Here is my connection code:

/connections/tm.asp

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_con_tm_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("tastymaths.mdb")
%>

I am receiving the following error when attempting to submit a form:

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/reg.asp, line 114


Line 114 of my reg.asp file is as follows:


If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection (THIS IS LINE 114)
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close


does anybody know where i am going wrong?
Thanks


Gavin

[twocans]

Hi yea,
I see your path to your database is incorrect.

to create a dsnless connection you need to have the absolute address to your
database as in

Data Source=C:\Inetpub\wwwroot\FabioDB\fabio.mdb;".

note how my database above is in my c drive etc etc.... and look at where
yours is

tastymaths.mdb in the middle of no where really. so create the correct path
to your db and I think you should be ok. if your using MX2004 the extension
from tom muck below is brilliant. I use it often to get my full path. see it
on the bottom of the page , it is called "Get Database Path"

[url]http://www.basic-ultradev.com/extensions/index.asp?tfm_order=DESC&tfm_orderby=ProductName&o ffset=20[/url]

to use it is simple. first load the extension into dreamweaver and reboot
it. then open dreamweaver create a new page, apply this extension it will
ask you for the name of your database, type in tastymaths.mdb then save the
page and view it in a browser. it will give you the full path to your
database. cut and paste it inside

> Server.MapPath("tastymaths.mdb").

this is worth a read too
[url]http://www.webthang.co.uk/tuts/tuts_dmx/gk_cons/cons.asp[/url]

regards

twocans









"GavW" <webforumsuser@macromedia.com> wrote in message
news:d0pk13$l2j$1@forums.macromedia.com...

> Hey all!
>
> I'm relatively new to using ASP and i am having difficulty connecting my
> Access Database using the application window in Dreamweaver MX 2004.
>
> Here is my connection code:
>
> /connections/tm.asp
>
> <%
> ' FileName="Connection_odbc_conn_dsn.htm"
> ' Type="ADO"
> ' HTTP="false"
> ' Catalog=""
> ' Schema=""
> MM_con_tm_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath("tastymaths.mdb")
> %>
>
> I am receiving the following error when attempting to submit a form:
>
> ADODB.Command error '800a0bb9'
>
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
>
> /reg.asp, line 114
>
>
> Line 114 of my reg.asp file is as follows:
>
>
> If (Not MM_abortEdit) Then
> ' execute the insert
> Set MM_editCmd = Server.CreateObject("ADODB.Command")
> MM_editCmd.ActiveConnection = MM_editConnection (THIS IS LINE 114)
> MM_editCmd.CommandText = MM_editQuery
> MM_editCmd.Execute
> MM_editCmd.ActiveConnection.Close
>
>
> does anybody know where i am going wrong?
> Thanks
>
>
> Gavin
>

[Gubbins]

hi i agree with twocans but then i use the same conection script oyu do and the
first time i did i got the same error message. i am assuming that you have
created a folder in the wwwroot folder to test you app? if so have you put your
database in the root folder of the site? or in a folder called database? i use
the following MM_connSTS_STRING = 'Provider=Microsoft.Jet.OLEDB.4.0; Data
Source= ' &amp; Server.MapPath('/mainsitefolder/database/sitedatabase.mdb')
this works fine for me when i am testing plus when i upload the site it works
on my remote service provider hope this helps Gubs

[twocans]

did you try out the tom muck extension, it is really very good for getting
the path.

just out of interest lol

twocans



"Gubbins" <webforumsuser@macromedia.com> wrote in message
news:d0q3v2$j1r$1@forums.macromedia.com...

> hi i agree with twocans but then i use the same conection script oyu do
> and the
> first time i did i got the same error message. i am assuming that you have
> created a folder in the wwwroot folder to test you app? if so have you put
> your
> database in the root folder of the site? or in a folder called database? i
> use
> the following MM_connSTS_STRING = 'Provider=Microsoft.Jet.OLEDB.4.0; Data
> Source= ' &amp;
> Server.MapPath('/mainsitefolder/database/sitedatabase.mdb')
> this works fine for me when i am testing plus when i upload the site it
> works
> on my remote service provider hope this helps Gubs
>

[BillB]

twocans forgot the link
[url]http://www.tom-muck.com/extensions/help/oledbconnectionString/[/url]

Bill

[twocans]

OOpps thanks Bill





"BillB @gmail.com>" <bill.betournay<"spamTrap"> wrote in message
news:d0qt72$qv1$1@forums.macromedia.com...

> twocans forgot the link
> [url]http://www.tom-muck.com/extensions/help/oledbconnectionString/[/url]
>
> Bill
>