Connecting XBAP Browser App to Oracle

[sadowsky]

Hi,

I have a TD XBAP application hosted on IIS (Windows 7 32).
The database is oracle 11g on the same machine, sql.ini is configured to connect using native router (sqlora32).
I can start the XBAP with IE on this machine and connect to the DB.
When I try to connect from a remote machine (no Gupta or Oracle installation at all) the app starts, but the attempt to connect to the DB brings the following error:

Could not locate sql.ini file. Sql.ini must be in the executable's directory or in a directory on the system path.

sql.ini (on the server) is in a directory on the system path (C:\ProgramData\Unify\Team Developer 6.1). I am not using database proxy server since the documentation says it's optional, or am I getting that wrong?
Am I missing something, what could be the problem?

Thanks in advance
Volker

[sadowsky]

Please, Gupta, do you have any hint for us, this is really urgent.
At least we need to know, if it's correct, that we don't need database proxy server and no connectivity on the client machine.

Thanks
Volker

[Kumuthini Ragavan]

Hi Volker
Generally hosted applications run in a partial trust sandbox environment and are not given full access to the computer's resources like opening a new network connection or saving a file to the computer disk. The hosted environment is intended to protect the computer from malicious applications; If the sql.ini is in the folder C:\ProgramData\Unify\Team Developer 6.1, it will not be accessible from a remote machine. You can either place the sql.ini in a folder available to the clients (eg. the folder you have setup in the IIS) or you can run in full trust mode by the client changing the permission.

my 2 cents.
Hope this helps.

[sadowsky]

Thanks a lot for your reply, I put the sql.ini into the webapp-folder but nothing changed. Checked the settings of iis, it's already in full trust mode.
Now I gave it a try and put a sql.ini (nothing else) on the client machine and the errormessage changes (sorry, german system):

Die DLL "OraOps11w.dll":
Das angegebene Modul wurde nicht gefunden.
(Ausnahme von HRESULT: 0x8007007E) kann nicht geladen werden.

Looks like it really searches for connectivity on the client machine. This can't be the solution, I made a webapp beacause I don't want to install connectivity on every possible client but just on the server where the application is hosted.

So please give me a hint, what are the requirements on the serverside, could it be that we do need the database proxy if we don't want to install connectivity on the clients?

Volker

[sadowsky]

Ok, found out now, that this can only be achieved with DBPipe.
I was able to connect a client to my development machine (with full TD installation).
Now I set up a server with only TD Deployment and installed the webapp there. When I try to connect with a client, it gives me the following error:

Remote Exception: Open:
Die Datei oder Assembly "Unify.TD.Runtime.Wcf.Provider, Version=6.1.1.28987, Culture=neutral, PublicKeyToken=8226b62dbd39fc29" oder eine Abhängigkeit davon wurde nicht gefunden. Das System kann die angegebene Datei nicht finden.

There's a file named Unify.TD.Runtime.Wcf.Provider.dll.deploy in my webapp-folder, but that doesn't seem to be enough.

Searched for it in Process Explorer on my dev-machine while the client was connected. This showed that it's also in the GAC, on the new server it's not.
Could that be the problem, and how can I solve that?

Volker

[remi1@hotmail.com]

Hello Volker

My name is Remigio and i glad to help you if this is not too late???

Please let me know.

Remigio

[ozmenbetul]

Hi Volker,
Have you solved this problem?
I'm about to start a web application, and I'm now reading the whole forums to see who develop with 6.1 .Net and write web services.
If you solved it, would you mind to tell about the solution?

Thanks,
Betul