Devart Forums

I did some research and I thought that the sid was the same as the service name in tnsnames.ora. But the sid is the name of the database instance.

Thanks for your great support!

It works if I set the SID in the connection string to "ORAEMD".

Do you know why this is?

Connection String:

Data Source=dbserver;SID=ORAEMD.WORLD;User Id=EASYUSER9;Password=doorman

BTW, it works on another Oracle client.

David

I installed the new version and now there is a new error msg:

NET: Invalid SID

This is the entry in tnsnames.ora:

ORAEMD.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.171.110)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORAEMD.WORLD)
)
)

Thanks for your help,

David

Ok, thanks for the quick response!

I'm having another problem. I'm getting this error when calling OracleConnection.Open:

Network error:: An unknown, invalid, or unsupported option or level was specified in a getsockopt or setsockopt call

This is my connection string:

Data Source=dbserver;SID=ORAEMD.WORLD;User Id=ERDAUSER;Password=ERDAUSER

Thanks

David

Does dotConnect for Oracle Mobile Edition support Direct Mode? I just downloaded the trial on 1/20/09 (ver 5.0.12.1), and I don't see a Direct property on the OracleConnection class and get an error when setting this is the connection string. The documentation says it's supported.

Thanks

David