Solved

Can't get classic asp connection to work with sql server 2005

Posted on 2008-10-13
4
312 Views
Last Modified: 2012-05-05
I'm trying to connect an asp page to a sql server 2005 database.  The asp page is on an IIS server, on two different servers.  This is not an express edition.

I've been able to connect to the database from a php page on an apache2 server, but now I need the IIS to connect, and can't get it to work.  When I open the page, I don't get any errors, or anything to display, just a blank page.  

Also, since I don't know ASP, I don't know if its the code, or the connection that isn't working.  There is data in the database, I've taken the php page that works, and using that to try and make an asp page.
<%

Set Conn = Server.CreateObject("ADODB.Connection")

Set Rs = Server.CreateObject("ADODB.RecordSet")

mserver="server.domain.edu"

dbName="database"

UserID_db="user"

PassWD="password"

strCon="Provider=SQLOLEDB.1;Data Source=" & mServer & ";Initial Catalog=" & _

  dbName & ";User ID=" & UserID_db & ";Password=" & PassWD & ";"

Conn.Open strCon

sSQL = "SELECT * FROM myNorthwest_Links1 ORDER BY links_ID ASC"

Set Rs = Conn.Execute(sSQL)

Do While NOT Rs.EOF

Rs.MoveNext

Loop

Rs.Close

Set Rs = Nothing

Conn.Close

Set Conn = Nothing

%>

Open in new window

0
Comment
Question by:baumli1
  • 2
  • 2
4 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 125 total points
Comment Utility
You're not doing anything w/ your retrieved data:

Do While NOT Rs.EOF

  Response.write rs.fields(0).value & "<br>"

Rs.MoveNext

Loop

Open in new window

0
 

Author Comment

by:baumli1
Comment Utility
Added that in, and no change, still a blank page.  How can I display error messages so I can at least see if I am getting the connection to work?
0
 
LVL 32

Expert Comment

by:Daniel Wilson
Comment Utility
I'm trying to remember if this works in classic ASP ... it would in VB6 ...



<%

On Error Goto Err_Handler
 

Set Conn = Server.CreateObject("ADODB.Connection")

Set Rs = Server.CreateObject("ADODB.RecordSet")

mserver="server.domain.edu"

dbName="database"

UserID_db="user"

PassWD="password"

strCon="Provider=SQLOLEDB.1;Data Source=" & mServer & ";Initial Catalog=" & _

  dbName & ";User ID=" & UserID_db & ";Password=" & PassWD & ";"

Conn.Open strCon

sSQL = "SELECT * FROM myNorthwest_Links1 ORDER BY links_ID ASC"

Set Rs = Conn.Execute(sSQL)

Do While NOT Rs.EOF

  Response.write rs.fields(0).value & "<br>"
 

Rs.MoveNext

Loop

Rs.Close

Set Rs = Nothing

Conn.Close

Set Conn = Nothing
 

Goto NoError
 

Err_Handler:

  Response.write "ERROR " & err.number & ": " & err.Description

NoError:

%>

Open in new window

0
 

Author Comment

by:baumli1
Comment Utility
Yes, the first response was the correct one.  I am using a cms that was giving a template to the page, the asp had no template matching sections, so nothing was displaying.  Once I told the cms to not apply a template, and add in the Response.write statement in the loop it worked.  Thanks for the help.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now