Oracle9i driver

If the size of the result set data exceeds available memory, the driver pages the result set data to disk. Because result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk. If set to x, where x is a positive integer, the driver caches all insensitive result set data in memory, using this value to set the size in KB of the memory buffer for caching insensitive result set data.

If the size of the result set data exceeds the buffer size, the driver pages the result set data to disk. Because the result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk. Specifying a buffer size that is a power of 2 results in more efficient memory use. The maximum time in seconds that attempts to create a database connection will wait. A value of 0 specifies that the timeout is the default system timeout if there is one; otherwise it specifies that there is no timeout.

A case-insensitive password used to connect to your Oracle database. A password is required only if security is enabled on your database. If so, contact your system administrator to obtain your password. The default is , which is the Oracle default port number when installing the Oracle database software. See Performance Considerations for information about specifying a port number for the Oracle listener using a tnsnames.

Specifies either the IP address or the server name if your network supports named servers of the Oracle server. For example, See Performance Considerations for information about specifying a server name using a tnsnames.

Specifies whether the connection is established using a shared or dedicated server process UNIX or thread Windows. If set to Shared, the server process to be used is retrieved from a pool. The socket connection between the client and server is made to a dispatcher process on the server.

This setting allows there to be fewer processes than the number of connections, reducing the need for server resources. Use this value when a server must handle many users with fewer server resources.

If set to Dedicated, a server process is created to service only that connection. The socket connection is made directly between the application and the dedicated server process or thread. When connecting to UNIX servers, a dedicated server process can provide significant performance improvement, but uses more resources on the server. When connecting to Windows servers, the server resource penalty is insignificant. Use this value if you have a batch environment with low numbers of users.

If unspecified, the driver uses the server type set on the server. See Performance Considerations for information about specifying the server type using a tnsnames. The database service name that specifies the database used for the connection.

The service name is a string that is the global database name-a name that typically comprises the database name and domain name. See Performance Considerations for information about specifying the database service name using a tnsnames.

The Oracle System Identifier that refers to the instance of the Oracle database running on the server. This property is mutually exclusive with the ServiceName property.

The path and filename to the tnsnames. Using a tnsnames. The value of this property must be a valid path and filename to a tnsnames. If this property is specified, do not specify the following properties to prevent connection information conflicts:. If any of these properties are specified in addition to this property, the driver generates an exception.

See Performance Considerations for information about using tnsnames. The Oracle net service name used to reference the connection information in a tnsnames. The value of this property must be a valid net service name entry in the tnsnames. The case-insensitive default user name used to connect to your Oracle database. A user name is required only if security is enabled on your database. If so, contact your system administrator to obtain your user name. Operating System authentication is not currently supported by the Oracle driver.

Oracle server name and port Oracle System Identifier SID or Oracle service name Server process type shared or dedicated Connection failover instructions Client load balancing instructions. The connection URL does not specify the server name and port of the database server; that information is specified in the tnsnames. If coding a path on Windows to the tnsnames. Table Oracle Driver Property Mappings to tnsnames.

A port of , the default port number when installing an Oracle database, is specified for server1. The server entry can be an IP address or a server name. The server name server1 is specified in the first server entry. The service name is a string that is the global database name—a name that typically comprises the database name and domain name. Oracle10 g only. Session Parameter. The Oracle session time zone. The Oracle driver sets the time zone to the current time zone as reported by the Java Virtual Machine.

The default timestamp format. The default timestamp with time zone format. Using a timestamp using PreparedStatement. Using a string using PreparedStatement.

The driver uses the UTF8 character set to communicate with the Oracle server. Using this value forces the driver to use UTF8 to communicate with the Oracle server.

This can negatively affect performance. Add a comment. Active Oldest Votes. Zardoz89 Zardoz89 5 5 silver badges 16 16 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta.

The default is enabled. Retry - The number of times the connection failover is attempted. The default is 10 attempts. Delay - The number of seconds to delay between failover attempts. The default is 10 seconds. The following list is an explanation of the fields found on the Workarounds Options tab shown in the preceding graphic:.

This support is disabled by default. ODBC calls made by the application to specifically change the value of the attribute after connection time are unaffected by this option and complete their functions as expected. By default, this option is off. This enhancement improves the performance of Oracle ODBC driver up to 10 times, depending on the prefetch size set by the user.

The default value is 0. The maximum value that you can set is 64 KB bytes. If the value of prefetch size is greater than , the data fetched is only bytes. If you pass a buffer size less than the prefetch size in nonpolling mode, a data truncation error occurs if the LONG data size in the database is greater than the buffer size. By default, this function is enabled.

A subprogram call specified in an EXEC statement is translated to its equivalent Oracle subprogram call before being processed by an Oracle database server. By default this option is disabled. Schema , which is the translated Oracle subprogram assumed to be defined in the user's default schema.

However, if all subprograms from the same SQL Server database are migrated to the same Oracle schema with their database name as the schema name, then set this field to database. If all subprograms owned by the same SQL Server user are defined in the same Oracle schema, then set this field to owner. This field is empty by default. An Oracle server waits indefinitely for lock conflicts between transactions to be resolved.

The value you enter for the LockTimeOut parameter is the number of seconds after which an Oracle server times out if it cannot obtain the requested locks. In the following example, the Oracle server times out after 60 seconds:. Connecting to an Oracle Data Source. As part of the connection process, an application can prompt you for information. If an application prompts you for information about an Oracle data source, do the following:.

An application must connect to a data source to access the data in it. Different applications connect to data sources at different times.

For example, an application might connect to a data source only at your request, or it might connect automatically when it starts. For information about when an application connects to a data source, see the documentation for that application. Data Source Configuration Options. Expired Password Behavior. If you try to connect to the database and your password has expired, you are prompted to change your password.

Upon making a successful password change, you are connected to the database. Instead, an error condition results, producing an error message and number that indicates that the password has expired. Implementation of Data Types Advanced. Limitations on Data Types. In addition to Oracle's grammar, the vendor-specific escape sequences outlined in Appendix C of the ODBC specifications are also supported. Data Types for advanced users. Implementation of Data Types Programming. Floating Point Data Types.

When connected to a Table describes these limitations. The limiting factor is the client workstation memory. Oracle database allows only a single long data column per table. The driver derives this information both from errors detected by the driver and errors returned by the Oracle server. Native Error. Error Message. For errors that occur in the data source, the Oracle ODBC Driver returns an error message based on the message returned by the Oracle server.

The prefixes in brackets [ ] identify the source of the error. When the error occurs in the data source, the [vendor] and [ODBC-component] prefixes identify the vendor and name of the ODBC component that received the error from the data source. For example, if the error message does not contain the [Ora] prefix shown in the following format, the error is an Oracle ODBC Driver error and should be self-explanatory. Although the error message contains the [Ora] prefix, the actual error may be coming from one of several sources.

If the error message text starts with the following prefix, you can obtain more information about the error in the Oracle server documentation. Format of the Connection String. Reducing Lock Timeout in a Program.

Linking with odbc Information About rowids. The following table describes keywords that can be included in the connection string argument of the SQLDriverConnect function call. Missing keywords are read from the Administrator entry for the data source. Values specified in the connection string override those contained in the Administrator entry. Sets the token size to the nearest multiple of 1 KB bytes beginning at 4 KB bytes.

If the following keyword is specified in the connection string, the Oracle ODBC Driver does not read values defined from the Administrator:. Connecting to an Oracle Data Source for all users. For more information, see the Oracle Net Services documentation. The Oracle server waits indefinitely for lock conflicts between transactions to be resolved. Reducing Lock Timeout for more information on specifying a value in the oraodbc.

For Windows platforms, when you link your program, you must link it with the import library odbc However, the rowid value must be presented in a parameter marker.

Oracle reference cursors Result Sets allow an application to retrieve data using stored procedures and stored functions. The ODBC syntax for calling stored procedures must be used. The following identifies how to call the procedure or function without a package and within a package.

The package name in this case is RSET. For example, assume procedure Example2 is defined to have four parameters. Parameters 1 and 3 are reference cursor parameters and parameters 2 and 4 are character strings. The call is specified as:. Migrated procedures are often reorganized and created in schemas in one of these ways:. All procedures defined in one SQL Server database are migrated to the schema named with that database name.

To support these three ways of organizing migrated procedures, you can specify one of these schema name options for translating procedure names. Object names in the translated Oracle procedure call are not case-sensitive. The symbols for the new attributes are defined in the file sqora. This attribute is necessary for the ODBC application to determine which connection the failure event is taking place on.

Null is returned if the attribute has not been set. The failure events map directly to the events defined in the OCI programming interface. The list of possible events is:. Use this option when you migrate any third party ODBC application to Oracle Database and you want to use implicit results functionality as supported by the previous vendor.

Oracle Database Globalization Support Guide for information about Datetime data types and time zone support. Oracle Database Globalization Support Guide for more information about setting the session time zone. Environment Setup. For example:. Error Messages for advanced users. Implements ODBC support for implicit results. Unicode Functions in the Driver Manager.

Data loss is possible when the Driver Manager is converting from Unicode to the local code page. An ODBC application developer need not explicitly call entry points with the suffix. String arguments are converted from Unicode to the local code page. The text of the SQL statement parameter is converted from Unicode to the local code page.