I'm new to ASP development (1 month!), and as many of you can probably 

remember, sometimes the simplest things can be frustrating when you make 

stupid errors. I hope within a few more months to be better at 

troubleshooting; however, my novice skills are my biggest downfall. Ok, 

here's my problem:  I an trying to connect from my NT server to a SQL 

server where my database resides.  I am not receiving any errors, yet I 

cannot display any data from the database. Any assistance on this issue 

given would be greatly appreciated.  Thank you.  I used the following as 

my connection string which is included in the file connFindMe: 

MM_connFindMe_STRING = "Driver={SQL 

Server};Server=sqldata;Database=Emp;Uid=sstephenew;Pwd=;"



Below, I pasted the coding at the top where I reference this.

<%@LANGUAGE="VBSCRIPT"%>

<!--#include file="Connections/connFindMe.asp" -->

<%

Dim findme__MMColParam

findme__MMColParam = "1"

if (Request.Form("txtLastName") <> "") then findme__MMColParam = 

Request.Form("txtLastName")

%>

<%

set findme = Server.CreateObject("ADODB.Recordset")

findme.ActiveConnection = MM_connFindMe_STRING

findme.Source = "SELECT * FROM dbo.Listing WHERE LastName = '" + Replace

(findme__MMColParam, "'", "''") + "' ORDER BY LastName ASC"

findme.CursorType = 0

findme.CursorLocation = 2

findme.LockType = 3

findme.Open()

findme_numRows = 0

%>

I figured out that the problem was with my SQL scripting instead!