Hi, I'm not able to connect to a certain database with the Zope ODBC database adapter. I can connect to other servers with no problems but when I try to connect to this other server I get the error "Invalid connection string". I'm using a connection string like: "DSN username password". I know the name and password are correct because I can connect to it with other client utilities. Has anyone had a problem like this? or see any obvious mistakes I'm making? thanks -Kevin
Kevin Lewandowski wrote:
Hi,
I'm not able to connect to a certain database with the Zope ODBC database adapter. I can connect to other servers with no problems but when I try to connect to this other server I get the error "Invalid connection string". I'm using a connection string like: "DSN username password". I know the name and password are correct because I can connect to it with other client utilities.
Has anyone had a problem like this? or see any obvious mistakes I'm making?
thanks
-Kevin
Make a System DSN in the ODBC control in the Windows control panel, and use that DSN to connect from Zope. -- Matt Kromer Zope Corporation http://www.zope.com/
Hi Kevin, I had a similar problem with ZODBCA and Access some time back. It turned out to be because another user was connected to the Access MDB file via another instance of Access and the supplied GUI and ZODBCA wanted an exclusive lock on it. Not good. We needed for both to be able to occur at the same time.. (multiple GUI users and the write-capable ODBC access..) This locking might not be a problem if the DB was accessed via ODBC read-only. (just guessing here) but it was a show-stopper for us. I'd love to know of any workarounds if anyone knows any.. I'm also curious if this is a 'feature' of simply the ODBC adaptor or Access itself.. or both.. It appears that what Access lacks is even a rudimentary transaction feature.. -Chris
Hi,
I'm not able to connect to a certain database with the Zope ODBC database adapter. I can connect to other servers with no problems but when I try to connect to this other server I get the error "Invalid connection string". I'm using a connection string like: "DSN username password". I know the name and password are correct because I can connect to it with other client utilities.
Has anyone had a problem like this? or see any obvious mistakes I'm making?
thanks
-Kevin
I have a nice javascript that renders the time works fine in dtml How can I use this in zpt pages ? For whom it might want to use it the javascript is attached TIA, R.
On Wed, Jun 12, 2002 at 05:45:28PM +0200, Roel Van den Bergh wrote:
I have a nice javascript that renders the time works fine in dtml How can I use this in zpt pages ?
For whom it might want to use it the javascript is attached
TIA, R.
Do you mean that your javascript is in its own object (zpt or DTMLMethod or file etc) and you want it as part of your zpt? If so then you can just use something like: <span tal:replace="structure here/path/to/javascript">javascript</span> or like this if you don't like spans hanging around <tal:x replace="structure here/path/to/javascript">javascript</tal:x> The key to this is including "structure" in your tal:replace statement. This lets the parser know that it shouldn't display your javascript code. HTH Chris Meyers
Roel Van den Bergh writes:
I have a nice javascript that renders the time works fine in dtml How can I use this in zpt pages ? ... The same way! You tried and it did not work? What went wrong?
The SGML comment at the start and end of the script might pose a problem. But I would use an external JavaScript and not embed it inside the page. This way, you give your browser a change to cache the script, your page gets smaller, loads faster and is easier to maintain. And the SGML comment problem goes away... Dieter
participants (6)
-
Chris Beaumont -
Chris Meyers -
Dieter Maurer -
Kevin Lewandowski -
Matthew T. Kromer -
Roel Van den Bergh