Devart Forums

Hi
How do I connect to oracle using TNSnames ?
Alternatively, how do I set the option SERVER=DEDICATED.
In our specific application it is crucial that this is specified because the default would be SHARED or SHAREDSERVER (not sure what it is called).

TnsName =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = somehost)(PORT = 1521))
)
(SERVER = DEDICATED
)
(CONNECT_DATA =
(SERVICE_NAME = somedatabase)
)
)

Regards René/SSV

When we try to use tnsnames we use these params:
SqlConnFerieKasse.Params.Add('DriverName=DevartOracle');
SqlConnFerieKasse.Params.Add('BlobSize=-1');
SqlConnFerieKasse.Params.Add('Server=SOMETNSNAME');
SqlConnFerieKasse.Params.Add('Oracle TransIsolation=ReadCommited');
SqlConnFerieKasse.Params.Add('FetchAll=True');
SqlConnFerieKasse.Params.Add('User_Name= SomeUser');
SqlConnFerieKasse.Params.Add('Password=SomePassword');
SqlConnFerieKasse.Params.Add('UseQuoteChar=True');

Then we get: Oracle home is not found.
What are we missing ?

René/SSV

When using dbExprees Driver for Oracle in OCI mode use the Database parameter:

SQLConnection.Params.Values['DataBase'] := TnsName ;

where TnsName is an alias name in the TNSNAMES.ORA file. Before this, make sure that the Oracle client is installed and configured correctly by connecting to Oracle DB with this alias. Also do not forget that Oracle client bitness and the bitness of dbExpess Driver must match.