There are several ways to access a database from CF. The main two
ways to get to access would be via a JDBC connection (which is what you're
using if you use the access drivers packaged with CF). The other way is to
create an ODBC DSN for the database in your windows control panel, and then
access that DSN from CFMX by adding an ODBC Socket datasource to the
administrator, which would reference the DSN you created. Its a good idea
to name them the same thing, for simplicity's sake.
You may be having a problem with the native JDBC driver that CFMX is
using to access the database. I can't really explain what might have
happened to break it, but its worth using the ODBC driver to see if that
will function. If it does, you can either stick with that driver, or
possibly replace the JDBC driver as it may have become corrupted somehow.
Good luck,
Eric
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Jake
Sent: Wednesday, November 03, 2004 1:09 PM
To: [EMAIL PROTECTED]
Subject: Re: Problems with Access and Windows 2003 server
Not sure I follow. To use Access, don't I have to use the Access drivers?
Jake
Knipp, Eric wrote:
> Try using the ODBC drivers instead and see if that works out for
>you.
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Behalf Of Jake
>Sent: Wednesday, November 03, 2004 10:21 AM
>To: [EMAIL PROTECTED]
>Subject: Re: Problems with Access and Windows 2003 server
>
>
>Standard ColdFusion Admin drivers.
>
>Jake
>
>Knipp, Eric wrote:
>
>
>
>> Are you trying to connect via ODBC or via the JDBC drivers that come
>>packaged with CF (or some other JDBC driver)?
>>
>> Eric
>>
>>-----Original Message-----
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>>Behalf Of Jake
>>Sent: Wednesday, November 03, 2004 10:03 AM
>>To: [EMAIL PROTECTED]
>>Subject: Problems with Access and Windows 2003 server
>>Importance: High
>>
>>
>>All,
>>
>>The server I'm on just recently was upgraded to Windows2003. While
>>everything else seems to be running fine, the one thing that didn't make
>>the transition very well as that the Access and Access w/ Unicode
>>drivers don't seem to be working. I can't get any datasource using those
>>drivers to verify.
>>
>>And when you hit the sites that they are running, I get the following
>>
>>
>error:
>
>
>> Error Executing Database Query.
>>
>>
>>coldfusion.sql.DatabaseConnectionException: Timed out trying to
>>establish connection
>>
>>I know, Access is not great but it should at least be functional! And
>>there has been no code change, no DB change, nothing. We have the latest
>>MX version on the server, the latest Access Jet drivers.
>>
>>Anyone heard of this? If so, how do I fix?? Help!!
>>
>>Thanks!
>>Jake
>>----------------------------------------------------------
>>To post, send email to [EMAIL PROTECTED]
>>To unsubscribe:
>> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
>>To subscribe:
>> http://www.dfwcfug.org/form_MemberRegistration.cfm
>>
>>
>>-----------------------------------------
>>CONFIDENTIALITY NOTICE: The information contained in this e-mail and
>>attached document(s) may contain confidential information that is intended
>>only for the addressee(s). If you are not the intended recipient, you are
>>hereby advised that any disclosure, copying, distribution or the taking of
>>any action in reliance upon the information is prohibited. If you have
>>received this e-mail in error, please immediately notify the sender and
>>delete it from your system.
>>
>>----------------------------------------------------------
>>To post, send email to [EMAIL PROTECTED]
>>To unsubscribe:
>> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
>>To subscribe:
>> http://www.dfwcfug.org/form_MemberRegistration.cfm
>>
>>
>>
>>
>>
>>
>>
>----------------------------------------------------------
>To post, send email to [EMAIL PROTECTED]
>To unsubscribe:
> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
>To subscribe:
> http://www.dfwcfug.org/form_MemberRegistration.cfm
>
>
>-----------------------------------------
>CONFIDENTIALITY NOTICE: The information contained in this e-mail and
>attached document(s) may contain confidential information that is intended
>only for the addressee(s). If you are not the intended recipient, you are
>hereby advised that any disclosure, copying, distribution or the taking of
>any action in reliance upon the information is prohibited. If you have
>received this e-mail in error, please immediately notify the sender and
>delete it from your system.
>
>----------------------------------------------------------
>To post, send email to [EMAIL PROTECTED]
>To unsubscribe:
> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
>To subscribe:
> http://www.dfwcfug.org/form_MemberRegistration.cfm
>
>
>
>
>
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
-----------------------------------------
CONFIDENTIALITY NOTICE: The information contained in this e-mail and
attached document(s) may contain confidential information that is intended
only for the addressee(s). If you are not the intended recipient, you are
hereby advised that any disclosure, copying, distribution or the taking of
any action in reliance upon the information is prohibited. If you have
received this e-mail in error, please immediately notify the sender and
delete it from your system.
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
