Invalid driver designator

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Dave Eland

Invalid driver designator

Post by Dave Eland » Sun 14 Nov 2004 20:46

I am using ODAC5.0 in Delphi 6 to connect to Oracle 9i.

When connecting to a remote computer system (running Linux) everything is working fine.

I just installed Oracle 9i on my machine at home (running Windows XP Professional). I have a database set up and running just fine when accessed thorugh the "sqlplus" command line interface provided by Oracle. However, when attempting to connect to that database on my local machine, the following error is reported:

ORA-06401: NETCMN: Invalid driver designator.

How can this problem be fixed?

Dave Eland
[email protected]

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 15 Nov 2004 15:45

Possibly, you specify a wrong value to TOraSession.Server parameter. If
TOraSession.Options.Net is set to False, Server property assumes TNS alias name for requested database (See all possible aliases in tnsnames.ora). If TOraSession.Options.Net is True, Server property accepts string holding three fields and separated by a colon as "Host:Port:SID".

Post Reply