Hi,
When trying to open connection 'Conn.Open strConn' in the code below, getting the following message: Any cluee/link please. I am trying different things like reinstalling teradata odbc driver but not successful.
[Teradata][ODBC Teradata Driver] invalid Attribute
But this connection works from some functions but fails in some.
Dim Conn As ADODB.Connection
Dim strConn As String
Dim strPass As String = "abc"
Dim strUser As String ="xyz"
Dim strOdbcName As String ="db"
strConn = "Password=strPass;" & _
"User ID=strUser;" & _
"Data Source =strOdbcName;" & _
"Persist Security Info=False"
Set Conn = Nothing
Set Conn = New ADODB.Connection
Conn.Open strConn
thanks saj
When trying to open connection 'Conn.Open strConn' in the code below, getting the following message: Any cluee/link please. I am trying different things like reinstalling teradata odbc driver but not successful.
[Teradata][ODBC Teradata Driver] invalid Attribute
But this connection works from some functions but fails in some.
Dim Conn As ADODB.Connection
Dim strConn As String
Dim strPass As String = "abc"
Dim strUser As String ="xyz"
Dim strOdbcName As String ="db"
strConn = "Password=strPass;" & _
"User ID=strUser;" & _
"Data Source =strOdbcName;" & _
"Persist Security Info=False"
Set Conn = Nothing
Set Conn = New ADODB.Connection
Conn.Open strConn
thanks saj