Unable to set up datasource to connect to database.

[Guest]

Error Reads (in red):

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

In the CF Administrator, we assigned a datasource name, locating it on the local machine, w/no specific sign in credentials (default username), for both Database and System Files.  We just put in.  But we get the Error as above.

We are locally trying to hook up with a MS Access database  .mdb file or files.

Which Drivers are they talking about?  How do I address this?

There's no problem accessing the Access.

This is on a Windows 7 Home Premium machine with the local Cold Fusion included server running locally.

Any input would be greatly appreciated.  Thx!

[Daverms]

Hi,

I presume, you might be having 64 bit version of ColdFusion installed in your machine, which doesn't support MS-Access, and if this is true in your case,

uninstall your CF, download a 32 bit version and install it.

http://kb2.adobe.com/cps/403/kb403277.html#_Toc193176418

HTH

[Daverms]

Between try this workaround too, (before uninstalling / reinstalling 32 bit)

http://forums.adobe.com/message/673281#673281

[Guest]

Well, this is what I did.  I installed the latest SQL Server onto our local machine.

Anyways, after creating the database with tables, when I went to set up the DSN in CF Administrator, this is what it said:

Connection verification failed for data source: MyDSN
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect
The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect

Connection Refused:???

I don't have any passwords set up for the local database.

I've also gone and created a local DSN on the machine through the ODBC Administrator.

Can anyone tell me what I'm missing beside my dunce cap?  Thanks for the help, so far and in advance.

M.

[Daverms]

M,

Just turn-off your firewall and repeat the dsn creation one more time.

[Guest]

Really?  Didn't work.

I have a 64 bit machine.  Is running a 32 bit version of Cold Fusion going to work ok?

I noticed in the CFAdministrator, there's no button to launch a navigation tool to find "the database" engine if you will.  You are just supposed to type in the name of the database.

I can't find the link to Cold Fusion 8.x.  Does it still exist or are we being duped again?

[Guest]

Well, I'm back.  I've quickly downloaded and installed the Cold Fusion 8, and

set up the DSN in the administrator.  Seems to work the best for Microsoft Access.

Windows 7, 64.bit vs. 32bit issue.  Upgrading to SQL Server needs even more study.

Thanks Dave!

M.