DaniWeb Forum Index > Web Development > ASP

Is there anything wrong with this code

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2005

Posts: 27

Reputation: wchitamb is an unknown quantity at this point

Solved Threads: 0

wchitamb

Offline

Light Poster

Is there anything wrong with this code

Aug 12th, 2005

<html>
<head>
<title></title>
</head>
<body>
<%

Function NewConn()
Set NewConn= Server.CreateObject("ADODB.Connection")
NewConn.ConnectionTimeout=100
NewConn.Open "Provider=sqloledb;Data Source=[192.168.160.1];uid=[sa ];pwd=[topland]"
NewConn.CommandTimeout=1200
End Function

%>
</body>
</html>

I am trying this functions.inc code then use the include ext and i keep on getting this error message

Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file 'functions.inc' was not found.
/Assets.asp, line 1

and when i try to save it as functions.inc.asp i get this

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/Staff.asp, line 14, column 37

i am relly stuck and have been going around for days nows can anyone please help.

•

Join Date: Jun 2005

Posts: 107

Reputation: madmital is an unknown quantity at this point

Solved Threads: 3

madmital

Offline

Junior Poster

Re: Is there anything wrong with this code

Aug 12th, 2005

To include reusable code from a file you do smth like

functions.inc:

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
Function NewConn() 
Set NewConn= Server.CreateObject("ADODB.Connection")
NewConn.ConnectionTimeout=100
NewConn.Open "Provider=sqloledb;Data Source=[192.168.160.1];uid=[sa ];pwd=[topland]"
NewConn.CommandTimeout=1200
End Function
Function NewConn() 
Set NewConn= Server.CreateObject("ADODB.Connection")
NewConn.ConnectionTimeout=100
NewConn.Open "Provider=sqloledb;Data Source=[192.168.160.1];uid=[sa ];pwd=[topland]"
NewConn.CommandTimeout=1200
End Function

And then in the file where you want to insert the 'functions.inc' (the file should have the '.asp' extension)
eg. index.asp:

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<HTML>
<BODY>
blahblah
 
<!--#include file="functions.inc"-->
 
<%
more blah blah
%>
</BODY>
</HTML>
<HTML>
<BODY>
blahblah

<!--#include file="functions.inc"-->

<%
more blah blah
%>
</BODY>
</HTML>