Datasource TO MS Access on Windows Vista

[gitobu]

I have windows vista and MS Access 2007. I have successfuly created datasources to SQL server but get this error when submitting a datasource to an Access database.

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

Any idea how to get this right?

[Newsgroup_User]

gitobu wrote:
> Any idea how to get this right?

64-bit OS? if so, try the "access for unicode" driver instead.

btw what driver are you using for sql server? the one labeled sql server in cf
admin?

[gitobu]

Yes, I have 64 bit. I am using the SQL driver at the Admin menu. I do not see the "access for unicode" driver listed. Where do I find it?

[Newsgroup_User]

gitobu wrote:
> Yes, I have 64 bit. I am using the SQL driver at the Admin menu. I do not see
> the "access for unicode" driver listed. Where do I find it?

same place.

[gitobu]

Comparing the copy of coldfusion I have on Vista with another copy on a XP I notice that the does not have "Microsoft Access for Unicode". This Vista - 64 bit has other 5 Drivers that are not on XP - These are DB2 Universal Database, Informix, J2EE Datasource, Oracle and Sybase.
The only one for Access is just not working and returns the eror

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

Allan

[Newsgroup_User]

It is my understanding from another list site discussing a similar
topic. That, as best as anybody knows, Microsoft has not provide a 64
bit driver for Access. The thinking of that list was that if one is
troubling oneself with a 64 bit enterprise system, one is probably not
using a non-enterprise, i.e. desktop (toy as the other list called it),
database. But who really knows why MS does all that MS does.

My theory is that they are trying to push more people to MS SQL Express
as a replacement for Access.

[Newsgroup_User]

gitobu wrote:
> Comparing the copy of coldfusion I have on Vista with another copy on a XP I
> notice that the does not have "Microsoft Access for Unicode". This Vista - 64

didn't know that (don't use access or vista). i suppose you might see if there's
a real JDBC driver for access or do as ian suggests & bite the bullet & upgrade.

[Newsgroup_User]

Try this.

Open C:\Windows\SysWOW64\odbcad32.exe and create a System DSN using the Microsoft Access Driver (*.mdb).

Then open the ColdFusion Admin and create a datasource using the ODBC Socket driver.

Check the Trusted connection checkbox and it should work.

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com


"gitobu" <webforumsuser@macromedia.com> wrote in message news:giggif$p55$1@forums.macromedia.com...
> Comparing the copy of coldfusion I have on Vista with another copy on a XP I
> notice that the does not have "Microsoft Access for Unicode". This Vista - 64
> bit has other 5 Drivers that are not on XP - These are DB2 Universal Database,
> Informix, J2EE Datasource, Oracle and Sybase.
> The only one for Access is just not working and returns the eror
>
> "Unable to update the NT registry.
> Variable DRIVERPATH is undefined."
>
> Allan
>
>

[KeithWanders · Accepted solution]

After hours of frustration, I've discovered that the problem is with 64 bit Coldfusion, not 64 bit Vista. 64 bit Coldfusion does not support the Access drivers.

http://kb.adobe.com/selfservice/viewContent.do?externalId=kb403277#_Toc193176418

Reinstall 32 bit Coldfusion on your 64 bit Vista and then you will have the "Microsoft Access with Unicode" driver.

Hallelujah!

[gitobu]

Thanks Keith, this works!!!!!!!!!!!!!!