Hi there we have a problem with ODBCConnection and SQL Server 2005…When we try to retrieve a value from a result set using GetValue it returns false.
We have used the same code from the designer help with some modifications…
And the code works with SQL Server 2000!
I have looked at other posts and someone said that “Notes ODBC can’t read data of columns of type nvarchar”.
We have tried to convert the columns to char but it still does not work…
Does anybody have any suggestions or solutions please?
Dim con As New ODBCConnection
Dim qry As New ODBCQuery
Dim result As New ODBCResultSet
Set qry.Connection = con
Set result.Query = qry
con.ConnectTo(“XYZ”)
qry.SQL = “SELECT * FROM XXXXX”
result.Execute
Do
result.NextRow
For i = 1 To result.NumColumns
result.GetValue(i)