Page 1 of 1
problem with oracle driver (Connection)
Posted: Tue 07 Oct 2008 18:49
by Carlos Glez
I download the trial version of oracle driver (Dbexpress) but I can't make the connection with my database, y write in the connection settings the user, password an database (192.1.0.106\database\WRXJDATA.DBF) but send me an error "TNS could not resolve the conect identifier specified "
could you tell me what is te problem?
Thanks, your friend Carlos...
Posted: Thu 09 Oct 2008 07:58
by Plash
You should assign the name of TNS alias (from tnsnames.ora file) to the Database parameter.
If you are using Oracle Direct driver, you should assign a value to the Database parameter in the format: Host:Port:SID
Connection problem
Posted: Fri 09 Jul 2010 14:22
by mvodevart
Hi,
I am currently trying the dbExpress driver.
First of all, I've been trying to open the connection using the string builder, but port does not look to be a member of [OracleConnectionStringBuilder] as it is described in the doc.
Then after, I tried connecting using the following connection string:
Code: Select all
"Data Source=VIRTUAL_WIN2K3; Port=1521; User Id=system; Password=password; SID=ORA1; Connection Timeout=5; Direct=True"
but I always get the error: Cannot obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server.
As I don't want the Oracle client to be installed on the machine, I would like the Direct mode, which is specified I think; however, does not look to work...
Where am I wrong?
Thanks in advance[/code]
Posted: Mon 12 Jul 2010 12:55
by mvodevart
Maybe my question is a bit silly, but I did not succeed so far to connect the Oracle server.
So it would be nice to tell me how to solve the issue so I could continue my tests and check if I could suggest my Company to buy the driver...
Thanks in advance for your support.
Posted: Tue 13 Jul 2010 08:25
by mvodevart
For those experiencing the same problem in the future: dbExpress for Oracle does not look supporting Direct Access.
I have downloaded the trial version, which is the professional one, and suddenly there were no problem any more...