Access DB connection to godaddy
man, tough.
i have access db can write fine on local machine. when uploaded onto godaddy hosting, getting errors. read , contacted godaddy support, , showed me how create folder access_db through control panel. have database in there rsvp.mdb , need link it. found article on setting custom connection string, cannot life of me connect.
any ideas awesome!!
i have access db can write fine on local machine. when uploaded onto godaddy hosting, getting errors. read , contacted godaddy support, , showed me how create folder access_db through control panel. have database in there rsvp.mdb , need link it. found article on setting custom connection string, cannot life of me connect.
any ideas awesome!!
hello,
i have few sites using access @ godaddy.
i use 1 of following 2 connection strings i've included below.
first thing need figure out location of root
directory on host's server..that's easy yourself.
make asp page (i named mine "findit.asp"), , put code in it:
<body>
<%
response.write("the location of page is:<br>")
response.write(request.servervariables("path_translated") & "<br>")
response.write("the location of root directory is:<br>")
response.write(server.mappath("\"))
response.write path
%>
</body>
upload same location site's home page.
once new asp page uploaded, navigate page in
browser.
site, example, page displays this:
location of page is:
d:\hosting\mysite\findit.asp
location of root directory is:
d:\hosting\mysite
know root directory location on server, can
figure out path database.
database folder called access_db, , happens in root
directory along home page.
needed add database folder name (access_db) ,
database
inside's name (mydatabase.mdb) root directory location:
d:hosting\mysite\access_db\mydatabase.mdb
that's data source path database @ godaddy. yours
very similar.
if used dw create connection.asp page, here's should
like using path info figured out. substitute path, of
course.
<%
' filename="connection_ado_conn_string.htm"
' type="ado"
' designtimetype="ado"
' http="false"
' catalog=""
' schema=""
dim mm_access_mysite_string
mm_bhskd_string = "provider=microsoft.jet.oledb.4.0;data
source=d:hosting\mysite\access_db\mydatabase.mdb;user id=admin;password="
%>
here second method works on godaddy.
all need database folder name , database name.
it's using mappath function find database.
as previous example, it's code in connection.asp
file.
<%
' filename="connection_odbc_conn_dsn.htm"
' type="ado"
' designtimetype="ado"
' http="true"
' catalog=""
' schema=""
dim mm_access_mysite_string
mm_access_mysite_string = "provider=microsoft.jet.oledb.4.0;data source=" &
server.mappath("access_db") & "\mydatabase.mdb;user id=admin;password="
%>
don't forget set permissions on database directory read/write.
i hope helps.
take care,
tim
"snakerider" <webforumsuser@macromedia.com> wrote in message
news:fojk5b$d1j$1@forums.macromedia.com...
> man, tough.
>
> have access db can write fine on local machine. when
>
> uploaded onto godaddy hosting, getting errors. read ,
> contacted
> godaddy support, , showed me how create folder access_db
> through
> control panel. have database in there rsvp.mdb , need
> link
> it. found article on setting custom connection string,
> cannot life of me connect.
>
> ideas awesome!!
>
i have few sites using access @ godaddy.
i use 1 of following 2 connection strings i've included below.
first thing need figure out location of root
directory on host's server..that's easy yourself.
make asp page (i named mine "findit.asp"), , put code in it:
<body>
<%
response.write("the location of page is:<br>")
response.write(request.servervariables("path_translated") & "<br>")
response.write("the location of root directory is:<br>")
response.write(server.mappath("\"))
response.write path
%>
</body>
upload same location site's home page.
once new asp page uploaded, navigate page in
browser.
site, example, page displays this:
location of page is:
d:\hosting\mysite\findit.asp
location of root directory is:
d:\hosting\mysite
know root directory location on server, can
figure out path database.
database folder called access_db, , happens in root
directory along home page.
needed add database folder name (access_db) ,
database
inside's name (mydatabase.mdb) root directory location:
d:hosting\mysite\access_db\mydatabase.mdb
that's data source path database @ godaddy. yours
very similar.
if used dw create connection.asp page, here's should
like using path info figured out. substitute path, of
course.
<%
' filename="connection_ado_conn_string.htm"
' type="ado"
' designtimetype="ado"
' http="false"
' catalog=""
' schema=""
dim mm_access_mysite_string
mm_bhskd_string = "provider=microsoft.jet.oledb.4.0;data
source=d:hosting\mysite\access_db\mydatabase.mdb;user id=admin;password="
%>
here second method works on godaddy.
all need database folder name , database name.
it's using mappath function find database.
as previous example, it's code in connection.asp
file.
<%
' filename="connection_odbc_conn_dsn.htm"
' type="ado"
' designtimetype="ado"
' http="true"
' catalog=""
' schema=""
dim mm_access_mysite_string
mm_access_mysite_string = "provider=microsoft.jet.oledb.4.0;data source=" &
server.mappath("access_db") & "\mydatabase.mdb;user id=admin;password="
%>
don't forget set permissions on database directory read/write.
i hope helps.
take care,
tim
"snakerider" <webforumsuser@macromedia.com> wrote in message
news:fojk5b$d1j$1@forums.macromedia.com...
> man, tough.
>
> have access db can write fine on local machine. when
>
> uploaded onto godaddy hosting, getting errors. read ,
> contacted
> godaddy support, , showed me how create folder access_db
> through
> control panel. have database in there rsvp.mdb , need
> link
> it. found article on setting custom connection string,
> cannot life of me connect.
>
> ideas awesome!!
>
More discussions in Dreamweaver support forum
adobe
Comments
Post a Comment