[Zope] is it possible to bypass ZSQL methods and callstoredprocedures in sqlserver straight from ZPT?

Jonathan dev101 at magma.ca
Tue Nov 6 09:35:19 EST 2007


----- Original Message ----- 
From: "michael nt milne" <michael.milne at gmail.com>
To: "zope list user" <zope at zope.org>
Sent: Tuesday, November 06, 2007 9:30 AM
Subject: Re: [Zope] is it possible to bypass ZSQL methods and 
callstoredprocedures in sqlserver straight from ZPT?


> thanks. Is there an example or a tutorial at all on this anywhere?
>
>
> On 11/6/07, Jaroslav Lukesh <lukesh at seznam.cz> wrote:
>>
>> Yes
>>
>> ----- Original Message -----
>> From: michael nt milne
>> We have some dynamic ZSQL methods all working but are looking to optimise
>> our code and also access some stored procedures which are already written
>> in
>> SQL Server.
>>
>> The question is, can you go straight through to a relational database
>> using
>> the connector object and call a stored procedure straight from a ZPT? Or
>> must you use a ZSQL method to access the procedure?

You could also write a Product or External Method to access your databases 
directly, using something like:  http://pymssql.sourceforge.net/

Jonathan



More information about the Zope mailing list