Where is this driver at? I just searched the C, D and E drives and came up empty handed.
On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels <r...@michaels.me.uk> wrote: > > yes that's the one and yes cf will need to be restarted > > On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis <gmorp...@gmail.com> wrote: >> >> Is this the driver: com.inzoom.adojni ? >> I might be able to snag it off the dev server and put it on prod.. >> I assume that'll require a CF service restart? >> >> Thanks Russ! >> >> >> >> On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels <r...@michaels.me.uk> wrote: >>> >>> how uncanny I had this issue just yesterday on a Chinese site that >>> required MSAccess with unicode. >>> You could try with another database to if if the cause is the JDBC >>> driver or the database, >>> Get a newer version of JDBC driver if available. >>> >>> >>> MSAccess is a PITA and has a tendency to corrupt and cause server >>> issues and then you cannot back it up due to the lock file, I would >>> just upsize it to SQL Server if I were and be done with it. >>> Remember that MSSQL Express is also FREE, so it doesn't need to cost >>> your client anything, >>> >>> On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis <gmorp...@gmail.com> wrote: >>>> >>>> I've got an old app that has to move servers and I successfully have >>>> it running on our dev server. >>>> However I can't get the DSN created on our prod server (which should >>>> be the same as dev). >>>> When I try to create it, I get: >>>> Connection verification failed for data source: twst_prod >>>> com.inzoom.adojni.ComException: Unspecified error >>>> The root cause was that: com.inzoom.adojni.ComException: Unspecified >>>> error in Microsoft JET Database Engine code=0 Type=1 >>>> We don't have the ODBC Service running on Prod, so I can't try just >>>> plain Microsoft Access. >>>> >>>> I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html >>>> >>>> Control panel -> admin tools -> ODBC Data Source Admin >>>> I created the DSN there and tried to map a DSN to it using the >>>> settings in the article. >>>> >>>> I get a different error: >>>> >>>> Connection verification failed for data source: twst_prod1 >>>> com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access >>>> Driver] System resource exceeded. >>>> The root cause was that: com.inzoom.adojni.ComException: >>>> [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in >>>> Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 >>>> It's a 2 MB access file.. I don't think it's going to exceed the >>>> system resources. >>>> >>>> Is there another way to do this that I'm not aware of? Anything else I >>>> can check? >>>> Or do I need to convert this to a different database >>>> >>>> >>> >>> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm