tag:blogger.com,1999:blog-20788401.post8421348587562747472..comments2024-01-05T06:28:19.101+01:00Comments on daust_de :: Oracle XE / APEX: XE: ODBC connection to a remote XE serverAnonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-20788401.post-57744634628444054432009-10-31T11:23:00.602+01:002009-10-31T11:23:00.602+01:00Hi anonymous,
I am not sure what the question is...Hi anonymous, <br /><br />I am not sure what the question is. In this post I already show to include the traditional tnsnames.ora file and reference it in an XE Client installation. <br /><br />Search for "Update: 18.01.2007<br />Using tnsnames.ora with XE client" in this post. <br /><br />Or please give more details what you are trying to accomplish. <br /><br />Regards, <br />~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-42061655314170607822009-10-31T08:12:38.830+01:002009-10-31T08:12:38.830+01:00Hi Dietmar
Can you guide me, how can i setting th...Hi Dietmar<br /><br />Can you guide me, how can i setting the tnsname.ora file in XEclient.?<br /><br />thank you for your helpAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-50048256567364089822009-05-05T21:26:00.000+02:002009-05-05T21:26:00.000+02:00Many thanx, this worked out of the box.
This excel...Many thanx, this worked out of the box.<br />This excellent guide should be part of the Oracle XE ODBC client help!<br /><br />TonAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-71112422223145152232008-07-27T14:23:00.000+02:002008-07-27T14:23:00.000+02:00Hi emiola, most probably you connected to XE with ...Hi emiola, <BR/><BR/>most probably you connected to XE with a different user than the user who owned your table. <BR/><BR/>What schema (user) is the table in XE, is it the default schema HR?<BR/><BR/>What is the name of the table and the name of the user you used to create the table? <BR/><BR/>What tools did you use to create the table? Was it via the web interface (http://localhost:8080/apex) or via the command line? <BR/>Which user did you connect to?<BR/><BR/>Regards, <BR/>~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-62269092785619492592008-07-27T14:04:00.000+02:002008-07-27T14:04:00.000+02:00Hi,I found the post indeed very useful. However, I...Hi,<BR/>I found the post indeed very useful. However, I my table did not appear among the tables that appeared upon connection to my oracleXE database. What do you think could be responsible for this?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-70441892421690160742007-08-08T00:11:00.000+02:002007-08-08T00:11:00.000+02:00Hi Marco, I am not an MS Access expert. But I am s...Hi Marco, <BR/><BR/>I am not an MS Access expert. But I am seeing the same phenomenon. <BR/><BR/>First I see a statement: <BR/>select department_id from hr.departments; <BR/><BR/>Then I see multiple statements: <BR/><BR/>SELECT "DEPARTMENT_ID", "DEPARTMENT_NAME", "MANAGER_ID", "LOCATION_ID"<BR/> FROM "HR"."DEPARTMENTS"<BR/> WHERE "DEPARTMENT_ID" = :1<BR/> OR "DEPARTMENT_ID" = :2<BR/> OR "DEPARTMENT_ID" = :3<BR/> OR "DEPARTMENT_ID" = :4<BR/> OR "DEPARTMENT_ID" = :5<BR/> OR "DEPARTMENT_ID" = :6<BR/> OR "DEPARTMENT_ID" = :7<BR/> OR "DEPARTMENT_ID" = :8<BR/> OR "DEPARTMENT_ID" = :9<BR/> OR "DEPARTMENT_ID" = :10<BR/><BR/>It looks like MS Access first gets all the primary key ids for the table. Then it queries the table by the primary key to display the required details (in chunks of 10 to display the visible data). <BR/><BR/>Once I scroll down in the dataset the statement is executed again. <BR/><BR/>Looks reasonable to me. <BR/><BR/>Hope that helps,<BR/>~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-74909138592602139642007-08-03T00:41:00.000+02:002007-08-03T00:41:00.000+02:00Hi, I also have to migrate my access application t...Hi, <BR/>I also have to migrate my access application to working with Oracle XE (instead of .mdb)<BR/><BR/>I migrate all the tables to XE and <BR/>linked them within the .mdb "program" file <BR/><BR/>(for "program" I mean where the forms, reports and queries are saved).<BR/><BR/>Then if I try the program (with the linked oracle tables) I have a lot of problems......<BR/><BR/>If I check the DB I can see a lot of SQL executions that "shouldn't" not exists (in my opinion).<BR/><BR/>For example if I only want all the records of a linked table, so using this sql:<BR/><BR/>"select field1,field2 from xxx"<BR/><BR/>I the oracle db I see:<BR/><BR/>1 (correct) execution of SQL ("select fiel1,field2,.. from xxx")<BR/><BR/>5 executions of:<BR/>select field1, field2 .. from xxx<BR/>where PK_xxx = :v001 <BR/> OR PK_xxx = :v002<BR/> OR PK_xxx = :v003 <BR/> OR PK_xxx = :v004 <BR/> OR PK_xxx = :v005<BR/><BR/>where for "PK_xxx" I mean the primary key of the table named xxx<BR/><BR/><BR/>Why? Is that correct?<BR/><BR/>Hope you understand what I explain <BR/><BR/>thanx <BR/>bye bye<BR/>MArcoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-426260328336199852007-07-30T08:27:00.000+02:002007-07-30T08:27:00.000+02:00Good design!Good design!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-70907397393176004282007-06-01T23:19:00.000+02:002007-06-01T23:19:00.000+02:00Hi Kim, yes. I am absolute fan of the heterogenous...Hi Kim, <BR/><BR/>yes. I am absolute fan of the heterogenous services. You can even create a database link to an MS Excel Sheet. Very cool. <BR/><BR/>But nevertheless, sometimes you need both directions. For example, right I am working on migrating an MS Access application to Apex. First we fixed the table names with a macro in Access (table and column names max. 30 characters, with no special symbols and spaces). <BR/><BR/>Then we used the database link to Access to migrate the stuff to Oracle. Then we need the link from Access to Oracle in order to keep the MS access application running. Now we can slowly move parts of the application to Apex. <BR/><BR/>Regards, <BR/>~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-27877680862615425112007-05-31T17:49:00.000+02:002007-05-31T17:49:00.000+02:00Even though we not all live in a "pure" world, I w...Even though we not all live in a "pure" world, I would personally prefer the use of Heterogeneous services (which is a part of XE). <BR/><BR/>Simplified, you can create a database link to an odbc connection, and thus <BR/><BR/>select * from my_table@my_odbc_source;<BR/><BR/>Just my 25 cents :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-16095838680836328872007-02-25T22:39:00.000+01:002007-02-25T22:39:00.000+01:00Unfortunately, not all of us live in a *pure* Orac...Unfortunately, not all of us live in a *pure* Oracle world. <BR/><BR/>Many of us have to be able to interface with other technologies. This is one possible way to do it. But there are others, too. It always depends on your use case.<BR/><BR/>Regards, <BR/>~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-66106163213813419752007-02-25T22:32:00.000+01:002007-02-25T22:32:00.000+01:00use plsql developer insteaduse plsql developer insteadAnonymousnoreply@blogger.com