RE: Big problems connecting to Oracle Express Edition via VS 2008

Hello John

First sorry for previous empty posting - my finger-trouble.

This could be a permissions issue with your Oracle client software. Are you
getting any error messages of the kind "...requires Oracle client software
version 8.1.7 or later..." If you are then check that your Windows
permissions for your Oracle client home directory includes the group
'Authenticated Users' or another group including the login used for your .NET
application. Roy Tore Gurskevik's BLOG on
http://www.dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/01/19/45958.aspx
refers to Oracle client 9i but I followed his method for Oracle client 10G
and can now connect from Sharepoint Server 2007 via .NET to Oracle XE
database on the same server and an Oracle 10G enterprise database on a remote
server. I also found I needed to enable MS Single-signon. Tested only on
Oracle servers running on Windows so far but will check out for Linux ones.

I also had to specify a local alias for the XE service in the client
tnsname.ora config file in <oracle client home>\network\admin and then refer
to that while configuring the connection from Sharepoint Server. I found that
the complete connection string such as yoyu list, didn't work. Check with
tnsping utility that you can actually contact the Oracle database using the
alias you set up. I

Note if you're running 64-bit Windows you also need the 64-bit Oracle client
or else you get library mismatches.

Hope this may give some clues.

Tom



"John A" wrote:

Hi all,

I have posted out on the Oracle community forum for ODP .Net but am getting
no love there.

Here is what I am trying to do. I have a Linux server running Oracle
Express edition. I have set up a database with schema on it and created all
the tables that need to be created. I want to connect up to it from my
Windows Ultimate Vista 64 via Visual Studio 2008.

This is what I am able to do and have attempted to do. I have been able to
connect to it directly using the SQL*Plus client that is installed with
Oracle Client 10g Express Edition. This client is running on my Vista dev
machine and does indeed connect to my Linux server that has Oracle XE on it.
This is my connection info that I use for the Oracle client for XE --
SQL> CONNECT system/MyPassword@xxxxxxxxxxxxxxxxx/XE
Connected.

I have attempted to connect using Oracle 11g, 10g and 10gx64 supplied ODP
.Net providers but have not been able to.

If anyone has any experience doing this sort of thing please help me.

BTW, if anyone wants to view my posts to the Oracle community I have posted
on their OPD .Net forum as user652499.

--
Thank you,
John
.

Relevant Pages

  • Re: Oracle Client for 32 bit and 64 bit coexist
    ... programs on x64 Windows require Oracle client for 64 bit installed. ... Oracle client on the same server so that different programs could talk ... The application should not run on the same server as the database. ... On an app where I tested this, ...
    (comp.databases.oracle.misc)
  • RE: DBI.pm DBD::Oracle::db
    ... I turned the trace level to 9, and it provided me a lot more detailed ... but the server B does not have oracle client ... Mapped to server B's drive with the executable there, ...
    (perl.dbi.users)
  • Re: Oracle Client for 32 bit and 64 bit coexist
    ... On our Windows 2003 64 bit servers, currently we have Oracle Client 32 ... Is that possible to install both 32 bit Oracle client and 64 bit ... Oracle client on the same server so that different programs could talk ...
    (comp.databases.oracle.misc)
  • [HPADM] vmunix: file: table is full & oracle client ORA-12500: TNS:listener failed to start
    ... we ran into this error messages in Oracle client end ... ORA-12500: TNS:listener failed to start a dedicated server process ... that same Oracle client message resurfaced and in the HP-UX Oracle Server, ...
    (HP-UX-Admin)
  • Re: connections work in dev, not in test - oracle 7 db
    ... Yes, this oracle 7 is going away, but we need the app to run historical info only from this db. ... > You'll still need to install the Oracle Client software onto the Test ... > Oracle Client's connection to the Oracle Server. ...
    (microsoft.public.dotnet.framework.adonet)
Loading