newbie needs help with data source

[Guest]

Running Windows XP; ColdFusion 8 Developer Edition w/Microsoft Access & Dreamweaver CS3.

I've installed ColdFusion, and it seems to be running okay. I know my Dreamweaver is good to go (been using it). Now I want to add some dynamic pages to my web site, so I've been trying to go through the steps from all the different sources I have for setting up ColdFusion to work with Access & Dreamweaver.

I'm trying to define my Access database as my Data Source but it won't validate. I keep getting error messages associated with the username and password. And this is where all the different instructions I have (Adobe instructions for Dreamweaver or Coldfusion setup) are confusing: are the username/passwords (1) associated with the Access database or Coldfusion? (2) exactly where are they defined? (3) are they really required? But most importantly, HOW THE HECK DO I SET THIS BUGGER UP SO THAT I CAN MOVE ON???? (yes, I meant to use all caps!)

[BKBK]

(1) datasource username/password are those of the database
(2) in the datasource page in the Coldfusion Administrator, when you set up the datasource
(3) if the database requires username/password, then you will need to enter them in the datasource settings in the Administrator

[Daverms]

Hi,

Also go through this article through which will really help you to understand the basic datasource related things.

[Guest]

thanks for the reference. I followed the instructions, but still came up with this error:

Connection verification failed for data source: interestsurvey
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Not a valid account name or password.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Not a valid account name or password.


Any other ideas?

[musicmp3]

Nice article.
For music visit http://mp3walls.com

[BKBK]

I suspect the trouble is with authentication at the Microsoft DSN end. You can avoid that by choosing (in the datasource page of the Administrator) to use the driver Microsoft Access with Unicode .

[ciwluke]

i have just installed CF8 and configured it but i am having trouble with MS Access , i have read many articles but cannot seem to get it to work, please advise me on this issue-
when i click "database file i get this message"
"server error- IO error on server communication"

i am trying to do an Open University course using database within websites and i need to know how to connect CF8 to MS Access.

[Newsgroup_User]

If you did not enable RDS this will happen.

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18046

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


"ciwluke" <webforumsuser@macromedia.com> wrote in message
news:g7idbg$i3i$1@forums.macromedia.com...
>i have just installed CF8 and configured it but i am having trouble with MS
> Access , i have read many articles but cannot seem to get it to work,
> please
> advise me on this issue-
> when i click "database file i get this message"
> "server error- IO error on server communication"
>
> i am trying to do an Open University course using database within websites
> and
> i need to know how to connect CF8 to MS Access.
>