i want to connect to oracle database from Centura through sql router for oracle. Problem i am facing is the parameters i have to give in sql.ini file and the oracle side (TNSNAMES.ORA). Also i need to know step by step of what i have to deal with windows registry for oracle section and Centura section.
i am not able to connect to oracle due to some parameters missing. i am using oracle sql* Plus in oracle side connectivity.
some body help me how to configure the ini files so that i can access the database through Centura dev tool in application developent time.
attached here with the sql.ini file whch is not hlping me in parameter setting. let me know any change in need to do in this parameter for oracle local machine connect and oracle server ( the one which will point out the development server )
servername=XXXXXXX(how the naming convention shd be)
dbname= database name i need to specify (how the naming convention shd be)
what is the point i need to take care of while mapping Centura to oracle database
your replies will be appreciated heartfully.. thanks in advance from a guy who is struggling to configure
Your sql.ini looks fine. Try connecting with sqltalk.exe an let us know the error that you get?
Have you tried the Connectivity Administrator?
I would also recommend that you are on at least PTF2, due to a number of issues fixed in the Oracle router.
Defect Id: 73565
Defect Description: When using ODBC syntax to call an Oracle stored procedure fails on the SqlExecute. If using Oracle's OLE DB Provider an error ORA-06550 occurs. Microsoft's Oracle OLE DB Provider, returns a error 0.
Defect Id: 76116 (SQLRouter – Oracle)
Defect Description: sqlora32.dll from PTF1 results into a GPF when there's a row of SELECT statements.
Defect Id: 76476 (SQLRouter – Oracle)
Defect Description: Can only fetch back 2000 characters from a VARCHAR2 column in Oracle.
Who is online
Users browsing this forum: [Ccbot] and 0 guests