RE: [Zope] Re: Zope digest, Vol 1 #1246 - 50 msgs -- Connecting M S Access to Zope by ZODBC
Have you set up your Access Database as a System DSN? Time for a mini-HOWTO: Jfarr knows that I did this a lot when I first started with zope. I kept bugging him for help :) I'm on WinNT4 SP6a: First, select Data Sources (ODBC) from the Control Panel. We want to add a System DSN. After selecting Add under the System DSN tab, we get a lovely 'Create New Data Source' dialog. Highlight Microsoft Access Driver (*.mdb) and select Finish. This brings up yet another dialog box asking questions: ODBC Microsoft Access Setup. Fill in the blanks: Data Source Name: Think of this like a zope id. I used something like bmsprofdb for the 'Business Media Services Profiles Database'. Description: Uh. I think this deserves it's own HOWTO :) The group of buttons labeled Database is for selection of an existing database, creation of a new one, repair and compaction of an existing database. For more information on these, see MS Access Help. For most setups, you won't want to select a System Database, and I don't know much about it, so you are on your own there. If you click options, you will see an additional group of settings. You may have to tweak these if you have heavy traffic, but if you have heavy traffic, you probably need a different database :) Clicking Advanced gives you the power to set more advanced options, like usernames, passwords, and working directories. This is also Access specific stuff. After you have setup this, go to Zope and select add a new ZODBC adapter. You will see the system DSN you have added. Highlight and add. The world is your oyster. Troy -----Original Message----- From: Loren Stafford [mailto:lstafford@morphics.com] Sent: Tuesday, March 13, 2001 11:37 AM To: diarmaid@bigfoot.com; zope@zope.org Subject: RE: [Zope] Re: Zope digest, Vol 1 #1246 - 50 msgs Show us the error message and traceback. And, if you could use a better subject line, maybe more people would look at your message. -- Loren
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Diarmaid Lynch Sent: Tuesday, March 13, 2001 07:41 To: zope@zope.org Subject: [Zope] Re: Zope digest, Vol 1 #1246 - 50 msgs
Hi there,
I'm setting up a MS Access database for a project I'm working and would like to use it with my Zope site.....having a little trouble though. Installed the Zope ODBC adaptor but don't know how to connect it to Zope?
keeps giving me "bad request" errors when I try to specify a connection string / any connection string!
Is there more to installing the ODBC adaptor than just importing it to the products folder?
Seeking guidance ...
Cheers
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Hi Loren, I ended up just reinstalling everthing last night.... and hey presto it worked! Thanks for the help though,
participants (2)
-
Diarmaid Lynch -
Farrell, Troy