If ":security. SAME" is used, no password is required, and the ":userid" tag is supposed to be ignored. PGM" is used, both the :userid and :password values are sent to Windows for validation. They are PQ and PQ Run "sqldbsu. First, run "isql. IBM hasn't come up with a fix for this problem yet. It all pretty much works as advertised when things are done right. There are problems, however, when user errors are encountered.
IBM is still working on both of those problems. Dick thanks for the info! I will try it out and let you know how it goes. DB2 UDB 7. I have done the other way around using DRDA, but not this. Jim Ruski. Hope this helps.
Jim Quote:. Page 1 of 1. Some of the properties in the All tab are required. These properties may be edited by selecting a property from the displayed list and selecting Edit Value.
In Auto Commit Mode, every database operation is a transaction that is committed when performed. This mode is suitable for common transactions that consist of a single SQL statement. It is unnecessary to delimit or specify completion of these transactions. The default is True. Cache Authentication: The provider's data source object or enumerator is allowed to cache sensitive authentication information such as a password in an internal cache. The default is False. Default Isolation Level: This determines the level of isolation used in cases of simultaneous access to DB2 objects by multiple applications.
The default is NC. The following levels are supported:. Default Schema: The name of the collection where the provider looks for catalog information. Extended Properties: A method to specify additional provider-specific properties.
Properties passed through this parameter should be delimited by semicolons and will be interpreted by the provider's underlying network client. This parameter defaults to U.
The default is the well-known DRDA port address of The default value is SNA. This could be same as the Default Schema.
PC Code Page: This property is required when processing binary data as character data. The default value for this property is Latin 1 Persist Security Info: Optionally, you can choose to save the password in the UDL file by selecting the Allow saving password check box. Read Only: Creates a read-only data source. Skip to main content.
0コメント