Data Source Error in Cold Fusion v9

Web page errorCF Admin Data Source ErrorCFM Page ErrorCF Datasource Connection ErrorHi,

 I have Coldfusion V9 running on Windows Server 2008R2. I created new datasource "Promo" using Microsoft ACCESS database. When I submit the configuration, it displays an error message in red color "Unable to update the NT registry. Variable DRIVEPATH is undefined".
 Also when I click [Verify All Connections] button at the bottom of Data Source section, I get an message in yellow color regarding "Connection verification failed for data source: Promo".
 In the Internet browser, when I try to display a specific CFM page, it generates and error message "Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][SequeLink Server]Required user name is missing.".

 Can you help?
LVL 1
sgleeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pravin AsarPrincipal Systems EngineerCommented:
It seems long time, since I worked with CF9. [Currently usng CF 2016].

I recall, CF9 64 bit installation does not support Access. You need to have 32 bit installation.

It is possible for you to move away from Access ; Import the database MSSQL or MYSQL.
0
sgleeAuthor Commented:
@Pravin,

" It is possible for you to move away from Access" --> Maybe in the new application, but not for the existing ACCESS database.
I just  can't imagine that Adobe introduce CF V9 without providing solution or workaround to this issue.
Let me do some research in Google.
0
sgleeAuthor Commented:
Data Source Creation Screen in CF9In the Data Source Creation screen, I have two questions.
(1) Do I need to check the checkbox for "Use Default User name"?
(2) Do I need to enter information in ColdFusion User Name and ColdFusion Password fields?
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Pravin AsarPrincipal Systems EngineerCommented:
Generally for access, username/password are not used.

Clarification on earlier comment:

CF 9 does support Access, but only CF 9 32bit may be used, As around year 2009 /2010 Office products were 32 bit.

You can search for "cf9 64bit support for access database"
0
sgleeAuthor Commented:
If I install Access 2003 (instead of version 2010), would it be better then?
0
sgleeAuthor Commented:
CF Data Source Name PropertiesSolution Found!
1. Clear datasource name, if there is, in CF Data Source.
2. Create Data Source Name (that you are going to use in CF) in System DNS tab in C:\Windows\System32\odbcad32.exe. Make sure to select Access database file name.
3. Create Data Source Name (that you are going to use in CF) in System DNS tab in C:\Windows\SysWOW64\odbcad32.exe. Make sure to select Access database file name.
4. Open CF admin, Data Sources and create the same name and enter database folder location and file name.  Keep the default settings such as "Use Default User name" or "ColdFusion Password".

That is it.
0
_agx_Commented:
Glad you got it working!  

FWIW, about your question "What is this for (username and password)?"  IIRC, Access databases used to default to:

username: admin
password:  (blank/no password)

Checking "Use default username" defaults to those values so you don't have to enter them manually.
0
sgleeAuthor Commented:
Solution Found!
1. Clear datasource name, if there is, in CF Data Source.
2. Create Data Source Name (that you are going to use in CF) in System DNS tab in C:\Windows\System32\odbcad32.exe. Make sure to select Access database file name.
3. Create Data Source Name (that you are going to use in CF) in System DNS tab in C:\Windows\SysWOW64\odbcad32.exe. Make sure to select Access database file name.
4. Open CF admin, Data Sources and create the same name and enter database folder location and file name.  Keep the default settings such as "Use Default User name" or "ColdFusion Password".

That is it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.