VO 28 SP4 and Oracle

[Martin]

OK I need to be able to read an Oracle file, credit limit data from an
accounting system.

How do I go about it please?

Will it be a dataserver?

Sorry about this but I have only used different RDDs so far and nothing
else.

I do know some SQL so that syntax is not too scarey.

Thanks

Martin

[Karl Faller]

Martin,
Google didn't work ? <s,cr>

Years ago there was a lib by, i think, Thomas Olzewicki, for
interaction with oracle. No idea if it is still available...

Karl

[Johan Nel]

Martin,

You need to have at least the Oracle Client installed on the client machine, otherwise nothing will work. The VO Sql classes (ODBC) or VOADO should both do the trick, as long as the Oracle Client is locally installed.

Way I got around this was to use a webservice in .NET that returns my data via web methods as DataReader/DataTable/DataSet etc... At least you then only need to have the Oracle Client installed on 1 machine.

HTH,

Johan Nel
Vulcan VIP
Durban, South Africa.

[D.J.W. van Kooten]

On Tue, 21 May 2013 03:49:27 -0700 (PDT), Johan Nel
<joha...@xsinet.co.za> wrote:

Hello Martin,

>
>The VO Sql classes (ODBC)

These actually work quite well. First create in Windows an ODBC
connection to the Oracle database, say you call it MyOracle.

Then use this kind of code:

LOCAL oStatement AS SQLStatement

oConn:=SQLConnection{"MyOrcale","","password"}
IF !oConn:Connected
ErrorBox{,Connection failed")}:Show()
RETURN FALSE
ELSE
SELF:oDCFXStatus:Caption:="Connected"
ENDIF
cSQL:="USE myDatabase"
oStatement:=SQLStatement{cSQL,oConn}
IF !oStatement:Execute("")
ErrorBox{,Vt(,"Not executed: ")+cSQL}:Show()
RETURN FALSE
ELSE
SELF:oDCFXStatus:Caption:="Connected with MyDatabase"
ENDIF

You can now access/assign values to the database using SQL statments
and the Execute method of the SQL class.

Dick

[Martin]

Thanks this si the sort of thing I needed

Martin