Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC problems

Re: ODBC problems

From: Rich P <rpng123_at_aol.com>
Date: 01 Mar 2004 21:58:24 GMT
Message-ID: <4043b200$0$197$75868355@news.frii.net>

For password/ID issues with ODBC connections - if you could relink your table to the Oracle DSN there is a "save Password" checkbox on the Link dialog box. Check that for it to remember your password. Note: In order to create a DSN (or any other type of connection with an Oracle DB, the Oracl Client needs to be installed - if you can see data with your current link, then the Oracle client is installed - the Microsoft/Oracle driver does not come into this picture). The Oracle link is made to the Oracle service which you configure in the Oracle Client.

For querying an Oracle table, you need to be up on PL Sql (Oracle sql). Access uses Jet-Sql, MS Sql Server uses Transact Sql, Oracle uses PL Sql. They are all fairly similar except for the really little things. Of course, Transact Sql and PL sql support way more functionality than Jet sql because these guys support industrial sized DB's where Access is basically a front end system with tables that server as data buffers and limited RDBMS functionality (on the industrial level).

Here is a sample PL sql statemet that you can run in Access:

"SELECT COUNT(fld1) FROM oraSvc1.oraTbl1 WHERE Datefld >= TO_DATE('01-01-04', 'DD-MM-YY')" Here oraSvc1 is a namespace (name) for a Service to a specific Oracle DB and oraTbl1 is a table in the Oracle DB. I want to retrieve records from this table where a date field in the table (Datefld) has values greater than or equal to #1/1/04#. Note how PL sql delimits dates with single quotes. Additionally, you have to cast the date value using the PL Sql TO_DATE function which takes 2 arguments.

Rich

Received on Mon Mar 01 2004 - 15:58:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US