Path to database?

Gooood morning.

This is probably a noob question but Im stumped.
Every DB environment I have used was in a PHPMyAdmin area where I can set everything up on my end.

A client of mine is using RCN hosting and they dont have a PHPMyAdmin envrionment.

Im using MySQL and I have exported all my data to a .db file. (all my tables and data etc.)

RCN is asking for a path to my database and a bunch more..here is their odbc request form..


ODBC REQUEST FORM
RCN suggests that customers use DSNless with relative paths as this minimizes maintance on code and is faster to setup.

RCN has provided example code below:

Dim objConn
Dim objDriver
Set objConn=Server.CreateObject("ADODB.Connection")
objDriver="DRIVER={Microsoft Access Driver (*.mdb)};"
objConn.ConnectionString=objDriver & _
"DBQ=" & Server.MapPath("/relative/path/to/database.mdb")
objConn.Open

Username:
Password:
Domain or ip address:
Email address:
Path to database: *1
Database name *2
DSN(Data Source name)

(Please allow 24hrs for setup)
-------------

all i have is my .db file with data...how the heck do i set this up this is an urgent matter.

I appreciate the help.
Tim

 

not 100% sure but path could mean 1 of 2 things

is the database local or remote? if its local it could just be localhost or if its asking for the path it will be where can the db be found? e.g. (/home/user/public_html/db/file.db or http://site.com/dbs/file.db)

 

it will be local i guess. If i were to upload it to the hosting say www.url.com/folder/mydatabase.db

that seems very hackable though...im like completely stumped without phpmyadmin. and i very greatly need it to be a secure one at that..

they dont seem to be able to help me at all through tech support..three calls and i havent gotten past we need a path to your db..

>.<

 

Seeing the example connection string provided by RCN, I think you need to create a mdb file and not a db file as you have done. You can then create a folder on the site, say "mydatafolder" and upload the mdb there. Then use their form and inform RCN about the name of this folder, and the name of your mdb file. Further, if it is an mdb, it is in all likelihood an asp site. You donot have a phpmyadmin there.

 

thank you for your help with this. you are correct it is msft hosting. Is it safe to place a mdb file on the server in a folder somewhere? sorry for my complete lack of knowledge with this. I assure you i know about hosting and all that. just never used a db out side of phpmyadmin.

thanks for your help

 

i would put them outside of public access, somewhere like /home/user/ and not /home/user/public_html/