Re: Manipulate Oracle with Access97

I am unsure of this but it might make a difference. Amend your call to add the following option.
OracleDB.Execute s,dbExecDirect
This will skip the windowsSQLPrepare API call which may be affecting your ODBC call.
It may also be worth trying to create a simpler table with just one field to see if you can actually create any table.

HTH
Andy

Phil wrote in message ...
>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