Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-03-02 Thread Jochem van Dieten
Will Blackie said: > > I've tried changing over a few of my sites to use the access unicode > driver but i suspect that without changing them all i may not see > any dramatic improvement - the server is still crashing pretty > regularly. When it crashes, are the sites that use the access unicode d

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-03-01 Thread Rob
On Mon, 2004-03-01 at 15:14, Will Blackie wrote: > # HotSpot Virtual Machine Error, Internal Error > # Please report this error at > # http://java.sun.com/cgi-bin/bugreport.cgi > # > # Java VM: Java HotSpot(TM) Server VM (1.4.2-b28 mixed mode) Not sure if it will help but there is a newer JVM out 1

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-03-01 Thread peter . tilbrook
;   cc:            Subject:  Access & Coldfusion MX6.1 problems...sites keep dying   02/03/2004 10:14   

Access & Coldfusion MX6.1 problems...sites keep dying

2004-03-01 Thread Will Blackie
Thanks for the responses that have been posted with regard to this problem a few of us are experiencing.  Just to recap for anyone new looking at this post that might be helpful I have a windows 200 server running CFMX 6.1 that keeps crashing - the sites running an access database are unable to get

RE: Access & Coldfusion MX6.1 problems...sites keep dying

2004-03-01 Thread Donnie Bachan
It's the one that says "Microsoft Access with Unicode", that one worked for me. It's on all of our servers by default upon installing CFMX. Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 "Nitendo Vinces - By Striving You Shall Conquer" [Todays Threads] [This Message] [Subscription] [Fa

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-03-01 Thread Jochem van Dieten
DURETTE, STEVEN J (AIT) wrote: >   > I tried looking for the unicode driver in the drop down, but all that is > listed is Access.  The dropdown you are talking about is on the CFA > Datasources page right (Add datasource above a listing of all the current > datasources). Should be there: http://li

RE: Access & Coldfusion MX6.1 problems...sites keep dying

2004-03-01 Thread DURETTE, STEVEN J (AIT)
Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 12:15 PM To: CF-Talk Subject: Re: Access & Coldfusion MX6.1 problems...sites keep dying Josen Ruiseco wrote: > Is the unicode driver just useful for Access or will it stabilize Sql > Server 2000 also? Where can it be found? A

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Phillip Beazley
At 06:54 PM 2/27/2004, you wrote: >You might find a solution at OpenLink -- I was able to interface CFMX >OS X to An Access Database running under VirtualPC Will take a look.  Thanks! -- Phillip Beazley Onvix -- Website Hosting, Development & E-commerce Visit http://www.onvix.com/ or call 727-5

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Dick Applebaum
You might find a solution at OpenLink -- I was able to interface CFMX OS X to An Access Database running under VirtualPC http://oplweb.openlinksw.com/product/webmatrixst.asp ( HTH Dick On Feb 27, 2004, at 2:18 PM, Phillip Beazley wrote: > At 04:43 PM 2/27/2004, you wrote: > >  >You might want

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Phillip Beazley
At 04:43 PM 2/27/2004, you wrote: >You might want to ask that on a mailinglist for that application >language. It can only use ODBC, period.  I was wondering if there was an ODBC-to-JDBC bridge thingy, to bypass this problem. -- Phillip Beazley Onvix -- Website Hosting, Development & E-commerc

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Jochem van Dieten
Phillip Beazley wrote: > At 12:28 PM 2/27/2004, you wrote: >> >> I don't use MS SQL Server so I haven't compared it, but IIRC Paul >> Hastings recommends it. >> But the most important thing from this thread appears to be that >> people need to stop using the JDBC-ODBC bridge (Type 1) and >> switch

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Josen Ruiseco
Regarding the Microsoft JDBC driver, have you heard if that lessens or elimiantes the "Could not connect to JRUN Server" error? Josen >Josen Ruiseco wrote: > >> Is the unicode driver just useful for Access or will it stabilize Sql >> Server 2000 also? Where can it be found? > >Access only, and

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Phillip Beazley
At 12:28 PM 2/27/2004, you wrote: >I don't use MS SQL Server so I haven't compared it, but IIRC Paul >Hastings recommends it. >But the most important thing from this thread appears to be that >people need to stop using the JDBC-ODBC bridge (Type 1) and >switch to a JDBC Type 3 or Type 4 driver. Ev

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Jochem van Dieten
Dave Watts wrote: >> For MS SQL Server, use the JDBC driver from Microsoft. > > Jochem, have you run into any issues with that? I've only started testing > it. Have you compared it with the latest DataDirect Connect for JDBC > version? I don't use MS SQL Server so I haven't compared it, but IIRC

RE: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Dave Watts
> For MS SQL Server, use the JDBC driver from Microsoft. Jochem, have you run into any issues with that? I've only started testing it. Have you compared it with the latest DataDirect Connect for JDBC version? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Jochem van Dieten
Josen Ruiseco wrote: > Is the unicode driver just useful for Access or will it stabilize Sql > Server 2000 also? Where can it be found? Access only, and it is just in the dropdown menu. For MS SQL Server, use the JDBC driver from Microsoft. Jochem -- I don't get it immigrants don't work and

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Josen Ruiseco
Is the unicode driver just useful for Access or will it stabilize Sql Server 2000 also? Where can it be found? Josen www.gomotorbids.com >Donnie Bachan said: >> We are experiencing this problem also. I have tried the hotfixes on >> Macromedia's site, which do not really apply to MS Access but it

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Donnie Bachan
This seems to have done the trick for the time being. It is too early to really tell if it has cured all my woes but my preliminary tests have been successful and the system isn't hanging as before with the exact same tests. The speed has improved significantly as well! Thanks Johcem! Best Reg

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Donnie Bachan
Jochem van Dieten wrote: >Have you tried the unicode driver? No I haven't actually, going to try this now. I am willing to try anything at this point! Thanks! Best Regards, Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 "Nitendo Vinces - By Striving You Shall Conquer" [Todays Threads] [T

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Nick de Voil
Jochem > It doesn't use the ODBC workaround. People have also reported dramatic > speed improvements with large datasets using this driver. OK, very interesting, thanks. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Jochem van Dieten
Nick de Voil said: >> >> Have you tried the unicode driver? > > Any particular reason why this might help? It doesn't use the ODBC workaround. People have also reported dramatic speed improvements with large datasets using this driver. Jochem [Todays Threads] [This Message] [Subscription]

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Nick de Voil
Jochem > Have you tried the unicode driver? Any particular reason why this might help? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Jochem van Dieten
Donnie Bachan said: > We are experiencing this problem also. I have tried the hotfixes on > Macromedia's site, which do not really apply to MS Access but it > couldn't  hurt. We have an application that requires a large > recordset to be returned  (~1 records), CFQUERY caching helps > somewhat

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Donnie Bachan
We are experiencing this problem also. I have tried the hotfixes on Macromedia's site, which do not really apply to MS Access but it couldn't hurt. We have an application that requires a large recordset to be returned (~1 records), CFQUERY caching helps somewhat but the problem exists whene

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Nick de Voil
> My companies live hosting server was recently upgraded to Coldfusion > MX6.1 .. and the latest MDAC / Jet Drivers have been updated also.    > The problem is that all coldfusion sites on the server using access > db's stop working every 2 days or so (more often if traffic is high).. > the only

Re: Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-24 Thread Jamie Jackson
If you've got it set to maintain connections in the administrator, have you tried disabling that setting? If not, you might try that for a few days, and see if the problem reoccurs. Jamie On Tue, 24 Feb 2004 13:40:47 +1000, in cf-talk you wrote: >Please Help > >My companies live hosting server w

Access & Coldfusion MX6.1 problems...sites keep dying

2004-02-23 Thread Will Blackie
Please Help My companies live hosting server was recently upgraded to Coldfusion MX6.1 .. and the latest MDAC / Jet Drivers have been updated also.   The problem is that all coldfusion sites on the server using access db's stop working every 2 days or so (more often if traffic is high).. the only