Hello,
I am using ODAC 9.7.26 on C++Builder 6.0 Professional Edition.
Some time ago I have got an answer from ODAC support on how to deal with direct connections wich need to specify if it was using SID or Service Name.
The answer I have got told me to use SN=<name> when Service Name was necessary and
SID=<name> when SID was necessary.
Now the name is composed by a name in the same format of an internet address like "folder.site.com".
I realized that TOraSession works differently with names like that. How can I deal with service names like that ?
Thank you very much.
Thank you very much.
Jayme Jeffman Filho
Direct Connection with Service Name
Re: Direct Connection with Service Name
The use of domain names like "folder.site.com" does not differ from the use of the standard naming of Service Name, for example:
We checked this behavior with the last version of ODAC 10.3.9 and did not find any issue.
Code: Select all
OraSession -> Server = "oracle18c.site.com:1521:sn=folder.site.com";
Re: Direct Connection with Service Name
Thank you very much for answering me.
Why TOraSession design connection dialog changes the Server property to "Host:1521/folder.site.com" if I use it to configure the connection ?
Why TOraSession design connection dialog changes the Server property to "Host:1521/folder.site.com" if I use it to configure the connection ?
Re: Direct Connection with Service Name
You can use the "Host:1521/folder.site.com" value to specify the Oracle server. Such value will be equivalent to that one which was provided by us. Please, specify what exactly you mean when talking about the "oracle18c.site.com:1521:sn=folder.site.com" value changing? While using what dialogue exactly does it occur? Please, provide the exact steps to reproduce this issue.
Re: Direct Connection with Service Name
Hello,
It is not an issue.
Double click TOraSession and the connection config dialog is shown. If you use it to fill in the values when you press Connect the Server property will contain a slash instead of "SN="
Thank you very much.
You can close this thread as solved.
Best regards.
It is not an issue.
Double click TOraSession and the connection config dialog is shown. If you use it to fill in the values when you press Connect the Server property will contain a slash instead of "SN="
Thank you very much.
You can close this thread as solved.
Best regards.
Re: Direct Connection with Service Name
We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning our product usage.