whichever you develop on - you run pretty bad on and everyone else is hack. Sorry - i don't do "database independence"Īll you get from that is an application that runs pretty bad on one database and horrible on all of the rest. Is there a document that I can refer to for the "minimal intersect of SQL syntax supported by all major RDBMS vendors"? Will Oracle "CONNECT BY" become ANSI standards sometime?ģ. Does this solution look workable to you?Ģ. compose the whole SQL statement such as 'SELECT * FROM orgs WHERE orgid IN (' + + ')'Īs compared to the original query in Oracle, which may look likeġ. get the list of child IDs for the given root ID.Ģ.
#APEX SQL SERVER CODE#
So at least now we can use the same code (writen in C#) for both databases, which works like this:ġ. Obviously this has some limitation such as the list cannot be too long. I came up with a function which returns the list of child IDs for given root ID, which works in both databases.įor example, get_children(20) may returns a string of '21,23,30,220,22'. One trouble we had in SQL Server is that it doesn't support Oracle hierarchy query like "CONNECT BY". Unfortunately our application has to support Oracle and SQL Server at the same time. My email id is A help in this would be highly appreciated.
ORA-02063: preceding 2 lines from AVANTIACCESS Unable to retrieve text of NETWORK/NCR message 12564 ORA-28545: error diagnosed by Net8 when connecting to an agent (ADDRESS=(PROTOCOL=tcp)(HOST=STRATSOURCING)(PORT=1521)) My initavantiaccess.ora file in HSadmin folder and Tnsnames.ora in network/admin folder are in place. I have a access database and another UNIDATA database for which I 'm trying to access using Heterogenious services. Its a shame oracle does'nt have a simple method to get this done ( I was heckled by MS Access users with the ease with which they can set it up :( ) I have been trying to get this working on my oracle 9i rel 2.0 datawarehouse database. I am still trying ot find where i went wrong. I am running this test from the Oracle Server (8.1.7) and has the SQL server 2000 Client installed on it. The init file for HS has been modified and named appropriately I have run the HS script C:\Oracle\Ora81\RDBMS\ADMIN\caths.sql
#APEX SQL SERVER DRIVER#
Microsoft SQL Server ODBC Driver (Version ) Listener Log File C:\Oracle\Ora81\network\log\listener.logģ.SID=name in the service name definition (in the TNSNAMES.ORA file) must match the value in the LISTENER.ORA file for the responding listener. Listener Parameter File C:\Oracle\Ora81\network\admin\listener.ora Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc ROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=258_stock)(PORT=2481))(P Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=258_stock)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc Log messages written to C:\Oracle\Ora81\network\log\listener.log System parameter file is C:\Oracle\Ora81\network\admin\listener.ora TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production protocol-specific information in the service name definition is the same as in the The USING clause in the DB link and TNSNAMES is the same as in the TNSNAMES file
#APEX SQL SERVER MANUAL#
Looking the error up in the error manual i have checked the followingġ. ORA-28509: unable to establish a connection to non-Oracle system I went through the URL and related chapters/pages butstill getting the select authid from