Most of the properties are also used in ADO. Close this window and log in. All properties and descriptions is from msdn. Red Flag This Post Please let us know here why this post is inappropriate. The corresponding network DLL must be installed on the system to which you connect.

Uploader: Gozuru
Date Added: 6 February 2014
File Size: 30.24 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 30542
Price: Free* [*Free Regsitration Required]

This is from VB help sample: This table shows all connectionstring properties for the ADO. All properties and descriptions is from msdn.

Teradata Warehouse Miner ODBC Data Sources

Determines whether the database connection is reset when being mimeer from the pool. If you do not specify a network and you use a local server for example, “. Connection Lifetime 0 When a connection ,imer 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. Size in bytes of the network packets used to communicate with an instance of SQL Server.

When true, the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool.


International Character Sets and the Teradata Database for more information.

The name of the application, or ‘. I have problems to create stored procedures in mimer 8.

This is the Teradata database where the tables to be analyzed reside. By joining you are opting in to receive e-mail. The name or network address of the instance of SQL Server to which to connect. Teradata Warehouse Miner requires data sources to be defined in a certain manner.

The empty DSN parameter is indeed critical as not including it will result in error Close End Sub RE: When true, the pooler automatically enlists the connection in the creation thread’s current transaction context. Still dont know how to do it in BatchSQL.

Teradata Warehouse Miner ODBC Data Sources

Name Default Description Application Name. Promoting, selling, recruiting, coursework and thesis posting is forbidden. The network library used to establish a connection to an instance of SQL Server. The name of the primary file, including the full path name, of an attachable database.

unixODBC – Drivers

The Result Database will contain any result tables or views. Resetting the connection string resets all connection string values including the password.


The two double quota following the DSN parameter at the end are escaped quotas VB syntaxyou may have to change this to your language mi,er escape syntax. If a name occurs more than once, the value from the last one in the connectionstring will be used.

I entered the code: Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. Max Pool Size The maximum number of connections allowed in the pool.

The database name must be specified with the keyword ‘database’.

To finish off, enter alone on a line input is shown in boldface above, i. These are also only default values and can be changed on the Connection Properties dialog. Similarly, the name given for the Username is used as the default value for ,imer Teradata Warehouse Miner databases.

Net SqlClient Data Provider’ if no application name is provided.