Archives of the TeradataForum
Message Posted: Wed, 05 Nov 2003 @ 18:09:59 GMT
Sorry if this question has been asked before:
For some reason, when I run my query from my VB app, I get no data using the above ODBC driver. If I run the exact same program on a machine with ODBC v2.04.00.00 it works fine. Any suggestions on how to get this driver to work?
Here's my code:
'----Start Code Dim RS_ddw As ADODB.Recordset Dim CN_ddw As ADODB.Connection Dim strSQL as String Set CN_ddw = New ADODB.Connection CN_ddw.ConnectionString = "DSN=DDW_DW;user=SOME_USER;pwd=SOME_PWD" CN_ddw.Open Set RS_ddw = New ADODB.Recordset strSQL = "Select * from item where dept = 10" Set RS_ddw = CMD.Execute(strSQL) 'Also tried but still no data 'RS_ddw.Open strSQL, CN_ddw Do While Not RS_ddw.EOF 'Do some stuff here Loop RS_ddw.Close CN_ddw.Close '---END Code
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|