HELP: Using ADO to connect to a Teradata ODBC driver 
Author Message
 HELP: Using ADO to connect to a Teradata ODBC driver


I'm connecting using ADO v2.1sp2 using a Teradata ODBC driver
v2.06.0001 from a DSN setup.

Programming language: Visual Basic 6

My current functionning connection string is:
conTDDB.Open "DSN=TERATEST;UID=training1;PWD=training1;"

The bad news is that when the password is expired, I get an "80040E4D -
[NCR][Teradata RDBMS] User password has expired" error.

The good news is that there is a function in the Teradata ODBC driver
that can change the password when that happens.

I need to access the ODBC Teradata driver directly to use the extension-
level-1 function "SQLDriverConnect()" in order to pass the following
connection string which will allow me to change the user password:

This doesn't work with the ADO.Connection Open method.

Could you help me figure out how I can call the SQLDriverConnect()
function to be able to change the pwd ?

Thank you very much,


Sent via http://www.*-*-*.com/
Before you buy.

Mon, 24 Mar 2003 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Connecting vb4 to an ingres database using datadirect odbc driver

2. Connect Informix database thru ODBC driver using Visual Basic

3. Connecting to Access 97 Database using ADO with OLE DB Driver

4. Connecting to Access 97 Database using ADO with OLE DB Driver

5. teradata driver

6. Connect to HP3000 using Minisoft ODBC and ADO

7. Oracle ODBC driver / Microsoft ODBC driver for Oracle

8. help! Using 16-bit ODBC driver (Superbase)

9. Connecting to an Access 95 database via an ODBC driver in VB 5.0

10. informix ODBC driver for I-Connect cannot support the RDO

11. ODBC ERROR: no interfacr driver connected - funciton not performed

12. VB4 Visigenic 32Bit ODBC driver connecting to Oracle 7


Powered by phpBB® Forum Software