SLOW Queries via Native Driver

and it worked very well with Sybase, but we used ODBC and not the native drivers. Cheers, Wjatscheslaw Kravtchenko Information Technology Service United Nations Office at Vienna United Nations Office on Drugs and Crime Phone: +43-1-26060-4153 e-mail: [EMAIL PROTECTED] web: www.unvienna.org

SLOW Queries via Native Driver

? Or is my approach totally wrong and it's only a configuration thing. Please HELP!!! Every idea is very welcome. I am loosing my mind and the management is freaking me out ... Best Regards, Wjatscheslaw Kravtchenko Information Technology Service United Nations Office at Vienna United Nations Office

CFQUERY and Stored Procedures

Hey, while Implementing stored procedures to increase the performance on ColdFusion 5 I encountered following problems: 1. cfquery name=projects DATASOURCE=#application.db# {CALL SP_PROJECTS_SLAVA('#form.project#', '#form.region#')} /cfquery returns: Sybase Error Code = 102 Incorrect

Stored Procedure not found

Hi all, If I call the stored procedure from a CFScript and it returns not found - what could be misconfigured? The stored procedure can be accessed from all other tools like SQL Advantage. Cheers. SL ~| Archives:

OT: Think you are a SQL GURU? Try figuring this one out.

Hey Eric, It's not SQL it's more for PERL and Regular Expressions. I am not too familiar with regular expressions in ColdFusion but I'm sure that they are no RegEx in SQL. Another thing what could do it would be kdb from KX Systems but again you need to learn k. If you can drop me the csv

OT: Think you are a SQL GURU? Try figuring this one out.

Hey Eric, It's not SQL it's more for PERL and Regular Expressions. I am not too familiar with regular expressions in ColdFusion but I'm sure that they are no RegEx in SQL. Another thing what could do it would be kdb from KX Systems but again you need to learn k. If you can drop me the csv