Cannot connect to an Access databse 1

[jsanbor1]

I get this error

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

any help would be greatly appreciated.

Thanks,
JJ

 

[csteinhilber]

A little more information, please.

Like:
1) what version of CF are you running?
2) (if CF 5) are you connecting via a system DSN, or are you using a DSN-less connection?
3) if a system DSN, what driver did you set it up with?




-Carl

 

[jalbao]

It sounds like you are having probs with MDAC.

You may have luck by (re)installing the MDAC components.

Check this MS page to see if it has the MDAC's that fit your system:

http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28001860

 

[jsanbor1]

Carl,

its CF MX on Windows XP with Office XP.

I am just clicking on "data sources" and add. Giving a name and trying to connect to an Access sample db so I can practice.

Tooled,

Thanks for the link, i downloaded the latest MDAC components and installed and restarted, but the same thing happens.


The wierd part is that on my wife's computer at home - i am able to connect to an Access db and use the Dreamweaver and Coldfusion MX programs. AND she doesn't even have Access Installed!

JJ
*scratching head*

 

[csteinhilber]

Have you tried setting up a System DSN (using the Control Panel -> Administrative Tools -> Data Sources (ODBC) control panel) and connecting CF to it through the DSN?

I'm pretty sure CF has it's own MDAC components that aren't updated during a typical install of the MDAC's you'd get from Microsoft's site. That install would more than likely update the drivers used when you set up a System DSN, though... making that route a better bet.

I've only set up an Access connection via a System DSN, and via DSN-less connections in CF5. Never tried to connect directly to the file in Administrator, the way (it seems) you're trying to do.



-Carl

 

[jsanbor1]

Yes - I am trying to connect directly from the CF Administrator.

"Have you tried setting up a System DSN (using the Control Panel -> Administrative Tools -> Data Sources (ODBC) control panel) and connecting CF to it through the DSN?"


OK - i tried this and I get a new error

"The setup routines for the MIcrosoft Access driver (*.mdb) ODBC driver could not be found. Please reinstall the driver"

Then "Component not found in the registry"

i just reinstalled the MDAC components.

JJ

 

[jalbao]

You mentioned that you are running XP.

Have you installed the XP service pack? The reason why i mention this is because sp1 will contain the latest MDAC components and the Jet components.

If you have already installed the sp1, then I would suggest to give the reinstallation of MDAC and Jet components one more try. Maybe the lunar eclipse last night screwed things up the first time through.

 

[jsanbor1]

Office SP? Yes - I have installed SP2 for Office XP.

 

[jalbao]

I'm sorry, I wasn't clear regarding the service pack. I was referring to ServicePack1 for WindowsXP not OfficeXP.

 

[jsanbor1]

thanks for helping me tooled. i intalled the SP1 for WindowsXP. It still doesn't work.

 

[jalbao]

For troubleshooting purposes, do the following then let us know the status:

1. Create a new access database (name it testdb), then save it in your My Documents folder.

2. Go to Start>Programs>Administrative Tools>Data Sources

3. Click the System DSN tab

4. Click the ADD button

5. Scroll down and select Microsoft Access Driver (*.mdb) - MAKE SURE YOU DON'T ACCIDENTALLY SELECT A DIFFERENT MICROSOFT ACCESS DRIVER!

6. In the Data Source Name field, type "testdsn" (without the quotes)

7. Click the Select button

8. Navigate to your My Documents folder, then double click the "testdb.mdb"

9. Click the OK button

10. Open up your ColdFusion Administrator

11. Go to ODBC Data Sources

12. Click the Verify link for testdsn

13. Tell us whether or not CF was able to verify testdsn

 

[jsanbor1]

Success! I had to use the Spanish one. "Driver do Microsoft Access" - the English version isn't in the list. I don't understand why not, but it works now. So - THANKS!