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
Connect using TNSnames OR How to specify SERVER=DEDICATED
Re: Connect using TNSnames OR How to specify SERVER=DEDICATED
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
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
Re: Connect using TNSnames OR How to specify SERVER=DEDICATED
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.
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.