I am working on Win-32 platform (Windows 95). I installed MySQL ver.3.23 I have MyOBDC, ZOPE I installed ZmySQLDA in Products directory of ZOPE. I follow all the istructions. I am working whit all applications on my PC. So, after writed the "simple string connection" database@myhost:8080 UID PASSWD the python of ZOPE crash whitin the followin message: Unhandled exception in thread: Traceback (innermost last): File "C:\Program Files\WebSite\ZServer\PubCore\ZServerPublisher.py", line 97, in __init__ response._finish() File "C:\Program Files\WebSite\ZServer\HTTPResponse.py", line 281, in _finish stdout.close() File "C:\Program Files\WebSite\ZServer\HTTPResponse.py", line 338, in close Wakeup() File "C:\Program Files\WebSite\ZServer\medusa\select_trigger.py", line 153, in pull_trigger self.trigger.send ('x') File "<string>", line 1, in send socket.error: (10038, 'winsock error') I have reinstalled mysql, I try by ODBC manager and the connection is OK. Any suggestions why the connection is not working properly? Thanks
See comments below. ----- Original Message ----- From: <Stefano.Blasi@esa.int> To: <zope@zope.org> Cc: <stevex@tiscalinet.it> Sent: Tuesday, June 19, 2001 4:07 PM Subject: [Zope] database string connection??????
I am working on Win-32 platform (Windows 95). I installed MySQL ver.3.23 I have MyOBDC, ZOPE I installed ZmySQLDA in Products directory of ZOPE. I follow all the istructions. I am working whit all applications on my PC. So, after writed the "simple string connection" database@myhost:8080 UID PASSWD
--------------------------------------------------------------------^^^^ Why have you got the 8080 here? Is MySQL running on a nonstandard port? Try taking the port out and see if that works.
the python of ZOPE crash whitin the followin message:
Unhandled exception in thread: Traceback (innermost last): File "C:\Program Files\WebSite\ZServer\PubCore\ZServerPublisher.py", line 97, in __init__ response._finish() File "C:\Program Files\WebSite\ZServer\HTTPResponse.py", line 281, in _finish stdout.close() File "C:\Program Files\WebSite\ZServer\HTTPResponse.py", line 338, in close Wakeup() File "C:\Program Files\WebSite\ZServer\medusa\select_trigger.py", line 153, in pull_trigger self.trigger.send ('x') File "<string>", line 1, in send socket.error: (10038, 'winsock error')
I have reinstalled mysql, I try by ODBC manager and the connection is OK.
Any suggestions why the connection is not working properly?
Thanks
_______________________________________________ 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 )
[<Stefano.Blasi@esa.int>]
I am working on Win-32 platform (Windows 95). I installed MySQL ver.3.23 I have MyOBDC, ZOPE I installed ZmySQLDA in Products directory of ZOPE. I follow all the istructions. I am working whit all applications on my PC. So, after writed the "simple string connection" database@myhost:8080 UID PASSWD
database@myhost:8080 is not understood by the system. Just use the "dsn" name - that is the name you gave it when you set up the ODBC data source. Usually, you don't need to fill out the connection string at all, just selecting the ODBC data source on the "Add Z ODBC Database Connection" page will work fine. If it doesn't work, then fill out the connection string, but don't use "@myhost:8080". Cheers, Tom P
Stefano, Try: database@localhost UID PASSWD Andy Bourne University of Salford
I am working on Win-32 platform (Windows 95). I installed MySQL ver.3.23 I have MyOBDC, ZOPE I installed ZmySQLDA in Products directory of ZOPE. I follow all the istructions. I am working whit all applications on my PC. So, after writed the "simple string connection" database@myhost:8080 UID PASSWD the python of ZOPE crash whitin the followin message:
Unhandled exception in thread: Traceback (innermost last): File "C:\Program Files\WebSite\ZServer\PubCore\ZServerPublisher.py", line 97, in __init__ response._finish() File "C:\Program Files\WebSite\ZServer\HTTPResponse.py", line 281, in _finish stdout.close() File "C:\Program Files\WebSite\ZServer\HTTPResponse.py", line 338, in close Wakeup() File "C:\Program Files\WebSite\ZServer\medusa\select_trigger.py", line 153, in pull_trigger self.trigger.send ('x') File "<string>", line 1, in send socket.error: (10038, 'winsock error')
I have reinstalled mysql, I try by ODBC manager and the connection is OK.
Any suggestions why the connection is not working properly?
Thanks
_______________________________________________ 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 )
Andy Bourne Information Officer Academic Information Services University of Salford
participants (4)
-
a.p.bourne＠salford.ac.uk -
Phil Harris -
Stefano.Blasi＠esa.int -
Thomas B. Passin