1
Answer

Oracle problem please help me...

mark jacinto

mark jacinto

17y
2k
1
using Oracle.DataAccess.Client;

string DefCon = "Data Source=serverbem;User ID=mytest;Password=bem;ProviderName=ORACLE";
OracleConnection myCon = new OracleConnection();
myCon.ConnectionString = DefCon;
myCon.Open();  


its so hard to remote connect using oracle. PLEASE HELP ME. i always bump with this error

Server Error in '/PersonQuery' Application.

'providername' is an invalid connection string attribute.

all i want is to connect remote connect to oracle. i'm using Oracle10g express edition. PLEASE HELP ME WITH MY PROBLEM huhuhu.

Answers (1)
0
Glenn Patton

Glenn Patton

NA 333 60.7k 12y
Hi All,

I have managed to get the correct version of the driver I need here is the code to do it!
 private void button5_Click(object sender, EventArgs e)
        {
     
            List<SignedDriver> drivers = GetDriverInfo();
          
            foreach (SignedDriver driver in drivers)
                listBox1.Items.Add(driver.DeviceName+","+driver.DriverDate+","+driver.DriverVersion);
        
        }

        private void button6_Click(object sender, EventArgs e)
        {
            int index = -1;
          
            index = listBox1.FindString("USB Serial Converter,20120410000000.******+***");
            if (index == -1)
            {
                MessageBox.Show(" Driver Not Found ","",MessageBoxButtons.OK,MessageBoxIcon.Error);
            }
            else
            {
                MessageBox.Show("index = " + index.ToString() + " , " + listBox1.Items[index].ToString(),"",MessageBoxButtons.OK,MessageBoxIcon.Information);
                textBox2.Text = listBox1.Items[index].ToString();
            }




        }

        private void button7_Click(object sender, EventArgs e)
        {
            const char Comma = ',';
            string Target;
            string Version_Number = "";
            string output = "";
            int count = 0;

           
            Target = textBox2.Text;

          
            foreach (string subString in Target.Split(Comma))
            {
                output += subString + ";";
                count++;
                if(count == 3)
                {
                    Version_Number = subString;
                    break;
                }

           }

            MessageBox.Show("Version of driver is "+Version_Number,"",MessageBoxButtons.OK,MessageBoxIcon.Information);
        }

       

    }
 That took a lot of doing to find out the how and why, the Service Controller method will not allow the info I needed (I hope!)
Glenn