I am using ASP-DBPRO. I have downloaded it to NT server. Now, I have a PC connected to this server, from where I am writing the asp scripts. When I tried to run the below code, I got this error ... "Warning: User supplied query returns no records for display
Select ssn from exit_questionnaire"

The code I am using is...
<%
Set MyDb = Server.CreateObject(&#34;ASP.db&#34
MyDb.dbDSN = &#34;Driver={SQL _ Server};Provider=sqloledb;Server=OJA007;Database=J OLTS;UID=sa;PWD=;&#34;
MyDb.dbDBType = &#34;SQL&#34;
MyDb.dbSQL = &#34;Select ssn from exit_questionnaire&#34;
MyDb.ASPdb
%>

Is there anything wrong with the script?
If I want to use the designer form my PC, do I have to download the ASP-DB on to my PC? Any help is appreciated.

Thanks
Phani