A

Anonymous

Question

Unable to set up datasource to connect to database.

Forum|Forum|16 years ago
December 9, 2009
3 replies
2399 views

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!

Database access

This topic has been closed for replies.

A

Anonymous

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.

D

Daverms

Inspiring

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

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

A

Anonymous

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.

D

Daverms

Inspiring

M,

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

D

Daverms

Inspiring

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded