SQL connection works in forms application, but not asp.net_

[Tim Zych]

I'm trying to connect to a SQL Server (Express) database with an Asp.Net
solution that currently uses MS Access. I want to replace it with SQL
Server.

I got a rudimentary prototope to work in a .Net Forms application, but when
I try to connect to the database from ASP.Net, I get an error:

-----
Cannot open database "codelib" requested by the login. The login failed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: Cannot open database
"codelib" requested by the login. The login failed.
-----

Here's the function. I pulled the connection string out of the data
connection that Visual Studio.Net created when I added a new connection. I
do not know if this is the proper connection string. It worked for the Forms
app, but I do not know what must be done to get it to work for Asp.Net.

Function SqlTest() As String
Dim cn As New OleDbConnection
Dim cmd As New OleDbCommand
Dim strConn As String
Dim strSql As String
strConn = "Provider=SQLOL EDB.1;Integrate d Security=SSPI;P ersist
Security Info=False;Init ial Catalog=codelib ;Data
Source=X3934834 392\SQLEXPRESS; Use Procedure for Prepare=1;Auto
Translate=True; Packet Size=4096;Works tation ID=X3934834392; Use Encryption
for
Data=False;Tag with column collation when possible=False"
cn.ConnectionSt ring = strConn
cn.Open()
strSql = "SELECT tblCode.title FROM tblCode WHERE tblCode.ID=" & 1 &
";"
cmd = New OleDbCommand(st rSql, cn)
Return CStr(cmd.Execut eScalar)
End Function

Is there a tutorial that can walk me through step by step how to connect to
SQL Server via ASP.Net? Or can someone please help me to get this to work?
This is an ASP.Net application that uses simple Forms authentication.

thanks for any help.

This is a 2nd post based on an earlier post. I got some replies that look
like they pointed in a direction in a macro way, but I do not know how to
implement them.

[shiv_koirala]

In your connectionstrin g i do not see the userid and password attribute
-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

[Tim Zych]

It's the same connection string that worked for the windows forms.

I tried entering the password and userid, which actually I don't have one
because SQL Server is using Windows Authentication, and got the same error.
<sh**********@y ahoo.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

In your connectionstrin g i do not see the userid and password attribute
-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/