Hi, paws.
I'm working in an ASP.NET WebApp connecting a Progress 8.3B database.
I'm using an Openlink ODBC connector but I have some issues.
It looks like suddenly we lost the communication with the broker (ODBC gateway). 1) Do you know what's happenning ?
We're working with WebServices so we're sending SQL Statements and I'd like you to help me to find more info about SQL Standard Statements (I'm working with SQL Server and Progress so I'd like to find neutral SQL statements for both, for example: LIKE in SQL Server works but not in Progress (through ODBC), 2) what's the neutral statement (where can I find more info) ?
Another, 3) is there any graphical query analyzer for Progress ? Like the MS Query Analyzer ?
The last, I'm trying with some statements like CONTAINS but it's very slow, do I have to work with another statement ? Any performance clues ?
Thanks a lot.
I'm working in an ASP.NET WebApp connecting a Progress 8.3B database.
I'm using an Openlink ODBC connector but I have some issues.
It looks like suddenly we lost the communication with the broker (ODBC gateway). 1) Do you know what's happenning ?
We're working with WebServices so we're sending SQL Statements and I'd like you to help me to find more info about SQL Standard Statements (I'm working with SQL Server and Progress so I'd like to find neutral SQL statements for both, for example: LIKE in SQL Server works but not in Progress (through ODBC), 2) what's the neutral statement (where can I find more info) ?
Another, 3) is there any graphical query analyzer for Progress ? Like the MS Query Analyzer ?
The last, I'm trying with some statements like CONTAINS but it's very slow, do I have to work with another statement ? Any performance clues ?
Thanks a lot.