Which version of SQL server are you using (6.5, 7.0 or 2000, ...)? CRN has problems with versions previous to SQL Server 2000 but works fine with 2000.
Sounds to me if possibly the necessary JAR files for the Oracle client access are missing. SQL*Plus is working well, but access from CRN fails, this indicates a problem with the interaction between CRN's connector and the Oracle client.
You'll find this stuff in the Oracle directory...
Cont'd:
To add parameters, simply add the parameter as URL parameter at the end of the example URL, e.g. "&p_yourparameter=yourvalue"
For multiple parameters simply add several URL parameter sequences.
Full URL...
Here's one without parameters for now B-)
Do not forget to URL encode characters after the method=execute parameter (to encode them to hexadecimal representation e.g. %40 = '@')...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.