-
Basics of ASP-DB
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("ASP.db"
MyDb.dbDSN = "Driver={SQL _ Server};Provider=sqloledb;Server=OJA007;Database=J OLTS;UID=sa;PWD=;"
MyDb.dbDBType = "SQL"
MyDb.dbSQL = "Select ssn from exit_questionnaire"
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|