Presumably there is something wrong with my query? The table removals definitely exists, and definitely contains the fields r-num and r-name - which are bothĪny clues? Imports Module Module1 Sub Main() Dim DbConnection As New OdbcConnection('DSN=removedforsecurity Uid=sysprogress Pwd=') DbConnection.Open() Dim DBcmd As New OdbcCommand DBcmd = DbConnection.CreateCommand DBcmd.CommandText = 'SELECT r-num, r-name FROM removals' Dim DBReader As OdbcDataReader DBReader = DBcmd.ExecuteReader() Dim strcol1 As String Dim strcol2 As String While DBReader.Read strcol1 = DBReader.GetString(DBReader.GetOrdinal('r-num')) strcol2 = DBReader.GetString(DBReader.GetOrdinal('r-name')) Console.WriteLine(strcol1, ' - ', strcol2) End While DBReader.Close() DBcmd.Dispose() DbConnection.

NetCore instruction captures restful web service. I've attached my code - which fails at line 10.ĮRRORTable/Vie w/Synonym not found NetCore, restful web service of the Progress OpenEdge ODBC database.

server PROGRESS returned message DataDirect ODBC Progress OpenEdge Wire. Progress OpenEdge Integration And Synchronization. This driver ( MSDASQL) is used to wrap an ODBC connection on the server. The connection seems to open ok - but having problems running a query. Example connection configuration to connect to an Progress OpenEdge database via OpenEdge ODBC provider. I'm trying to write a console application in VB.net that will query an openedge 10.1b database and return the results (yeah, I could use the Progress tools but I wanna do other stuff with the data independent of the openedge server - this is just a proof of concept)

Openedge odbc