connect to sql database

nat35 · Nov 24, 2002

Hi,
I am a new to asp.I am creating a webside for intranet
I've created a asp in FP2000.
when i preview in browser i can see my code only.
How do i know if it is working and how i can debug.
what are my steps? do i need pws on my computer?
here is my simple code
<%

Dim cnnSimple
Dim rstSimple

Set cnnSimple = server.CreateObject("ADODB.Connection&quot

cnnSimple.Open "driver=SQL Server;server=10.1.1.50;uid = sa; password = '';database=intranet;"<BR>
Set rstSimple = cnnSimple.Execute("SELECT * From tbl_department&quot

<BR>%><BR>
%>
<table border="1" height="18">
<%
Do While Not rstSimple.EOF
%>
<tr>
<td height="12"><%= rstSimple.Fields("dep_id&quot

.Value %></td>
<td height="12"><%= rstSimple.Fields("s_name&quot

.Value %></td>
<td height="12"><%= rstSimple.Fields("name_ref&quot

.Value %></td>

</tr>
<%
rstSimple.MoveNext
Loop
%>
</table>
<%
rstSimple.Close
Set rstSimple = Nothing
cnnSimple.Close
Set cnnSimple = Nothing

%>
thank you in advance

Transcend · Nov 24, 2002

Hi there,

the first thing you should know is that there is no easy way to 'debug' asp. The best way to do it i have found is to insert Response.write expressions in places to see what varibles look like etc ...

The other thing is, do you have IIS running?

Transcend

nat35 · Nov 24, 2002

Transcend,
yes i do have iis running
what is my next step
nat
what is my next step

Transcend · Nov 24, 2002

Hi again,

ok it seems you have a few bits of code missing ...

for a start <%@ Language=VBScript %> should be at the top of your page,

secondly you don't seem to have all the html code that you need ... the only html I can see there is the table creation. You are missing the
<html>
<head>
</head>
<body>
</body>
</html> tags which should appear in your code ...

you need to place the code which you have pasted above between the <body> and </body> tags

Hope this helps

Transcend

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

connect to sql database

nat35

Programmer

Transcend

Programmer

nat35

Programmer

Transcend

Programmer

Similar threads

Part and Inventory Search

Sponsor