ora 1247

From: ilbmbo <ilbimbo_at_gmail.com>
Date: Thu, 30 Jul 2009 07:58:48 -0700 (PDT)
Message-ID: <f0a6b8ab-4f64-4e91-befe-4139029e59b1_at_18g2000yqa.googlegroups.com>

hy, i have a problem with my database Oracle 10g on a linux pc with Suse distro.

I'm writing a software in c++ with Visual Studio 2008:

private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {

    String^ connectionString = gcnew String ("Data Source=(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.55.100)(PORT=1521))(CONNECT_DATA= (SERVICE_NAME=AFTIDI)));User Id=user ;Password=psw");

        System::Data::OracleClient::OracleConnection^ conn = gcnew System::Data::OracleClient::OracleConnection(connectionString);

	try


	{

		conn->Open();
	}
	catch(OracleException^ ex1)


	{

		String^ err=ex1->ToString();
	}
	catch(InvalidOperationException^ ex2)


	{

		String^ err=ex2->ToString();
	}

    String^ queryString = gcnew String ("SELECT * INTO AFTBSKDA8");

        System::Data::OracleClient::OracleCommand^ command = gcnew System::Data::OracleClient::OracleCommand(queryString);

when the program arrive at the command conn->Open(); this is a Exception that say:

                err "System.Data.OracleClient.OracleException: ORA-12547: TNS: contatto perso

can you help me???

thanks Received on Thu Jul 30 2009 - 09:58:48 CDT