Re: [Zope] ZJetDA product and Microsoft Access
Hi Michael, michael nt milne wrote: > Thanks a lot. Yes I know it's crazy but some organisations built up a > database over the years and want to stay with that technology. The best > way would be to migrate but I can understand why it doesn't happen. > I understand - but the migration from Access to Access-over-SQL-Server is pretty simple, and now that a usable version of SQL Server is free (as in beer) in most cases (certainly those where Access was ever a reasonably choice), I will never use the JET database engine again! -- Regards, PhilK "Human language continually changes, innit." - Stephen Juan ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZJetDA product and Microsoft Access
Thanks a lot. Yes I know it's crazy but some organisations built up a database over the years and want to stay with that technology. The best way would be to migrate but I can understand why it doesn't happen. On 7/27/06, Philip Kilner <[EMAIL PROTECTED]> wrote: Hi Michael,michael nt milne wrote:> I know it's totally> crazy to want to hook Access up with Zope using sql queries but I'd just> like to know if it's been done or is possible.> Crazy on so many levels.../but/, although I can't tell you anythingabout the DA you are asking about, I can very strongly recommend theeGenix mxODBC DA - using that product, it is possible, and does work. --Regards,PhilK"Human language continually changes, innit."- Stephen Juan-- michael ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZJetDA product and Microsoft Access
Hi Michael, michael nt milne wrote: > I know it's totally > crazy to want to hook Access up with Zope using sql queries but I'd just > like to know if it's been done or is possible. > Crazy on so many levels.../but/, although I can't tell you anything about the DA you are asking about, I can very strongly recommend the eGenix mxODBC DA - using that product, it is possible, and does work. -- Regards, PhilK "Human language continually changes, innit." - Stephen Juan ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZJetDA product and Microsoft Access
HiThanks a lot for this. I'll try that out. Cheers.On 7/26/06, Jesper Steen Steffensen <[EMAIL PROTECTED] > wrote: HiI've had a look at this product and installed it on Zope 2.8.7. It installed fine but when I look in the 'add' menu I'm not seeing an 'add ZJetDA database connection' which you get for other installed database adapters. Possibly I'm wrong in expecting this? I know it's totally crazy to want to hook Access up with Zope using sql queries but I'd just like to know if it's been done or is possible. Thanksmichael I've tried the ZJet adapter as well without luck. Go with the ZODB DA instead.It works perfectly.To connect to an MS Access DB on a windows machine you'll need to set the DB up as a system data source on the machine. This is done in the Start menu -> Administration -> ODBC datasources. Add a system data source in there, and browse to your mdb file. Give the data source a name of your own choice, and when you go back into the zope manager and add the DB connection you need to write this data source name (DSN) in the connection string. After that your ZSQL methods will work perfectly. Worked for me. I was forced to use an MS Access DB as well due to some very strict network policies about approved software for the network. ___Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding! **(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )-- michael ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZJetDA product and Microsoft Access
HiI've had a look at this product and installed it on Zope 2.8.7. It installed fine but when I look in the 'add' menu I'm not seeing an 'add ZJetDA database connection' which you get for other installed database adapters. Possibly I'm wrong in expecting this? I know it's totally crazy to want to hook Access up with Zope using sql queries but I'd just like to know if it's been done or is possible. Thanksmichael I've tried the ZJet adapter as well without luck. Go with the ZODB DA instead.It works perfectly.To connect to an MS Access DB on a windows machine you'll need to set the DB up as a system data source on the machine. This is done in the Start menu -> Administration -> ODBC datasources. Add a system data source in there, and browse to your mdb file. Give the data source a name of your own choice, and when you go back into the zope manager and add the DB connection you need to write this data source name (DSN) in the connection string. After that your ZSQL methods will work perfectly. Worked for me. I was forced to use an MS Access DB as well due to some very strict network policies about approved software for the network. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] ZJetDA product and Microsoft Access
HiI've had a look at this product and installed it on Zope 2.8.7. It installed fine but when I look in the 'add' menu I'm not seeing an 'add ZJetDA database connection' which you get for other installed database adapters. Possibly I'm wrong in expecting this? I know it's totally crazy to want to hook Access up with Zope using sql queries but I'd just like to know if it's been done or is possible. Thanks-- michael ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
