Access Database via Control Panel connection?

Customer Support Database Support
1

I have a database that I uploaded to the root folder.

I have gone to ODBC DRIVERS MICROSOFT ACCESS DRIVER (*.mdb)

I am confused by a few things in that list. the first section is easy, the name of the database.

The 2nd line, DBQ, i don’t understand. What woud a path look like going from the ROOT to the mydomain.com(which is where my files would be)?

Is the username and password just for online purposes, or is that suppose to be in the database as well, because I didn’t know a password could be set in the hardcopy of the database.

Actually, I will be straight up, Maybe someone could just explain to me what to put in all the categories for the ODBC Drivers section, because buffer size, maxscanrows??

Read only? Do I leave it to be read only because I don’t want changes, but then I have to consider that the owner will be able to go online and make changes to it via FORMS. I just need a boost here.

Thanks
Bryan

2

  1. DBQ = “mydomain.com/mydb.db”
    I recommend you database files in the root though

  2. I believe the username and password are to be used while connecting to the DSN

All the variables are set just fine. You might want to give it Write permissions as well

3

[QUOTE=Yash]

  1. DBQ = “mydomain.com/mydb.db”
    I recommend you database files in the root though

  2. I believe the username and password are to be used while connecting to the DSN

All the variables are set just fine. You might want to give it Write permissions as well
[/QUOTE]

that was my question, what would the DBQ be if the database is located in the root??

4

[QUOTE=jag5311]
that was my question, what would the DBQ be if the database is located in the root??
[/QUOTE]

i think it would be simply “yourdatabase.mdb”

5

What error are you exactly getting. Could you submit a ticket with your username and DSN name and we will look into this right away

6

I will send a ticket

7

We found the problem. You are suppose to create the DSN in Cold Fusion as well

8

[QUOTE=Yash]
We found the problem. You are suppose to create the DSN in Cold Fusion as well
[/QUOTE]

Does that mean in my Application.cfm i need to have something like

?? That doesn’t look right, please let me know where I need to put it.

Thanks
Bryan

9

We created the CF DSN for you.
All you have to do now is change the datasource tag to
datasource=“username-something”

10

[QUOTE=Yash]
We created the CF DSN for you.
All you have to do now is change the datasource tag to
datasource=“username-something”
[/QUOTE]

Thanks Yash, I am getting ready to test it. Do you use the CF administrator on your side of things? I didn’t know if there was that option for me to use.

I think I understand to how the H-sphere works. I think it works more for DNSLESS connections, like

dbPath = "\\website\resources\cf5\data\"; dbFile = "states.mdb"; driver = "{Microsoft Access Driver (*.mdb)}"; conStr = "Driver=#driver#;dbq=#dbFile#;DefaultDir=#dbPath#;UID=Admin;Pwd=;";

I could be wrong though

11

We have to create all CFMX DSNs manually till support is available for it in HSphere. Just drop a ticket when you want one created