Manipulate Oracle with Access97

From: Phil <phg3113_at_hotmail.com>
Date: 2000/04/12
Message-ID: <CVWI4.6$4v2.575@nreader2.kpnqwest.net>#1/1

Hi everybody,

I'm looking for some explanations and some examples (code) to create, drop, fill ... tables in an Oracle Database through an Access97 application .

All I can do for the moment is to list the tables

...

    Dim wrkODBC As Workspace
    Dim OracleDB As DATABASE
    Dim Tb As TableDef
    Dim s As String

    Set OracleDB = dbengine(0).OpenDatabase _

        ("", , False, "ODBC;UID=userX;PWD=a_pass;DSN=DWH Production")

    For Each Tb In OracleDB.TableDefs

        Debug.Print Tb.Name
    Next

    s = "Create Table rszdwh.AAAAAAA (CodeIntern Number(7), Temps Varchar2(8), LAN11 Number (4,0)"

    s = s & " , MAN11 Number (4,0)"
    s = s & " , SECRSOC Number (4,0)"
    s = s & " , VAL1 Number(10)"
    s = s & " ) storage (initial 6M next 2048k pctincrease 0) pctfree 1 ;"

    OracleDB.Execute s ' DOESN'T WORK!!!     OracleDB.Close
    wrkODBC.Close
...

but I can't create a new table ('ODBC Call Failed')

I'd like some help please (doc file or internet link...)

Thanks in advance

Phil Received on Wed Apr 12 2000 - 00:00:00 CDT