Setting up a connection to Oracle via SQLNet

building semantic layer
1

Hello everyone,

Does anybody know if it is possibloe to use the SQLRequest Function in SBL to set up a connection to Oracle via SQLNet. Research seems to suggest that SBL only permits one to do it via ODBC.

SQLRequest(connectionStr$, query$, outputStr$, prompt%, columnNames%, ref())

Any thoughts???

Samita Chitre
Senior Consultant
Braun Technology Group
251 North Illinois Street, Suite 1210
Indianapolis, IN 46204
TE:(317)-822-4507

Listserv Archives (BOB member since 2002-06-25)

2

[Andrew Erthal] The SQLRequest function only works with an ODBC datasource.

Depending on your situation, you could run a BusObj report and read in the data that way.

If you have to use SQL inside of the script and do not want to use ODBC, you can write native SQL*Net function calls.

Andrew J. Erthal
Orion Project Manager
Business Objects University
aerthal@businessobjects.com
Chicago Office (847) 391-9898
St. Louis Office (314) 209-1994
St. Louis Fax (314) 209-7926

Hello everyone,

Does anybody know if it is possibloe to use the SQLRequest Function in SBL to set up a connection to Oracle via SQLNet. Research seems to suggest that SBL only permits one to do it via ODBC.

SQLRequest(connectionStr$, query$, outputStr$, prompt%, columnNames%, ref())

Any thoughts???

Samita Chitre
Senior Consultant
Braun Technology Group
251 North Illinois Street, Suite 1210
Indianapolis, IN 46204
TE:(317)-822-4507

Listserv Archives (BOB member since 2002-06-25)