When I start up Zserver using a batch file, or manually, I am able to make my ODBC connections, and see my ODBC datasources. However, if I start up Zserver as a NT service (zserver-srvany.zip), although Zope works fine in other apparent respects, it is now unable to see or access ODBC datasources. Using 1.11.0pr 1 ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz
At 07:11 PM 5/30/99 +1200, Graham Chiu wrote:
When I start up Zserver using a batch file, or manually, I am able to make my ODBC connections, and see my ODBC datasources.
However, if I start up Zserver as a NT service (zserver-srvany.zip), although Zope works fine in other apparent respects, it is now unable to see or access ODBC datasources.
If you want to make your DNS's available to other users, you need to create them as system DSN's. This is not a ZServer specific issue. When you run a service, it doesn't have the same sort of access to the system as a program you run manually from a batch file. Notice in Control Panels/ODBC that you can choose between "User DSN" and "System DSN". Recreate your DSN as a System DSN, and I bet that all will be well. Good luck. -Amos
In article <3.0.5.32.19990530105114.00be0110@mail.aracnet.com>, Amos Latteier <amos@aracnet.com> writes
If you want to make your DNS's available to other users, you need to create them as system DSN's. This is not a ZServer specific issue. When you run a service, it doesn't have the same sort of access to the system as a program you run manually from a batch file.
Notice in Control Panels/ODBC that you can choose between "User DSN" and "System DSN". Recreate your DSN as a System DSN, and I bet that all will be well.
I tried this out. With my ODBC connection set up as System DSN, I can then see it when Zserver runs as a service, but I am still unable to connect. I run Zserver as a batch file with the same settings, and no problems. ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz
At 04:34 31/05/99 , Graham Chiu wrote:
In article <3.0.5.32.19990530105114.00be0110@mail.aracnet.com>, Amos Latteier <amos@aracnet.com> writes
If you want to make your DNS's available to other users, you need to create them as system DSN's. This is not a ZServer specific issue. When you run a service, it doesn't have the same sort of access to the system as a program you run manually from a batch file.
Notice in Control Panels/ODBC that you can choose between "User DSN" and "System DSN". Recreate your DSN as a System DSN, and I bet that all will be well.
I tried this out. With my ODBC connection set up as System DSN, I can then see it when Zserver runs as a service, but I am still unable to connect.
I run Zserver as a batch file with the same settings, and no problems.
What database are you connecting too? Could it be that the security of the database doesn't allow the system account (the account all services normally start up as) to access the database? If it is an Access database, make sure the database isn't opened by any other process, for example. This could cause problems. -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-6254545 Fax: +31-35-6254555 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------
In article <4.2.0.56.19990531085431.00bd7f00@lisp.atmm.nl>, Martijn Pieters <mj@antraciet.nl> writes
What database are you connecting too? Could it be that the security of the database doesn't allow the system account (the account all services normally start up as) to access the database? If it is an Access database, make sure the database isn't opened by any other process, for example. This could cause problems.
Local Interbase 4.2.1.328. this is the traceback... <!-- Traceback (innermost last): File f:\zope\lib\python\ZPublisher\Publish.py, line 255, in publish_module File f:\zope\lib\python\ZPublisher\Publish.py, line 157, in publish File f:\zope\lib\python\ZPublisher\mapply.py, line 154, in mapply (Object: manage_open_connection) File f:\zope\lib\python\ZPublisher\Publish.py, line 98, in call_object (Object: manage_open_connection) File f:\zope\lib\python\Shared\DC\ZRDB\Connection.py, line 179, in manage_open_connection (Object: stock) File f:\zope\lib\python\Shared\DC\ZRDB\Connection.py, line 197, in connect (Object: stock) File f:/Zope\lib\python\Products\ZODBCDA\db.py, line 154, in __init__ BadRequest: (see above) ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz
participants (3)
-
Amos Latteier -
Graham Chiu -
Martijn Pieters