Thanks, Razzak, I'll prepare an initial document to send to RDCC to start
things off.
My Dream Team at UCO are I, so I don't know how much help you'll get from
me, but I'm certainly willing to try.
Paul Patrick [EMAIL PROTECTED]
University of Central Oklahoma
Edmond, OK 73034
(405) 974-2336 fax (405) 341-4964
"A. Razzak Memon"
<razzak@rbasetechno To: [EMAIL PROTECTED]
logies.com> cc:
Sent by: Subject: Re: Rbase Connection to
Oracle db via ODBC - Razzak's Reply
owner-rbase-l@sonet
mail.com
11/27/2002 11:34 AM
Please respond to
rbase-l
At 10:07 AM 11/27/2002 -0600, Paul Patrick wrote:
Paul,
Your situation reminds me of a MAJOR enhancement RBTI's
Dream Team implemented in Patch-2 (Build:1.851xRT03)
to work with MS SQL Server Database.
Richard Young and his R:BASE Team at Advance Business
Systems, Cockeysville, MD worked together with the
Dream Team to implement that enhancement of R:BASE
working with SQL Server database.
Technically, in your case, working with ORACLE, it all
has to do with the way the R:BASE engine sees the data
type(s) and then makes the best guess to interpret it.
If you would like, please contact RBTI support services
at 724.733.0053 or via e-mail [EMAIL PROTECTED]
to start a dialog for this to be implemented. As a CURRENT
user of R:BASE 2000 (ver 6.5++), you do have the benefit
to request such enhancement. The members of Dream Team
will love to implement such request.
Now, as far as The Magical R:BASE 7.0 for Windows is
concerned, I can only say that you'll have the tools
and gadgets to Design, Implement and Distribute your
R:BASE applications with Endless Possibilities!
Very Best Regards,
Razzak.
>Greetings all. This question may turn out to be a philosopy question.
>
>I'm on Rbwin 6.5++, and the latest beta patch, issued last week... Friday?
>The patch doesn't have anything to do with it, though, the behavior below
>was there before. I'm running MS Windows 2000, service pack 2.
>
>I'm trying to sconnect and sattach to an Oracle database via ODBC. My
>university uses SCT's Banner product, which uses Oracle as the database,
>but from my level, which is a lowly user and not the DBA, it's unclear as
>to how much of the structure I see is Oracle and how much is Banner's
>screening through security levels. I do have read access on the Oracle
>tables.
>
>I can sucessfully sconnect and sattach to tables. The problem is that the
>data types don't come out in Rbase as what they are in Oracle. See the
>tables below at the end of the e-mail.
>
>A 'varchar' data type (which I think means variable character) in Oracle,
>gets translated as a Note data type in Rbase.
>
>Question #1: Where do I look to solve the problem? I'm thinking it's
>in the oracle specific ODBC driver, but I'm not sure.
>
>I have two different drivers connecting to the Oracle database. One came
>with Win2K from Microsoft, and I use it to connect MS Access to the same
>database sucessfully. I've tried using this driver with Rbase, but it
>appears that Rbase (or something) passes the connection information to the
>driver in the wrong order. Or at least in a order that the driver
>doesn't understand. Anyway, when using this driver with MS Access, the
>varchar datatype is correctly interpreted as Text.
>
>I have another driver, supplied by Oracle, and which was installed for
ODBC
>access by another SCT application. This is the driver I use to make the
>connection from Rbase. And it works. But I'd rather have the varchar2
>data type interpreted as TEXT in Rbase.
>
>Question #2: Does anybody know the correct driver for Rbase to use to
>connect to Oracle tables?
>
>Question #3: Will Rbwin 7 do this any differently?
>
>Question #4: Can I use views to handle this? Can I redefine a data
>type in a view? I haven't worked enough with views in Rbase to know,
but
>I suspect it's a silly question. The oracle database is so
rigorously
>normalized, and I have so many tables to work with, I know I'm going to
>have to create views.
>
>My object is to get rid of MS Access. It works, but I'd rather have the
>control I can get from the mighty R>, and command files, instead of having
>to learn VB. Besides, I'm drooling in anticipation of Rbwin 7, just
>from the e-mails on this list.
>
>TIA
>
>Paul Patrick [EMAIL PROTECTED]
>University of Central Oklahoma
>Edmond, OK 73034
>(405) 974-2336 fax (405) 341-4964
>
>
>This is the table as defined in Oracle. Database version is 8.1.7.3.
>
>COLUMN_NAME NULLABLE DATA_TYPE DATA_LENGTH DATA_PRECISION
>DATA_SCALE
>SSRFEES_TERM_CODE N VARCHAR2 6
>SSRFEES_CRN N VARCHAR2 5
>SSRFEES_DETL_CODE N VARCHAR2 4
>SSRFEES_FEE_IND N VARCHAR2 1
>SSRFEES_FEE_IND_IND N NUMBER 1 1
>0
>SSRFEES_AMOUNT N NUMBER 8 6
>2
>SSRFEES_ACTIVITY_DATE N DATE 7
>SSRFEES_LEVL_CODE Y VARCHAR2 2
>
>After sattach in Rbase (and after assigning alias to too-long column
names)
>I get the following. Unfortunately, I hosed the driver last night and
>can't reconnect until my IT department reinstalls stuff, so the following
>is from memory. But the note part is accurate.
>
>SSRFEES_TERM_CODE Note
>SSRFEES_CRN Note
>SSRFEES_DETL_CODE Note
>SSRFEES_FEE_IND Note
>SSRFEES_FEE_IND2 Integer
>SSRFEES_AMOUNT Real
>SSRFEES_ACTIVDATE Datetime (this is correct, the DATE
field
>above is really date/time)
>SSRFEES_LEVL_CODE Note
>
>And, when browsing/editing the table, the note fields show up as the
>correct length for the data.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
