setting up a web page

#1 (**permalink**) 02-21-2004

Running apache http server 2.0 on a win xp pro machine with mssql
server 2000 ver 8.0

My main question:I would like to pull some information from a sql
database
I have tested apache by typing localhost into address and that part
works.
So now i have apache runing and mssqlserver running(under windows
authentication).
So now I am type in interdev:
----------------------------------------------------
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>

<P>hello goodbye</P>

<%
cst = "Provider=SQLOLEDB;Data Source=<24.175.137.109>;" & _
"Initial Catalog=<northwind>;Integrated Security=SSPI"
set conn = CreateObject("ADODB.Connection")
conn.open cst
%>

</BODY>
</HTML>
-------------------------------------------

and save this file as sample.asp in apache2/htdocs/sample.asp
my results come up in the browser like this:

--------------------------------
<%@ Language=VBScript %>

hello goodbye
<% cst = "Provider=SQLOLEDB;Data Source=<24.175.137.109>;" & _
"Initial Catalog=;Integrated Security=SSPI" set conn =
CreateObject("ADODB.Connection") conn.open cst %>

--------------------------------
So, the html is being parsed but the asp tags are NOT
what is my problem?? do i need an apache mod to parse asp?

and if you can answer that i have another question:

what should my connection string look like. do i need to setup a dns
because the only reason i installed apache instead of iis is i
couldn't get the dns to recognize my username and password so i was
trying to work around that. I can use oledb somehow with a dsn-less
connection right?

Now i don't know if the connection string is completly correct but my
question is this

#2 (**permalink**) 02-21-2004

brianj wrote:

> So, the html is being parsed but the asp tags are NOT
> what is my problem?? do i need an apache mod to parse asp?

Yes, but the ASP modules which support VBScript are commercial and I haven't
heard much good about them (I'm not sure if they run under Windows anyway).

I'd suggest you pick a different language to work with. PHP
<http://www.php.net/>, Perl
<http://www.activestate.com/Products/ActivePerl/>, and Python
<http://www.python.org/> are reasonable choices.

--
David Dorward <http://dorward.me.uk/>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode