Problem connecting Lazarus with oracle 11g XE

[wgandalf]

I've tried to connect oracle with lazarus and I this error appeared:

oracleconnection1: The creation of an oracle environment failed

Lazarus: v 1.0.2
Version FPC: 2.6.0
Oracle 11g XE 11.2.0
Windows XP SP3 32B.

procedure TForm1.Button1Click(Sender: TObject);
begin
  with OracleConnection1 do
  begin
    directory := directorio.Text;
    hostname := '';
    Databasename :=  host.Text+':'+puerto.Text+'/'+sid.Text;//'localhost:1521/xe';
    Connected := true;
  end;
  if OracleConnection1.Connected then
   showmessage('Conectado.');
   sql.Active:=true;
end;     

[BigChimp]

2 remarks:
1. Are your connection parameters correct (e.g. are you sure you don't need to fill in hostname, even 127.0.0.1 or localhost?)
2. Is your Oracle driver installed and working? Can you e.g. connect with sql*plus?

[wgandalf]

1. Are your connection parameters correct (e.g. are you sure you don't need to fill in hostname, even 127.0.0.1 or localhost?)
  I don't know its my first time with lazarus and oracle. I found this code and some similar.
2. Is your Oracle driver installed and working? Can you e.g. connect with sql*plus?
 Oracle Drivers work. Yes, sqlplus work.

sorry for my English.

[wgandalf]

Probe with multiple servers I have and always returns the same error

[BigChimp]

Well, given the example in FPC's database.ini.txt template file for the sqldb test framework, I would use the Hostname property and specify 127.0.0.1, possibly followed by :<port> if that isn't 1521.

The databasename may be the SID, don't know exactly. xe is what is mentioned in the database.ini.txt as well which is presumably set up for an Oracle XE setup.

[denver]

The databasename may be the SID, don't know exactly. xe is what is mentioned in the database.ini.txt as well which is presumably set up for an Oracle XE setup.

Oracle' s databasename concept is different from MySQL, PostgreSQL..., you need to assign the access right for each user.
I use ZeosLib to connect to Oracle 11g XE with the following setting ( Localhost ) :

ZConnection1.DatabaseName := '127.0.0.1'  ;
ZConnection1.Port : 1521 ;
ZConnection1.HostName := '127.0.0.1' ;
ZConnection1.UserName := 'yourusername' ;
ZConnection1.Password := 'yourpassword' ;
ZConnection1.Protocol := 'oracle' ;

It work fine for me ....

[wgandalf]

ok, i will googlear zeoslib. Thanks

[BigChimp]

Yes, by all means Google another db library instead of following my suggestions with the library you have now. Then you'll probably copy/paste some code that won't quite work and you end up asking the same kind of questions

I'm giving up.
(Glad I didn't spend any effort in e.g. converting a demo app to Oracle as I had done before)

@denver: I don't know what you mean by your database name remark - but it's not relevant now anyway...

[denver]

Oracle use the concept of workspace instead of database, so databasename is not valid in ZConnection1.databasename.
Just put ZConnection1.DatabaseName := 'host ip address'  is ok.

The workspace concept make me crazy  when i start to work with oracle.

[BigChimp]

Workspace? No idea what you mean by that, but haven't kept track since 10g.
Instance/sid, schema & database: yes. Workspace? No.
Anway, feel free to update http://wiki.lazarus.freepascal.org/oracle with a zeos and/or sqldb section if you want to, that will certainly help.

Regarddless, I'm sure Zeos' Zconnection.databasename is different from sqldb's toracleconnection.databasename...