Connecting VB to Progress 9.1E

[sdutta]

Hello all. I'm trying to connect VB to progress 9.1E. I've been able to establish the connection to the database however, I can't seem to access any of the tables. Can someone help me out with it?

Dim cn As OdbcConnection
cn = New OdbcConnection("dsn=*****;db=qaddb;uid=***-pwd=*****;host=****-port=*****;")

Try
cn.Open()

Dim sqlstatement As String = "select * from pub.pt_mstr"
Dim mycomm As OdbcCommand = New OdbcCommand(sqlstatement, cn)
Dim reader As OdbcDataReader = Nothing
Dim dscommand As New OdbcDataAdapter()
dscommand.SelectCommand = mycomm
Dim dsproject As New DataTable()
dscommand.Fill(dsproject)

Catch ex As OdbcException
MsgBox(ex.Message)
Finally
cn.Close()
End Try

i recieve a error[42s02][datadirect][odbc progress driver][progress]table/view/synonym not found(7519).

i've tried everything with the select statement and i still get that error including qaddb.pub.pt_mstr, just pt_mstr, pub.pt_mstr and others. any suggestion would be helpful thank you very much in advance for your time.

i'm also getting a
A first chance exception of type 'Microsoft.Data.Odbc.OdbcException' occurred in Microsoft.Data.Odbc.dll
at the bottom of the screen.

i noticed that when i set the reference under project in vb it did not have Microsoft.Data.Odbc.dll but it did have Microsoft.Data.Odbc ..i'm running xp professional..i dunno if this is an issue or not.

 

[rstanciu]

In the fact, the owner of the database has full access to these tables.
If your user is not owner you see nothing , you have to connect as the user/owner of
this database and give rigths to public:

grant select on pub.customer to public;

 

[sdutta]

In the fact, the owner of the database has full access to these tables.
If your user is not owner you see nothing , you have to connect as the user/owner of
this database and give rigths to public:

grant select on pub.customer to public;

thank you for the reply. i believe that solves the problem. appreciate it.