I have read about this problem before on forums, but I think mine is a bit special.

I am strying to get data from an oracle db, by using a WORKING ODBC connection. I have used this ODBC connection with crystal reports, so I know it is working. Now, I downloaded microsofts .net odbc (Microsoft.Data.Odbc; ) and from within my .NET application I have problems.

1)The Oracle DB contains several instances (like databases in SQL). How can I in the connection string, specify which one I want to work with??????

2)How should a CORRECT connection string look like? I want to connect by using the DSN.

3)I get the error that Oracle client software isn't installed when I run the application. That's correct I am not using oracle software on my workstation. I don't want to use it either...

Here is the code Im using... faulty
PHP Code:
using Microsoft.Data.Odbc;  

namespace oracle_odbc_lab
{
    /// <summary>
    /// Summary description for WebForm1.
    /// </summary>
    public class WebForm1 : System.Web.UI.Page
    {
        private void Page_Load(object sender, System.EventArgs e)
        {
            // Build a connection and SQL strings
            string connectionString 
                = @"Driver={Microsoft ODBC for Oracle};Server=testing.BMCEDS;UID=eda_user;PWD=eda" ;
            string SQL = "SELECT NAME FROM DATASOURCE";
            // Create connection object
            OdbcConnection conn = new OdbcConnection(connectionString);        
            // Create command object
            OdbcCommand cmd = new OdbcCommand(SQL);
            cmd.Connection = conn;    
            // Open connection
            conn.Open();
            // Call command's ExecuteReader
            OdbcDataReader reader = cmd.ExecuteReader();
            // Read the reader and display results on the console
            while (reader.Read()) 
            {
                Response.Write("Name:" + reader.GetString(0).ToString());
                Response.Write(" ,"); 
                
                //Console.WriteLine("Customer:" + reader.GetString(1).ToString() );
            }
            // close reader and connection
            reader.Close();
            conn.Close();

        } 

And we have made the mapping to the instance at the central oracle client (not my workstation). But that shouldn't matter since I am trying to use a WORKING LOCAL ODBC.

anyone who can help?

kind regards
Henrik