How can I create an ODBC database connection with a SQL Server database? Platform: Win98 Martin
On Mon, 16 Aug 1999, Martin van Nijnatten wrote:
How can I create an ODBC database connection with a SQL Server database?
Platform: Win98
Hi!, I haven't used ODBC for SQL Server but have used it for Excel spreadsheets. The process is: * Upgrade OBDC to the latest drivers * Go to OBDC32 in your Windows Control Panel and add a connection to SQL Server. * Start Zope 2 * Ensure ODBC product is ok (check in Control Panel/Products/ZODBC) * Add an SQL Connection * Add an zODBC instance * Select your instance and turn it on * Select zODBC instance in the SQL connection list * Query away! The reason that you cannot query zODBC directly is that the SQL connection provides a standard interface to all database adaptors.
Martin
Cheers, Anthony Pfrunder
In article <Pine.OSF.4.10.9908170929540.12164-100000@student.uq.edu.au>, Anthony Pfrunder <s341625@student.uq.edu.au> writes
* Upgrade OBDC to the latest drivers * Go to OBDC32 in your Windows Control Panel and add a connection to SQL Server. * Start Zope 2
Is ODBC working with Zope 2 now? I haven't seen the announcement. ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz
On Tue, 17 Aug 1999, Graham Chiu wrote:
In article <Pine.OSF.4.10.9908170929540.12164-100000@student.uq.edu.au>, Anthony Pfrunder <s341625@student.uq.edu.au> writes
* Upgrade OBDC to the latest drivers * Go to OBDC32 in your Windows Control Panel and add a connection to SQL Server. * Start Zope 2
Is ODBC working with Zope 2 now? I haven't seen the announcement.
There is a DA status page somewhere, however, the last time I checked it on Zope (beta 2-3) it worked fine. You may have weird tracebacks but in the time honored Microsoft tradition hit reload on your browser and it will work ;). It works well enough for me and I add a session lock to it to prevent thread problems (its not level 3 complient yet). Cheers, Anthony Pfrunder
In article <Pine.OSF.4.10.9908171150510.18622-100000@student.uq.edu.au>, Anthony Pfrunder <s341625@student.uq.edu.au> writes
here is a DA status page somewhere, however, the last time I checked it on Zope (beta 2-3) it worked fine. You may have weird tracebacks but in the time honored Microsoft tradition hit reload on your browser and it will work ;).
The problems I got were that all changes were rolled back or not committed after the end of the Zserver sesssion.
It works well enough for me and I add a session lock to it to prevent thread problems (its not level 3 complient yet).
How do you do this? ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz
On Tue, 17 Aug 1999, Graham Chiu wrote:
It works well enough for me and I add a session lock to it to prevent thread problems (its not level 3 complient yet).
Reduce the thread pool to one, or, cross-your-fingers and hope that no-one uses it at exactly the same time ;) Seriously, its not something that I work on alot and no-one has complained so I let well enough be ;) Cheers, Anthony Pfrunder
participants (3)
-
Anthony Pfrunder -
Graham Chiu -
Martin van Nijnatten