Connection to the database with and include file

[thehak]

Hi, here is my problem :<BR><BR>I build the connection to the database in an include file (Connection.aspx), this one looks like that :<BR><BR><%@ Import Namespace="System.Data" %><BR><%@ Import Namespace="System.Data.ADO" %><BR><BR><script language="VB" runat="server"><BR>Sub MakeConnection()<BR> Dim DcnDB AS ADOConnection<BR> Dim ConnString AS String<BR> <BR> ConnString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=;Initial Catalog=Northwind; Data Source=NETFORCE"<BR> DcnDB= New ADOConnection(ConnString)<BR><BR>End Sub<BR><BR></script><BR><BR>On another page, I call the connection like that :<BR><BR><BR><%@ Import Namespace="System.Data" %><BR><%@ Import Namespace="System.Data.ADO" %><BR><%@ Page Language="VB" Debug="true" %><BR><BR><!--#include file="Connection.aspx"--><BR><BR><script language="VB" runat="server"><BR><BR>Sub Page_Load(Src As Object, E As EventArgs) <BR> Message.Text=Name.Text<BR> MakeConnection()<BR> DcnDB.open()<BR> DcnDB.close()<BR>End Sub<BR><BR></script><BR><BR>I always have the same error message :<BR>"The name 'DcnDB' is not declared."<BR><BR>I want to keep the connection in an include file How can I solve this problem ? (note that the call to the sub works correctly).<BR><BR>Last word : I don't really want to put my connection between <% %> tags.<BR><BR>Thanks for all