Recent content by terrence_chan99

The column name cannot be change as it is from a 3rd party company. I have also tried this. rsCustomer.open "select empid, lastname, firstname from pub.customer where ""misc-char-4"" = ""Lee"" ", cnn But still not work.

I keep getting progress syntax error with this... what should be the correct syntax.(something wrong in the misc-char-4 = 'Lee' ) <%@ Language=VBScript %> <% set cnn = server.createobject("ADODB.Connection") cnn.open "DSN=TESTDSN; pwd=pasword;" set rsCustomer =...

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

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...