Hey Jake, let's test and see if your problem is CF related. Create an
ASP page that connects to your Access DB and runs a query.
I don't know if you know ASP or not, but just in case, set up your
connection something like this:
Dim ConnectionString
ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" &_
"DBQ=C:\MyDatabases\database.mdb;DefaultDir=;UID=;PWD=;"
Dim Connection
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.ConnectionTimeout = 30
Connection.CommandTimeout = 80
Connection.Open ConnectionString
' Create a RecordSet Object
Dim rs
set rs = Server.CreateObject("ADODB.RecordSet")
' Retrieve the records
rs.Open "SELECT * FROM MyTable", Connection, adOpenForwardOnly,
adLockOptimistic
' This will list all Column headings in the table
Dim item
For each item in rs.Fields
Response.Write item.Name & "<br>"
next
' This will list each field in each record
while not rs.EOF
For each item in rs.Fields
Response.Write item.Value & "<br>"
next
rs.MoveNext
wend
End Sub
rs.Close
set rs = nothing
Connection.Close
Set Connection = nothing
Hope this helps narrow down your problem,
--Ferg
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jake
Sent: Thursday, November 04, 2004 7:26 PM
To: [EMAIL PROTECTED]
Subject: Re: Problems with Access and Windows 2003 server
Thanks for the info. I tried that, but it's having the same problems as
doing it through CF admin.
Any other ideas? Could it perhaps be a problem with Windows?
Jake
Knipp, Eric wrote:
> 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
>
>
>
>
>
>
----------------------------------------------------------
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
