Adobe Community: Coldfusion MX 7 Administrator

34 posts
Jun 3, 2009

Currently Being Moderated

1. EwokStud,

Nov 26, 2011 9:26 AM in reply to EwokStud

Report

I forgot to include the following in the above submittance, as to "What I have done so far":

Database File = E:\databases\pd.mdb

I also am unable to edit my original post, whihc is why I had to reply to my own original post....

|

Mark as:

34 posts
Jun 3, 2009

Currently Being Moderated

2. EwokStud,

Nov 26, 2011 7:36 PM in reply to EwokStud

Report

I look forward to someone who can help me with this "System Database File" choice.

|

Mark as:

Currently Being Moderated

3. Adam Cameron.,

Nov 27, 2011 12:17 AM in reply to EwokStud

Report

I'm pretty sure the underlying Access requirements are not shipped on 64-bit Windows versions (you have tagged this ticket as 64-bit, so presume you have done this for a reason).

Google "microsoft access 64-bit" for details; google "microsoft access 64-bit coldfusion" for any of a number of discussions on the CF side of things.

I think, basically, it's time to upgrade your DBs from a desktop DB to a server DB.

--

Adam

|

Mark as:

34 posts
Jun 3, 2009

Currently Being Moderated

4. EwokStud,

Nov 27, 2011 3:27 AM in reply to Adam Cameron.

Report

We're talking about the Developer Edition, Adam, which installed successfully on my home computer. Also, I opened the Developer Edition's Administrator successfully, and the message was the following:

Unable to update the NT registry.

Variable DRIVERPATH is undefined.

I've interpreted this, as having no entry in the System Database File textbox..because...I'm guessing...that this textbox cannot be blank. Now, I simply wanted to add pd.mdb to the datasources already in existence. It is not visible in my original post, but I included pd.mdb in the first textbox "Database File". My only question is...what is this System Database File textbox truly asking for. Here, is the guidance I get in the CFMX7 pdf guide, which is completely vague to me:

System Database File To secure access to the specified database file, click Browse Server to locate and enter a database that contains database security information. The system database is usually located in the same directory as the MDB file or in the windows\system32\system.mdw directory.

It appears to be looking for a database that I have not built, but a database that is for windows, but I could be wrong.

|

Mark as:

Currently Being Moderated

5. Adam Cameron.,

Nov 27, 2011 9:25 AM in reply to EwokStud

Report

We're talking about the Developer Edition, Adam, which installed successfully on my home computer. Also, I opened the Developer Edition's Administrator successfully, and the message was the following:

I don't think you get what I mean. This is not a ColdFusion problem, it's that Access ain't supported on 64-bit Windows. There are no 64-bit drivers for Access, so on a 64-bit Windows install, Access is not supported.

You can horse around trying to get a 32-bit driver and try to get it working, but that falls outwith the scope of these forums (it certainly falls outwith the scope of my knowledge on the topic, too ;-)

You might want to read this:

http://answers.microsoft.com/en-us/office/forum/officeversion_other-of fice_other/64-bit-driver-for-dsn-for-ms-access-database/be8c0ad4-d8fd- 48e0-9026-b95d84135820

Or, like I said, do the googling.

But at the end of the day, this is an Access/Windows issue, not a CF issue.

--

Adam

|

Mark as:

747 posts
Mar 11, 2003

Currently Being Moderated

6. Dave Watts,

Nov 28, 2011 4:50 AM in reply to EwokStud

Report

We're talking about the Developer Edition, Adam, which installed successfully on my home computer. Also, I opened the Developer Edition's Administrator successfully, and the message was the following:

Unable to update the NT registry.
Variable DRIVERPATH is undefined.

This is an ODBC problem, and is pretty well-documented elsewhere. It is possible to get your Access datasources working with a 64-bit version of CF, but it's not as direct as it normally would be.

http://kb2.adobe.com/cps/408/kb408162.html

I've interpreted this, as having no entry in the System Database File textbox..because...I'm guessing...that this textbox cannot be blank. Now, I simply wanted to add pd.mdb to the datasources already in existence. It is not visible in my original post, but I included pd.mdb in the first textbox "Database File". My only question is...what is this System Database File textbox truly asking for.

Your interpretation is incorrect. No system database is required, if you don't have one.

Dave Watts, CTO, Fig Leaf Software

|

Mark as:

CF Data Source Name
Database File
System Database File
Use Default Username
ColdFusion Username
ColdFusion Password	(16-character limit)
Description

ColdFusion Server Administration

Coldfusion MX 7 Administrator

Nov 26, 2011 9:22 AM

More Like This

Bookmarked By (0)

Answers + Points = Status