I keep getting 500 Internet Server Error, here is the script I'm using in the header:
strConn = Session("connect")
StrConn="Provider=sqloledb;Data Source=18.104.22.168;Database=db_name;User ID=user_id;Password=user_pw;"
Set dbc = Server.CreateObject("ADODB.Connection")
DIM SQL, objRS
SQL = "SELECT * FROM table_name WHERE coulmn_name='Yes'"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open SQL, dbc
And here is what I have between the <body> tags:
Title of the CURRENT article: <%= objRS("title") %>
The Database login/pw/& db_name are correct and verified with Lunarpages Tech Support, but they couldn't help me with the connection script.
Thanks for any help!