Monday, July 27, 2009

SQL Database Connection

Standard security connection
To be placed in the of the web page.

<*script runat="server">
sub Page_Load
Dim dbconn

dbconn = New OleDbConnection("provider=sqloledb; data source=computername;
initial catalog = nameofdatabase; User Id = sa; Password='manager'")
dbconn.Open()
end sub
<*/script>

No comments:

Post a Comment