Get progress data from ASP page.

[terrence_chan99]

I have datadirect setup correctly in the ODBC. I can connect to the DB with no problem.

Now, I want to get the data from progress. I have this code in asp page.

But getting an error, "Table/View/Synonym not found(7510)".

Any help is appreciated!
Terrence

Dim cn As New ADODB.Connection
Set cn = New ADODB.Connection
cn.ConnectionString = "PROVIDER=MSDASQL;dsn=dsn_name;db=db_name;uid=sysprogress;pwd=password;host=hostname;port=4615"
cn.Open

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
'rs.ActiveConnection = cn
'rs.Open "select * from product", cn, adOpenStatic, adLockOptimistic
rs.Open "select location from location", cn, adOpenStatic, adLockOptimistic

Do While Not rs.EOF
Combo1.AddItem (rs("product"))
rs.MoveNext
Loop

 

[vinod_home]

Hi,

You are using ODBC, so prefix table names with "pub." and try.

hope that helps

 

[terrence_chan99]

It works!! Thank you so much for your help!