DNS Connection Error

[nicolo]

:(
I have tested a number of test CF pages successfully, and all seems to be
going well.
However, when I attempt to create a query, and establish a connection with a
sample Access Data Base, I receive the following message:
"Connection verification failed for data source: BlueSky
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to
connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info."

I can sign on to CF Administrator, so I know that the password is good.
I'm not aware of a username being required any where in the specs.
I attempted to uninstall and re-install CF, but I was unable to un-install.

I would welcome any insights.
Thanks

[rwright220]

i'm struggling with the same error as we speak. what version of cf server and
ms access are you running? i'm running access 2002 and cf 6.0. I thought it
might be a firewall thing, but i eliminated that possibility. i'm stumped.
never had this problem in older versions of cf and access.

[nicolo]

:(
I am running CF Version 6.0 and Windows 2000 V 5.1.
I upgraded to XP recently. Don't know if the upgrade from ME caused the
problem.
But my CF applications execute OK.
The problem is connecting to an Access Data base. Keep getting same error
message.
I'm dead in the water on this one.
If some bright individual doesn't bail us out, I will need to consider moving
to an IIS platform.

[nicolo]

:(
As the initiator of the original question/problem, I would like to add to my
comment.
Can someone decipher what the error mesaage is asking.
For example,"....check your username,password, URL and other connectivivity
info...."

Why is the system requesting username and password for the creation of a Data
Source.
My path definition to the data base is correct.

The error message does not appear to make sense for the intended procedure.

[mpwoodward *TMM*]

On 2005-07-08 14:19:52 -0500, "nicolo" <webforumsuser@macromedia.com> said:

> :(
> I have tested a number of test CF pages successfully, and all seems to
> be going well.
> However, when I attempt to create a query, and establish a connection
> with a sample Access Data Base, I receive the following message:
> "Connection verification failed for data source: BlueSky
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other connectivity info.
> The root cause was that: java.sql.SQLException: SQLException occurred
> in JDBCPool while attempting to connect, please check your username,
> password, URL, and other connectivity info."
>
> I can sign on to CF Administrator, so I know that the password is good.
> I'm not aware of a username being required any where in the specs.
> I attempted to uninstall and re-install CF, but I was unable to un-install.

The CF admin password doesn't have anything to do with your database
password, so there's no need to uninstall CF because that likely
doesn't have anything to do with your problem.

If you have assigned a user name and password *to your Access
database*, then you would need to enter that information in the
datasource creation form in the CF administrator. If you haven't, then
occasionally I've seen cases where Access datasources need to have
"system" (no quotes) as the user name with a blank password. Try that
and see what happens.

If that doesn't work you could create an ODBC datasource in Windows
itself (NOT in CF, but in Windows) and CF can use that. I wouldn't
recommend that route since the performance will be slower (not that
Access is exactly speedy as it is), but if you can't get anything else
working that would definitely resolve the problem.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[nicolo]

:(
Matt:
Many thanks for the input.

I have been unsuccessful in attempting all of your suggestions regarding my
DNS Connection problem.
Also, I am unaware as to how to create an ODBC connection in Windows. The only
ODBC option I see in Windows is for Oracle.

As an aside, I am attempting to create a DNS connection for a query using a
sample Access Data base created in the Macromedia WA eCart extension.
I follow their instructions for creating an Access DNS, and the instructions
in CF, and all fails.
I would think that someone who knows the inside of the generated Java code
could shed some light on exactly what is happening and what CF is looking for
that is not being provided.

I would welcome any additional guidance.

[mpwoodward *TMM*]

On 2005-07-09 12:15:17 -0500, "nicolo" <webforumsuser@macromedia.com> said:

> :(
> Matt:
> Many thanks for the input.
>
> I have been unsuccessful in attempting all of your suggestions
> regarding my DNS Connection problem.
> Also, I am unaware as to how to create an ODBC connection in Windows.
> The only ODBC option I see in Windows is for Oracle.
>
> As an aside, I am attempting to create a DNS connection for a query
> using a sample Access Data base created in the Macromedia WA eCart
> extension.
> I follow their instructions for creating an Access DNS, and the
> instructions in CF, and all fails.
> I would think that someone who knows the inside of the generated Java
> code could shed some light on exactly what is happening and what CF is
> looking for that is not being provided.
>
> I would welcome any additional guidance.
>
>
> .

Maybe I didn't ask this before, but exactly how are you creatng your
Access datasource? Using Access with CF is pretty common so I highly
doubt there's anything inherently wrong with CF in this case. It has
to be the way in which you're setting it up that's causing the issue.

To create an ODBC datasource in Windows, you would go to Administrative
Tools/Data Sources (ODBC), and then click on the System DSN tab. Then
hit "Add" and configure your datasource with the Microsoft Access
driver.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[nicolo]

:(
Matt:
Many thanks agin for persevering on this problem of mine.
I have followed the process you outloned dilgently several dozen times and
each time I attempt to create a DNS connection I receive the same error message.
I am familiar with the procedure.
About a year agi I was running ME and at that time was in the early learning
stages of CF. I had no problems creating a DNS connection, creating an Access
DB, and maintaining it, all through CF.
I have since upgraded to XP, and this is the first time since the upgrade that
I am attempting the procedure.

So, I know it should be a "no brainer". Hence my enormous frustration.
My only remaining thought is to delete the site files I was working with,
uninstall CF and reinstall.
I welcome any additional thoughts.
Nick M.

[mpwoodward *TMM*]

On 2005-07-09 17:04:52 -0500, "nicolo" <webforumsuser@macromedia.com> said:

> :(
> Matt:
> Many thanks agin for persevering on this problem of mine.
> I have followed the process you outloned dilgently several dozen times
> and each time I attempt to create a DNS connection I receive the same
> error message.
> I am familiar with the procedure.
> About a year agi I was running ME and at that time was in the early
> learning stages of CF. I had no problems creating a DNS connection,
> creating an Access DB, and maintaining it, all through CF.
> I have since upgraded to XP, and this is the first time since the
> upgrade that I am attempting the procedure.
>
> So, I know it should be a "no brainer". Hence my enormous frustration.
> My only remaining thought is to delete the site files I was working
> with, uninstall CF and reinstall.
> I welcome any additional thoughts.
> Nick M.

I still contend that this has *nothing* to do with CF itself, but
you're welcome to try reinstalling. Can you please post more details
about specifically what you're doing? Specific things like which
database type you're selecting, the path information you're entering,
etc. would be helpful. A screenshot of your datasource configuration
screen or just a message containing all that information would be
ideal. WIthout details it's hard to rectify.

Also, did you try creating an ODBC datasource in Windows itself again?
What's going on there? If you can't create an ODBC datasource in
Windows successfully, then there might be something wrong with the
database file itself.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[nicolo]

:(
Matt:
My sincere thanks agin for "hanging in" with this one.....especially on
weekends !!
I am working with a WA eCart tutorial and am attemting to create a DNS entry
for one of the sample Access Data bases, "sample_store.mdb".

In the "Add New Data Source" panel of CF Administrator panel, the following is
entered:
Data Source Name: BlueSkyData
Driver: Microsoft Access

In the "Microsoft Access Data Source Panel: BlueSkyData" panel of CF
Administrator, the following was entered:
CF Data Source Name: BlueSkyData
Database File: C:\CFusionMX\wwwroot\Starting_Points\Database\samp le_store.mdb

When I enter "submit" the usual DNS error message appears.
It truly should be a no brainer, but I am mustbe absolutely overlooking a key
point.

Not sure where I go from here.
All ideas, nonetheless are welcome.
Nick M

[mpwoodward *TMM*]

On 2005-07-10 10:57:19 -0500, "nicolo" <webforumsuser@macromedia.com> said:

> :(
> Matt:
> My sincere thanks agin for "hanging in" with this one.....especially
> on weekends !!
> I am working with a WA eCart tutorial and am attemting to create a DNS
> entry for one of the sample Access Data bases, "sample_store.mdb".
>
> In the "Add New Data Source" panel of CF Administrator panel, the
> following is entered:
> Data Source Name: BlueSkyData
> Driver: Microsoft Access
>
> In the "Microsoft Access Data Source Panel: BlueSkyData" panel of CF
> Administrator, the following was entered:
> CF Data Source Name: BlueSkyData
> Database File: C:\CFusionMX\wwwroot\Starting_Points\Database\samp le_store.mdb
>
> When I enter "submit" the usual DNS error message appears.
> It truly should be a no brainer, but I am mustbe absolutely
> overlooking a key point.
>
> Not sure where I go from here.
> All ideas, nonetheless are welcome.
> Nick M

What version of CF are you on? CFMX 7? Have you tried the Access with
Unicode driver just for kicks? I assume you've checked the obvious
things like making sure your database is in the correct directory, that
you don't have any funky permissions set on the directory that would
cause issues, etc.

Also, what's the "usual DSN error message"? What *exactly* do you see
when you hit submit?

Again, you REALLY need to try configuring this as an ODBC datasource in
Windows. That might reveal something that would help you figure out
why it isn't working in CF.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[nicolo]

:(
Matt:
This is the usual message I receive when attempting to configure a DSN in CF :

"Connection verification failed for data source: BlueSky
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to
connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info."

Can you point me to the specific steps to create an ODBC connection in Windows.
I believe I basically understand the process, but I would like to be
absolutely sure I don't miss anything.
(I have tried it once and received the same error message as above.)
Nick M.

[mpwoodward *TMM*]

On 2005-07-10 14:45:06 -0500, "nicolo" <webforumsuser@macromedia.com> said:

> :(
> Matt:
> This is the usual message I receive when attempting to configure a DSN in CF :
>
> "Connection verification failed for data source: BlueSky
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other connectivity info.
> The root cause was that: java.sql.SQLException: SQLException occurred
> in JDBCPool while attempting to connect, please check your username,
> password, URL, and other connectivity info."
>
> Can you point me to the specific steps to create an ODBC connection in
> Windows.
> I believe I basically understand the process, but I would like to be
> absolutely sure I don't miss anything.
> (I have tried it once and received the same error message as above.)
> Nick M.

You won't receive a JDBC error if you're creating an ODBC connection,
and if you still get a username/password error, are you sure the Access
database doesn't actually HAVE a user name and password associated with
it? I just want to make sure nothing obvious is going on here.

To create an ODBC datasource in Windows XP:
1. Start -> All Programs -> Administrative Tools -> Data Sources (ODBC)
2. Click on System DSN tab
3. Click "Add"
4. Choose "Microsoft Access Driver (*.mdb)"
5. Click Finish
6. Enter the data source name--this can be anything (don't use spaces
or special characters)
7. Description can be anything or leave it blank
8. Under "Database" click Select
9. Locate your Access database file and click OK
10. Click OK again

That should create the datasource. Now if you log into your CF
administrator and create a new datasource, but for the Driver choose
"ODBC Socket". Then click Add and for the ODBC DSN choose the one you
just created for your Access database from the drop-down list. By
default for the user name it will probably say "system" and have a
blank password. Leave that as is and hit OK and see if that works.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[nicolo]

:(
Matt:
Followed your instructions to a "T", but still received the same JDBC error
message.
I have a note off to the Web Assist folks to ask about the possible obvious
question regarding whether the data base requires a user name and password for
access. (Nowhere in their tutorial documentation did I notice any mention)
Hopefully they will respond on Monday. I will let you know their response as
soon as I receive it.
If this all works out (and I'm sure it will), I will owe you a beer or two.
Nick M.

[nicolo]

:(
Matt:
I created a simple Access DB and attempted to create a DNS connection through
Windows and/or through CF Administrator.
:o
Truly is embarrassing that I cannot succeed with this simple process.
I'm not sure where I go from here.
Perhaps I need a house call.
Nick M.

[mpwoodward *TMM*]

On 2005-07-11 18:00:34 -0500, "nicolo" <webforumsuser@macromedia.com> said:

> :(
> Matt:
> I created a simple Access DB and attempted to create a DNS connection
> through Windows and/or through CF Administrator.
> :o
> Truly is embarrassing that I cannot succeed with this simple process.
> I'm not sure where I go from here.
> Perhaps I need a house call.
> Nick M.

Can you provide some details as to how you tried this through Windows
and what happened? Were you able to create an ODBC datasource in
Windows? Does the datasource at least show up in the dropdown list
when you go into the CF administrator and try to create a datasource
using an ODBC socket? You're not giving much in the way of details,
which makes it difficult to try and help. When you created a simple
Access database did it behave exactly as your other database did? Do
you have the ability to try this on a different computer?

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[rwright220]

Nicolo/Matt,

I've been following this thread, having the exact same symptoms as you. I
still have had no luck either, even after trying the ODBC route.

I noticed that new jdbc drivers became avail on 6/22:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0[/url]

Matt, would it hurt for us to try and install these new drivers?

-rob

p.s. For Matt,
If I ignore the error message in cf admin and just try and write a program
using the datasource, I get a very similar error message that I see in the
admin, plus a stack trace, full of all kinds of info. Not sure if this is
helpful?

java.sql.SQLException: SQLException occurred in JDBCPool while attempting to
connect, please check your username, password, URL, and other connectivity info.
at jrun.sql.pool.JDBCPool.requestConnection(JDBCPool. java:640)
at jrun.sql.pool.JDBCManager.requestConnection(JDBCMa nager.java:125)
at jrun.sql.JRunDataSource.getConnection(JRunDataSour ce.java:232)
at jrun.sql.JRunDataSource.getConnection(JRunDataSour ce.java:172)
at coldfusion.sql.DataSrcImpl.getCachedConnection(Unk nown Source)
at coldfusion.sql.DataSrcImpl.getConnection(Unknown Source)
at coldfusion.sql.SqlImpl.execute(Unknown Source)
at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
at cftestmm2ecfm531760913.runPage(C:\CFusionMX\wwwroo t\testmm.cfm:3)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unkno wn Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.inv oke(Unknown Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:241)
at jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebSer vice.java:172)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)

[nicolo]

:o
Matt:
The following is some additional detail regarding this DSN connection problem:
1. When I create an ODBC datasource in Windows XP there is no problem and it
is created successfully.
2.The datasource shows up in the dropdown list when I go into CF Admisistrator
when trying to create a datasource using an ODBC socket .
3. At that point when I hit "Submit", the error message pops up.

I suspect that there is some setting in CF Admisistrator that may be causing
the problem.
In the "Settings Summary" of CF Administrator under "JVM Details", there is a
setting for "user name" set to "Nicholas".

I tried using that user name to create a datasource using an ODBC socket in CF
Administrator and that was not successful as well.
When we find the cause of the problem, I'm sure it will be due to some trival
oversight somewhere that I have overlooked;.....as is always the case with
these things.

[mpwoodward *TMM*]

On 2005-07-12 07:46:14 -0500, "nicolo" <webforumsuser@macromedia.com> said:

> :o
> Matt:
> The following is some additional detail regarding this DSN connection problem:
> 1. When I create an ODBC datasource in Windows XP there is no problem
> and it is created successfully.
> 2.The datasource shows up in the dropdown list when I go into CF
> Admisistrator when trying to create a datasource using an ODBC socket .
> 3. At that point when I hit "Submit", the error message pops up.

I'm sure you have tried this, but just to be sure, taking the ODBC
socket out of the equation for the moment, have you tried BOTH Access
drivers (Unicode and regular)? Have you tried blanking out the user
name (defaults to system) and password, as well as leaving the user
name system in there but leaving the password blank? Also, do you have
the ability to create a datasource to a different type of database like
SQL Server? Can you create datasources to ANYTHING?

I know I asked this before but I'm not sure I ever got an answer: are
you running any firewall software that might be causing weird stuff to
happen (e.g. XP SP2, ZoneAlarm, Norton Internet Security)?

> I suspect that there is some setting in CF Admisistrator that may be
> causing the problem.
> In the "Settings Summary" of CF Administrator under "JVM Details",
> there is a setting for "user name" set to "Nicholas".

You're conflating unrelated things in my opinion--try not to go poking
around all over the CF administrator and changing random settings
because you might cause new problems, and if nothing else it makes it
hard to troubleshoot because the testing becomes rather unscientific.
Let's focus on specifically what we know is involved here. The user
name in the JVM Details area has nothing whatsoever to do with the
datasource user name and password issue as far as I know, and if the
database doesn't have a user name and password assigned to it, the
error message you're seeing might be a bit of a red herring.

Something else just came to mind: did you alter the user CF is running
as? Does the user CF is running as have access to the directory where
the Access dataabse is? In other words, is there anything
security-wise going on at the OS level that might be causing these
problems?

> I tried using that user name to create a datasource using an ODBC
> socket in CF Administrator and that was not successful as well.

Again, if your Access database doesn't have a user name and password
assigned to it, then you don't need to do this.

> When we find the cause of the problem, I'm sure it will be due to some
> trival oversight somewhere that I have overlooked;.....as is always the
> case with these things.

Sorry this is dragging on--I'm just a bit dumbfounded since I've never
had this issue occur myself. Try some of the stuff I mentioned above
with the different drivers and see what happens. My gut tells me it's
a permission issue at the OS level or there's something else weird
going on with your setup (e.g. firewall) that is causing the problem.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[mpwoodward *TMM*]

On 2005-07-12 06:14:12 -0500, "rwright220" <webforumsuser@macromedia.com> said:

> Nicolo/Matt,
>
> I've been following this thread, having the exact same symptoms as
> you. I still have had no luck either, even after trying the ODBC route.
>
> I noticed that new jdbc drivers became avail on 6/22:
> [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0[/url]
>
> Matt, would it hurt for us to try and install these new drivers?
>
> -rob
>
> p.s. For Matt,
> If I ignore the error message in cf admin and just try and write a
> program using the datasource, I get a very similar error message that I
> see in the admin, plus a stack trace, full of all kinds of info. Not
> sure if this is helpful?

Can't hurt to try everything at this point I suppose--are you on CFMX 7?

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion