OracleConnection + instantclient = ORA-12541

[GolfCat]

I have checked and when I supply the correct hostname I get ORA-12514, when I set localhost as hostname I get ORA-12541. This is for OracleConnection + instantclient. When using zeosconnection and instantclient I can use the correct hostname or localhost as hostname and connect OK. Strange that you guys get different results.

[BigChimp]

If you get 12514 that matches my incorrect sid case. Not too much of an Oracle guru but perhaps tnsnames.ora is interfering with a service definition here?

Perhaps post the info/properties you use for zeos connection as well as Oracleconnection could be useful?

[GolfCat]

Code: [Select]

procedure TForm1.btnOraClick(Sender: TObject);
begin
  OracleConnection1.DatabaseName:='UTV02';
  OracleConnection1.HostName:='utv-oradb234.utv.mycompany.se';
  OracleConnection1.UserName:='sbo';
  OracleConnection1.Password:='sbo';
  OracleConnection1.Connected:=True;
  if OracleConnection1.Connected then
  begin
    StatusBar1.SimpleText := 'Connected';
  end
  else begin
    StatusBar1.SimpleText := 'No Connection';
  end;
end;
This fails with ORA-12514

Code: [Select]

procedure TForm1.btnZeosClick(Sender: TObject);
begin
  ZConnection1.Protocol := 'oracle';
  ZConnection1.Database := 'UTV02';
  ZConnection1.HostName := 'utv-oradb234.utv.mycompany.se'
  ZConnection1.User := 'sbo';
  ZConnection1.Password := 'sbo';
  ZConnection1.Connected := True;
  if ZConnection1.Connected then
  begin
    StatusBar1.SimpleText := 'Connected';
  end
  else begin
    StatusBar1.SimpleText := 'No Connection';
  end;
end;         
Here I get 'Connected'
All other properties are default.
In tnsnames.ora it looks like this:

Code: [Select]

UTV02=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=utv-oradb234.utv.mycompany.se)
      (PORT=1523)
    )
    (CONNECT_DATA=
      (SERVICE_NAME=utv02.utv.mycompany.se)
    )
  )


[BigChimp]

I vaguely remember having once used tnsnames.ora with FPC.... However, too many scare memories for somebody who just wanted to test various dbs...

Code: [Select]

OracleConnection1.DatabaseName:='UTV02';
Perhaps try with the service name instead of the tnsnames entry:

Code: [Select]

OracleConnection1.DatabaseName:='utv02.utv.mycompany.se'
also then you'll need to specify the port as it's not default 1521

[BigChimp]

To specify port 1523 on host hostname you'd probably do something like

Code: [Select]

OracleConnection1.hostname:='hostname:1523';
but that's Oracle lower level stuff (OCI) which I know nothing about...

[GolfCat]

Tested all of this today and got ORA-12154
Searched the forum and found the solution:
I completely removed the hostname and IT FUNCTIONED.

[BigChimp]

Great news!

I modified
http://wiki.lazarus.freepascal.org/oracle#OOP_access_to_Oracle
hope it's correct - corrections welcome.