| View previous topic :: View next topic |
| Author |
Message |
Carlos Glez
Joined: 07 Oct 2008
Posts: 1
Location: Mexico
|
 Posted: Tue 07 Oct 2008 18:49 Post subject: problem with oracle driver (Connection) |
 |
|
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... |
|
| Back to top |
|
 |
Plash
Devart Team
Joined: 10 May 2006
Posts: 2844
|
| Posted: Thu 09 Oct 2008 07:58 Post subject: |
|
|
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 |
|
| Back to top |
|
|
mvodevart
Joined: 09 Jul 2010
Posts: 3
|
| Posted: Fri 09 Jul 2010 14:22 Post subject: Connection problem |
|
|
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: | | "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] |
|
| Back to top |
|
|
mvodevart
Joined: 09 Jul 2010
Posts: 3
|
| Posted: Mon 12 Jul 2010 12:55 Post subject: |
|
|
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. |
|
| Back to top |
|
|
mvodevart
Joined: 09 Jul 2010
Posts: 3
|
| Posted: Tue 13 Jul 2010 08:25 Post subject: |
|
|
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... |
|
| Back to top |
|
|
|
