Hp Integrity NonStop H-Series Bedienungsanleitung Seite 34
- Seite / 62
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
Windows
To add a new data source or configure an existing data source, see “Configuring a client data
source”.
Perform the following steps to delete a client data source:
1. Select Start -> Control Panel -> Administrative Tools -> Data Sources
(ODBC).
2. Click either the System DSN or the User DSN tab to get the list of data sources.
3. Select the data source name that you want to delete and click Remove.
4. Click Yes in the confirmation dialog box to remove the data source.
Managing transactions
The AutoCommit property indicates whether SQL/MX must automatically commit the transaction
or not.
nl
The following are the valid values for AutoCommit property:
• ON
• OFF
• SERVER_DEFAULT specifies to use the server side AutoCommit settings. This option is useful
for existing applications where AutoCommit is set on the server side data source and the
user wants to persist with the same settings without making any changes to the client application
or client side data source. This is the default option.
AutoCommit property can be set in the following ways:
• Using SQLSetConnectAttr API, the values are ON/OFF.
• Using DSN properties, the values are SERVER_DEFAULT/ON/OFF.
• Using connection string without DSN, the values are ON/OFF/SERVER_DEFAULT.
NOTE: The value set using SQLSetConnectAttr API takes the highest precedence.
Setting AutoCommit
Windows driver
You can set the AutoCommit property from the Data Access tab.
Unix drivers
AUTOCOMMIT (case sensitive) is the keyword to set AutoCommit property in property file
(MXODSN for Linux and HP-UX, ODBCDSN for OSS).
Example 1 Depicting AUTOCOMMIT set to SERVER_DEFAULT
[TDM_Default_DataSource]
Description = Default Data Source
Catalog = CAT
Schema = SCH
DataLang = 0
FetchBufferSize = SYSTEM_DEFAULT
Server = TCP:hostname/portnumber
SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULT
SQL_LOGIN_TIMEOUT = SYSTEM_DEFAULT
SQL_QUERY_TIMEOUT = NO_TIMEOUT
SQLFractionValue = SYSTEM_DEFAULT
SQLDatetimeRetrieval = MSDN_DEFAULT
AUTOCOMMIT = SERVER_DEFAULT
34 Configuring data sources
- HP Part Number: 734873-002 1
- Published: November 2013 1
- Contents 3
- 4 Contents 4
- About this document 5
- Related Documentation 7
- • Installation guides 8
- • Reference manuals 8
- • Connectivity manuals 8
- • Migration guides 8
- • Data management guides 8
- Publishing history 9
- HP encourages your comments 9
- 1 Overview 10
- Architecture 11 11
- Client components 12
- Server components 12
- Driver managers 12
- Data sources 13
- Unsupported ODBC APIs 14
- Object naming and mapping 14
- Unsupported ODBC data types 15
- 16 Overview 16
- 2 Installing the drivers 17
- 18 Installing the drivers 18
- Installation procedures 19 19
- Click Next 20
- Verifying the installation 21
- Uninstalling the driver 22
- ./runme.sh 23
- 3 Configuring data sources 24
- 26 Configuring data sources 26
- 28 Configuring data sources 28
- Table File sections 30
- Managing data sources 33
- Managing transactions 34
- Tracing 35 35
- 36 Configuring data sources 36
- Considerations 37
- ODBC data types 38
- Unsigned data types 39
- Partial DATE or TIME values 40
- Microsoft escape clauses 41
- Stored Procedures 41
- 5 Error messages 49
- A Sample ODBC application 53
- Testing the sample 54
- Testing the sample 55 55
- 56 Sample ODBC application 56
- Testing the sample 57 57
- 58 Sample ODBC application 58
- Testing the sample 59 59
- 60 Sample ODBC application 60
- Glossary 61
- 62 Index 62
Verwandte Produkte und Handbücher für Computerhardware Hp Integrity NonStop H-Series
(115 Seiten)Whirlpool R 24 S (EU) podręczniki
Instrukcje obsługi i podręczniki użytkownika dla Lodówki Whirlpool R 24 S (EU).
Dostarczamy 1 pdf podręczników Whirlpool R 24 S (EU) do pobrania za darmo według typów dokumentów: Instrukcja Obsługi
Kommentare zu diesen Handbüchern