Then to test it a wrote a question: When set to ‘false’, 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. The database name must be specified with the keyword ‘database’. This table shows all connectionstring properties for the ADO. Red Flag This Post Please let us know here why this post is inappropriate.

Uploader: Mimuro
Date Added: 17 August 2013
File Size: 16.40 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 60366
Price: Free* [*Free Regsitration Required]

The corresponding network DLL must be installed on the system to which you connect. The name of the application, or ‘.

– LIBNAME to SQL Server using ODBC engine from Enterprise Miner

Useful in clustered configurations to force load balancing between a running server and a server just brought on-line. Setting to ‘false’ avoids making an additional server round-trip when obtaining a connection, but the mjmer must be aware that the connection state is not being reset.

International Character Sets and the Teradata Database for more information. Still dont know how to do it in BatchSQL.

Teradata Warehouse Miner ODBC Data Sources

I entered the code: Persist Security Info ‘false’ When set to ‘false’, security-sensitive information, such as the password, is not returned as odhc of the connection if the connection is open or has ever been in an open state. The Tek-Tips staff will check this out and take appropriate action. To finish off, enter alone on a line input is shown in boldface above, i.

  BEETLE ADSL MODEM DRIVER

Click Here to join Tek-Tips and talk with other members! Join your peers on the Internet’s largest technical computer professional community.

This is from VB help sample: I have problems to create stored procedures in mimer 8. All properties and descriptions is from msdn.

Students Click Here Join Us! This is only a default and can be changed on the Connection Properties dialog as described in Using Teradata Warehouse Miner.

E-mail the URL to connectionstrings.

It’s easy to join and it’s free. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

When set to ‘false’, 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. The database name must be specified with the keyword ‘database’. Once these Teradata Warehouse Miner databases are changed, this information is saved on a per Data Source basis. Close this window and log in.

  HP HEWLETT PACKARD SCANJET 3300C DRIVER

The name or network address of the instance of SQL Server to which to connect. pdbc

Name Default Description Application Name. The name of the primary file, including the full path name, of an attachable database. Max Pool Size The maximum number of connections allowed in the pool. Determines whether the database connection is reset when being removed from the pool. When true, the pooler automatically enlists the connection in the creation thread’s current transaction context.

Then to test it a wrote a question: Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Pooling ‘true’ When true, the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool. Close End Sub RE: The problem with stored procedures is that the utility QBE does not support entering a “create function” command.