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

[Tim Zych]

This function works in a Windows Forms .Net application, but when I try it in
an ASP.Net application, 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.

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
Does anybody know what I'm doing wrong or not doing?

Thanks.

[Rob Meade]

"Tim Zych" wrote ...

Does anybody know what I'm doing wrong or not doing?

A wild stab in the dark would perhaps be that maybe the website is using the
IUSR_<computer-name> account for browsing, and as such does not carry with
it any NT name used to log in to your database?

Only a guess...

Rob

[Bruce Barker]

you connect string says to use trusted secuity. this means the asp.net
application must run as a domain user with access to the database. in
server2003, config the app pool, else the impersonate in the web config

-- bruce (sqlwork.com)

"Tim Zych" <Ti*****@discus sions.microsoft .com> wrote in message
news:E1******** *************** ***********@mic rosoft.com...

This function works in a Windows Forms .Net application, but when I try it
in
an ASP.Net application, 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.

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
Does anybody know what I'm doing wrong or not doing?

Thanks.

[Tim Zych]

I'm using Forms Authentication, if that matters.

I don't know how to implement any changes you mention. I'm using Windows 2000.

thanks

"Bruce Barker" wrote:

you connect string says to use trusted secuity. this means the asp.net
application must run as a domain user with access to the database. in
server2003, config the app pool, else the impersonate in the web config

-- bruce (sqlwork.com)

"Tim Zych" <Ti*****@discus sions.microsoft .com> wrote in message
news:E1******** *************** ***********@mic rosoft.com...

This function works in a Windows Forms .Net application, but when I try it
in
an ASP.Net application, 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.

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
Does anybody know what I'm doing wrong or not doing?

Thanks.

[Tim Zych]

I'm using Forms Authtication to log in.

"Rob Meade" wrote:

"Tim Zych" wrote ...

Does anybody know what I'm doing wrong or not doing?

A wild stab in the dark would perhaps be that maybe the website is using the
IUSR_<computer-name> account for browsing, and as such does not carry with
it any NT name used to log in to your database?

Only a guess...

Rob