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



"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: Asp.net / iis / oracle problem - never mind , i think i found
    ... Installed Oracle Client software on Server ... My DBA had to create synonyms for the account used to access the database to ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Oracle Client and ADO.NET
    ... I was reading thru some documents and it seems that an oracle client ... installation, Rapid App Dev Installation, etc... ... Of course I can use OLEDB/ODBC providers instead if this doesn't ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Trying to Connect SSIS to Oracle on x64
    ... I'm trying to get SSIS to connect to Oracle on 64-bit, ... The Oracle client can connect to the server and the connection tests ok. ... Reinstalled the full Oracle client x64. ... It's as if the Microsoft drivers don't know Oracle is installed, ...
    (microsoft.public.sqlserver.dts)
  • Re: Trying to Connect SSIS to Oracle on x64
    ... Joseph got his package to run. ... I'm trying to get SSIS to connect to Oracle on 64-bit, ... The Oracle client can connect to the server and the connection tests ... String on Microsoft's ODBC drivers. ...
    (microsoft.public.sqlserver.dts)
  • Big problems connecting to Oracle Express Edition via VS 2008
    ... I have posted out on the Oracle community forum for ODP .Net but am getting ... I have a Linux server running Oracle ... This is my connection info that I use for the Oracle client for XE -- ...
    (microsoft.public.data.oledb)
Loading