Recordset clobbers asp page

35 pts.
Tags:
ASP
Dreamweaver CS4
Recordset
SQL connection
VBScript
I am using Dreamweaver CS4 VBScript asp pages. I have a database sitting on a SQL server. My connection resides on the server, not my machine. I build a page with just text and I can go to it just fine and then I make a recordset using the connection to the SQLserver, point to the correct table and fields. At that point when I go back out to my browser it blows up trying to open that page saying that the web can not display the page. When I test the connection two of the fields say indefined and one field has data in it. I have tried to dump and rebuild the table on the server (from the server). Please help
ASKED: April 20, 2009  7:02 PM
UPDATED: April 21, 2009  3:57 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Your SQL connection code may not be right, also put some values in the undefined table fields.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • scuzantip
    Here is my connection code <% ' FileName="Connection_odbc_conn_dsn.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="true" ' Catalog="" ' Schema="" Dim MM_connSIPsql_STRING MM_connSIPsql_STRING = "dsn=SIPsql;uid=ADMINuser;pwd=nuggets;" %> I do have values in the one record that I have in the table. It give me undefined fields, not the table itself.
    35 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following