JeSert
Дата: 02.04.2005 13:54:24
сделай Reference на System.Data.OracleClient.dll и почему не ей пользуешся?
Data Source -or- Server
The name or network address of the instance of Oracle to which to connect.
Integrated Security 'false' Whether the connection is to be a secure connection or not.
Recognized values are true (strongly recommended), false, yes, and no.
Password
The password for the Oracle account logging on (Not recommended. To maintain a high level of security, it is strongly recommended that you use the Integrated Security keyword instead.).
Persist Security Info
When set to false or no (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open State. Resetting the connection string resets all connection string values, including the password.
Recognized values are true, false, yes, and no.
Unicode
Specifies whether the .NET Framework Data Provider for Oracle uses UTF16 mode API calls. This keyword is ignored except when not using distributed transactions with Oracle 9i client software. If Unicode is set to true when not using Oracle 9i client software to communicate with an Oracle 9i server, unpredictable results may occur.
User ID
The Oracle login account (Not recommended. To maintain a high level of security, it is strongly recommended that you use the Integrated Security keyword instead.).
The following table lists the valid names for connection pooling values within the ConnectionString.
Connection Lifetime
When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. This is useful in clustered configurations to force load balancing between a running server and a server just brought online.
A value of zero (0) causes pooled connections to have the maximum connection timeout.
Enlist
When true or yes, the pooler automatically enlists the connection in the creation thread's current transaction context.
Recognized values are true, false, yes, and no.
Max Pool Size
The maximum number of connections allowed in the pool. Setting the Max Pool Size value of the ConnectionString can affect performance. If you plan to create and actively use more than 100 connections, you should increase Max Pool Size to a value that approximates the steady state connection usage for the application.
Min Pool Size
The minimum number of connections allowed in the pool.
Pooling
When true or yes, the OracleConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool.
Recognized values are true, false, yes, and no.
lesha_spb
Дата: 14.04.2005 16:10:06
возник такой вопрос: до этого приложение распологалось с ораклом на одной машине и проблем не было. попробовал подконнектится с удаленной машины.
возник вопрос что писать в поле Data Source, как я понимаю имя из tnames.ora.
но почему то не получается... возникает ошибка.