473,396 Members | 1,914 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Problem connecting to Access Database from ASP.NET Application

I am trying to connect to a Microsoft Access Database from my ASP.NET
Application. I use the following code to create my connection string:

cmdSelect.Connection = New
System.Data.OleDb.OleDbConnection("PROVIDER=Micros oft.Jet.OLEDB.4.0;DATASOURCE="
& Server.MapPath("/WebApplication1/nathansokalski_com.mdb"))
Although the error does not occur until the Fill() method is called:

dataadapterSelect.Fill(ratedpoems, "poemratings")
I have a feeling the problem is in my connection string, but I do not know
what the problem is. The error returned when I try to view the page in my
browser is:

[OleDbException (0x80004005): Could not find installable ISAM.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+36
WebApplication1.poetry.poemratings.SortPoems_Click (Object sender,
EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs e)
in c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
Can someone please help me figure out what I am doing wrong or what my
connection string should look like? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/
Nov 21 '05 #1
8 1100
Try :

PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=

DATA SOURCE is 2 words, not one.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
I am trying to connect to a Microsoft Access Database from my ASP.NET Application. I use
the following code to create my connection string:

cmdSelect.Connection = New
System.Data.OleDb.OleDbConnection("PROVIDER=Micros oft.Jet.OLEDB.4.0;DATASOURCE=" &
Server.MapPath("/WebApplication1/nathansokalski_com.mdb"))
Although the error does not occur until the Fill() method is called:

dataadapterSelect.Fill(ratedpoems, "poemratings")
I have a feeling the problem is in my connection string, but I do not know what the
problem is. The error returned when I try to view the page in my browser is:

[OleDbException (0x80004005): Could not find installable ISAM.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection, ConnectionState&
originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
WebApplication1.poetry.poemratings.SortPoems_Click (Object sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
Can someone please help me figure out what I am doing wrong or what my connection string
should look like? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

Nov 21 '05 #2
Hi, Nathan.

Here's a short file you can use to determine
which account ASP.NET is running as :
-----------------
<%@ Page Language="VB" %>
<%@ Import NameSpace = System.Security.Principal %>
<script runat="server">
Sub Page_Load()
Dim tmp As String = WindowsIdentity.GetCurrent.Name()
Label1.Text = tmp
End Sub
</script>
<html>
<head>
<title>WindowsIdentity.GetCurrent.Name()</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" Runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
-------------

Run it, and it will tell you the name of the account you need to give read/write
permissions to, for the directory where your mdb file is located, so it's allowed
to read and write to the database.

Are you running a secured database ( username/password needed to read it ? )
Or just using the admin with no password ?

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:ux**************@TK2MSFTNGP10.phx.gbl...
Thank you for that information, it was definitely an error that would have caused me
problems. However, I am now recieving the following error:

[OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file
'c:\inetpub\wwwroot\WebApplication1\nathansokalski _com.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection, ConnectionState&
originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
WebApplication1.poetry.poemratings.SortPoems_Click (Object sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

I know it is not opened by another user (including me, because this is the first thing I
did after booting my computer). I tried looking at the security tab in the properties of
nathansokalski_com.mdb, but the only 2 accounts there were mine and SYSTEM (it did not
list others like Internet Guest Account, Launch IIS Process Account, VS Developers,
etc.). It is listed in Visual Studio as part of the Application. What do I need to do to
either the file or my code to be able to use the database? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:eG**************@TK2MSFTNGP09.phx.gbl...
Try :

PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=

DATA SOURCE is 2 words, not one.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
I am trying to connect to a Microsoft Access Database from my ASP.NET Application. I
use the following code to create my connection string:

cmdSelect.Connection = New
System.Data.OleDb.OleDbConnection("PROVIDER=Micros oft.Jet.OLEDB.4.0;DATASOURCE=" &
Server.MapPath("/WebApplication1/nathansokalski_com.mdb"))
Although the error does not occur until the Fill() method is called:

dataadapterSelect.Fill(ratedpoems, "poemratings")
I have a feeling the problem is in my connection string, but I do not know what the
problem is. The error returned when I try to view the page in my browser is:

[OleDbException (0x80004005): Could not find installable ISAM.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
WebApplication1.poetry.poemratings.SortPoems_Click (Object sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
Can someone please help me figure out what I am doing wrong or what my connection
string should look like? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/



Nov 21 '05 #3
When I ran the code you gave me, the account it returned was NJS\ASPNET,
which is what I expected, however, that account is not listed under the
Security tab for the mdb file or the directory that the mdb file is in (I
could not find the account listed for anything). I did notice, however, that
the following directory existed on my computer:

C:\Documents and Settings\NJS\ASPNET

How can I give the account the necessary permissions when it is not listed
under the Security tab? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:Os*************@TK2MSFTNGP10.phx.gbl...
Hi, Nathan.

Here's a short file you can use to determine
which account ASP.NET is running as :
-----------------
<%@ Page Language="VB" %>
<%@ Import NameSpace = System.Security.Principal %>
<script runat="server">
Sub Page_Load()
Dim tmp As String = WindowsIdentity.GetCurrent.Name()
Label1.Text = tmp
End Sub
</script>
<html>
<head>
<title>WindowsIdentity.GetCurrent.Name()</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" Runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
-------------

Run it, and it will tell you the name of the account you need to give
read/write
permissions to, for the directory where your mdb file is located, so it's
allowed
to read and write to the database.

Are you running a secured database ( username/password needed to read it
? )
Or just using the admin with no password ?

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:ux**************@TK2MSFTNGP10.phx.gbl...
Thank you for that information, it was definitely an error that would
have caused me problems. However, I am now recieving the following error:

[OleDbException (0x80004005): The Microsoft Jet database engine cannot
open the file
'c:\inetpub\wwwroot\WebApplication1\nathansokalski _com.mdb'. It is
already opened exclusively by another user, or you need permission to
view its data.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+36
WebApplication1.poetry.poemratings.SortPoems_Click (Object sender,
EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs
e) in c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

I know it is not opened by another user (including me, because this is
the first thing I did after booting my computer). I tried looking at the
security tab in the properties of nathansokalski_com.mdb, but the only 2
accounts there were mine and SYSTEM (it did not list others like Internet
Guest Account, Launch IIS Process Account, VS Developers, etc.). It is
listed in Visual Studio as part of the Application. What do I need to do
to either the file or my code to be able to use the database? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:eG**************@TK2MSFTNGP09.phx.gbl...
Try :

PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=

DATA SOURCE is 2 words, not one.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
I am trying to connect to a Microsoft Access Database from my ASP.NET
Application. I use the following code to create my connection string:

cmdSelect.Connection = New
System.Data.OleDb.OleDbConnection("PROVIDER=Micros oft.Jet.OLEDB.4.0;DATASOURCE="
& Server.MapPath("/WebApplication1/nathansokalski_com.mdb"))
Although the error does not occur until the Fill() method is called:

dataadapterSelect.Fill(ratedpoems, "poemratings")
I have a feeling the problem is in my connection string, but I do not
know what the problem is. The error returned when I try to view the
page in my browser is:

[OleDbException (0x80004005): Could not find installable ISAM.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable) +36
WebApplication1.poetry.poemratings.SortPoems_Click (Object sender,
EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs
e) in c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
Can someone please help me figure out what I am doing wrong or what my
connection string should look like? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/



Nov 21 '05 #4
Right click the folder for which you want to
grant permissions for, using Windows Explorer.

Select "Properties", and then click the "Security" tab.
Click "Add", and then click "Advanced".

Click "Find Now".
Scroll down to the "NJS\ASPNET" account

Assign read, change and write permissions to it.
OK your way out of the dialog.

I am assuming that NJS is the computer
where the nathansokalski_com.mdb is located.

Is that right ?


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:us**************@TK2MSFTNGP09.phx.gbl...
When I ran the code you gave me, the account it returned was NJS\ASPNET, which is what I
expected, however, that account is not listed under the Security tab for the mdb file or
the directory that the mdb file is in (I could not find the account listed for
anything). I did notice, however, that the following directory existed on my computer:

C:\Documents and Settings\NJS\ASPNET

How can I give the account the necessary permissions when it is not listed under the
Security tab? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:Os*************@TK2MSFTNGP10.phx.gbl...
Hi, Nathan.

Here's a short file you can use to determine
which account ASP.NET is running as :
-----------------
<%@ Page Language="VB" %>
<%@ Import NameSpace = System.Security.Principal %>
<script runat="server">
Sub Page_Load()
Dim tmp As String = WindowsIdentity.GetCurrent.Name()
Label1.Text = tmp
End Sub
</script>
<html>
<head>
<title>WindowsIdentity.GetCurrent.Name()</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" Runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
-------------

Run it, and it will tell you the name of the account you need to give read/write
permissions to, for the directory where your mdb file is located, so it's allowed
to read and write to the database.

Are you running a secured database ( username/password needed to read it ? )
Or just using the admin with no password ?

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:ux**************@TK2MSFTNGP10.phx.gbl...
Thank you for that information, it was definitely an error that would have caused me
problems. However, I am now recieving the following error:

[OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file
'c:\inetpub\wwwroot\WebApplication1\nathansokalski _com.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
WebApplication1.poetry.poemratings.SortPoems_Click (Object sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

I know it is not opened by another user (including me, because this is the first thing
I did after booting my computer). I tried looking at the security tab in the
properties of nathansokalski_com.mdb, but the only 2 accounts there were mine and
SYSTEM (it did not list others like Internet Guest Account, Launch IIS Process
Account, VS Developers, etc.). It is listed in Visual Studio as part of the
Application. What do I need to do to either the file or my code to be able to use the
database? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:eG**************@TK2MSFTNGP09.phx.gbl...
Try :

PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=

DATA SOURCE is 2 words, not one.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
>I am trying to connect to a Microsoft Access Database from my ASP.NET Application. I
>use the following code to create my connection string:
>
> cmdSelect.Connection = New
> System.Data.OleDb.OleDbConnection("PROVIDER=Micros oft.Jet.OLEDB.4.0;DATASOURCE=" &
> Server.MapPath("/WebApplication1/nathansokalski_com.mdb"))
>
>
> Although the error does not occur until the Fill() method is called:
>
> dataadapterSelect.Fill(ratedpoems, "poemratings")
>
>
> I have a feeling the problem is in my connection string, but I do not know what the
> problem is. The error returned when I try to view the page in my browser is:
>
> [OleDbException (0x80004005): Could not find installable ISAM.]
> System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
> System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
> System.Data.OleDb.OleDbConnection.Open() +203
> System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
> ConnectionState& originalState) +44
> System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord,
> Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
> +304
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32
> maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
> WebApplication1.poetry.poemratings.SortPoems_Click (Object sender, EventArgs e) in
> c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
> WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs e) in
> c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +750
>
>
> Can someone please help me figure out what I am doing wrong or what my connection
> string should look like? Thanks.
> --
> Nathan Sokalski
> nj********@hotmail.com
> http://www.nathansokalski.com/
>



Nov 21 '05 #5
On Tue, 7 Jun 2005 22:01:32 -0400, "Nathan Sokalski"
<nj********@hotmail.com> wrote:
When I ran the code you gave me, the account it returned was NJS\ASPNET,
which is what I expected, however, that account is not listed under the
Security tab for the mdb file or the directory that the mdb file is in (I
could not find the account listed for anything). I did notice, however, that
the following directory existed on my computer:

C:\Documents and Settings\NJS\ASPNET

How can I give the account the necessary permissions when it is not listed
under the Security tab? Thanks.


What operating system? Did you add the account?

Jeff

Nov 21 '05 #6
That is correct, NJS is the computer where nathansokalski_com.mdb is
located.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Right click the folder for which you want to
grant permissions for, using Windows Explorer.

Select "Properties", and then click the "Security" tab.
Click "Add", and then click "Advanced".

Click "Find Now".
Scroll down to the "NJS\ASPNET" account

Assign read, change and write permissions to it.
OK your way out of the dialog.

I am assuming that NJS is the computer
where the nathansokalski_com.mdb is located.

Is that right ?


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:us**************@TK2MSFTNGP09.phx.gbl...
When I ran the code you gave me, the account it returned was NJS\ASPNET,
which is what I expected, however, that account is not listed under the
Security tab for the mdb file or the directory that the mdb file is in (I
could not find the account listed for anything). I did notice, however,
that the following directory existed on my computer:

C:\Documents and Settings\NJS\ASPNET

How can I give the account the necessary permissions when it is not
listed under the Security tab? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:Os*************@TK2MSFTNGP10.phx.gbl...
Hi, Nathan.

Here's a short file you can use to determine
which account ASP.NET is running as :
-----------------
<%@ Page Language="VB" %>
<%@ Import NameSpace = System.Security.Principal %>
<script runat="server">
Sub Page_Load()
Dim tmp As String = WindowsIdentity.GetCurrent.Name()
Label1.Text = tmp
End Sub
</script>
<html>
<head>
<title>WindowsIdentity.GetCurrent.Name()</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" Runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
-------------

Run it, and it will tell you the name of the account you need to give
read/write
permissions to, for the directory where your mdb file is located, so
it's allowed
to read and write to the database.

Are you running a secured database ( username/password needed to read it
? )
Or just using the admin with no password ?

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:ux**************@TK2MSFTNGP10.phx.gbl...
Thank you for that information, it was definitely an error that would
have caused me problems. However, I am now recieving the following
error:

[OleDbException (0x80004005): The Microsoft Jet database engine cannot
open the file
'c:\inetpub\wwwroot\WebApplication1\nathansokalski _com.mdb'. It is
already opened exclusively by another user, or you need permission to
view its data.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable) +36
WebApplication1.poetry.poemratings.SortPoems_Click (Object sender,
EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs
e) in c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

I know it is not opened by another user (including me, because this is
the first thing I did after booting my computer). I tried looking at
the security tab in the properties of nathansokalski_com.mdb, but the
only 2 accounts there were mine and SYSTEM (it did not list others like
Internet Guest Account, Launch IIS Process Account, VS Developers,
etc.). It is listed in Visual Studio as part of the Application. What
do I need to do to either the file or my code to be able to use the
database? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:eG**************@TK2MSFTNGP09.phx.gbl...
> Try :
>
> PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=
>
> DATA SOURCE is 2 words, not one.
>
>
>
> Juan T. Llibre
> ASP.NET MVP
> http://asp.net.do/foros/
> Foros de ASP.NET en Español
> Ven, y hablemos de ASP.NET...
> ======================
>
> "Nathan Sokalski" <nj********@hotmail.com> wrote in message
> news:%2******************@TK2MSFTNGP15.phx.gbl...
>>I am trying to connect to a Microsoft Access Database from my ASP.NET
>>Application. I use the following code to create my connection string:
>>
>> cmdSelect.Connection = New
>> System.Data.OleDb.OleDbConnection("PROVIDER=Micros oft.Jet.OLEDB.4.0;DATASOURCE="
>> & Server.MapPath("/WebApplication1/nathansokalski_com.mdb"))
>>
>>
>> Although the error does not occur until the Fill() method is called:
>>
>> dataadapterSelect.Fill(ratedpoems, "poemratings")
>>
>>
>> I have a feeling the problem is in my connection string, but I do not
>> know what the problem is. The error returned when I try to view the
>> page in my browser is:
>>
>> [OleDbException (0x80004005): Could not find installable ISAM.]
>> System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
>> System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
>> System.Data.OleDb.OleDbConnection.Open() +203
>> System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection
>> connection, ConnectionState& originalState) +44
>> System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
>> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
>> CommandBehavior behavior) +304
>> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
>> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
>> CommandBehavior behavior) +77
>> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
>> srcTable) +36
>> WebApplication1.poetry.poemratings.SortPoems_Click (Object sender,
>> EventArgs e) in
>> c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
>> WebApplication1.poetry.poemratings.Page_Load(Objec t sender,
>> EventArgs e) in
>> c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
>> System.Web.UI.Control.OnLoad(EventArgs e) +67
>> System.Web.UI.Control.LoadRecursive() +35
>> System.Web.UI.Page.ProcessRequestMain() +750
>>
>>
>> Can someone please help me figure out what I am doing wrong or what
>> my connection string should look like? Thanks.
>> --
>> Nathan Sokalski
>> nj********@hotmail.com
>> http://www.nathansokalski.com/
>>
>
>



Nov 21 '05 #7
re:
That is correct, NJS is the computer where nathansokalski_com.mdb is located.
Then the procedure outlined for assigning permissions should work:

Right click the folder for which you want to
grant permissions for, using Windows Explorer.

Select "Properties", and then click the "Security" tab.
Click "Add", and then click "Advanced".

Click "Find Now".
Scroll down to the "NJS\ASPNET" account

Double-click the account to add it to the ACLs for the folder.

Assign read, change and write permissions to it. ( checkboxes )
OK your way out of the dialog.

Let us know if that works. It should.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:eq*************@TK2MSFTNGP15.phx.gbl... That is correct, NJS is the computer where nathansokalski_com.mdb is located.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Right click the folder for which you want to
grant permissions for, using Windows Explorer.

Select "Properties", and then click the "Security" tab.
Click "Add", and then click "Advanced".

Click "Find Now".
Scroll down to the "NJS\ASPNET" account

Assign read, change and write permissions to it.
OK your way out of the dialog.

I am assuming that NJS is the computer
where the nathansokalski_com.mdb is located.

Is that right ?


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:us**************@TK2MSFTNGP09.phx.gbl...
When I ran the code you gave me, the account it returned was NJS\ASPNET, which is what
I expected, however, that account is not listed under the Security tab for the mdb
file or the directory that the mdb file is in (I could not find the account listed for
anything). I did notice, however, that the following directory existed on my computer:

C:\Documents and Settings\NJS\ASPNET

How can I give the account the necessary permissions when it is not listed under the
Security tab? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:Os*************@TK2MSFTNGP10.phx.gbl...
Hi, Nathan.

Here's a short file you can use to determine
which account ASP.NET is running as :
-----------------
<%@ Page Language="VB" %>
<%@ Import NameSpace = System.Security.Principal %>
<script runat="server">
Sub Page_Load()
Dim tmp As String = WindowsIdentity.GetCurrent.Name()
Label1.Text = tmp
End Sub
</script>
<html>
<head>
<title>WindowsIdentity.GetCurrent.Name()</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" Runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
-------------

Run it, and it will tell you the name of the account you need to give read/write
permissions to, for the directory where your mdb file is located, so it's allowed
to read and write to the database.

Are you running a secured database ( username/password needed to read it ? )
Or just using the admin with no password ?

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:ux**************@TK2MSFTNGP10.phx.gbl...
> Thank you for that information, it was definitely an error that would have caused me
> problems. However, I am now recieving the following error:
>
> [OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file
> 'c:\inetpub\wwwroot\WebApplication1\nathansokalski _com.mdb'. It is already opened
> exclusively by another user, or you need permission to view its data.]
> System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
> System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
> System.Data.OleDb.OleDbConnection.Open() +203
> System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
> ConnectionState& originalState) +44
> System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord,
> Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
> +304
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32
> maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
> WebApplication1.poetry.poemratings.SortPoems_Click (Object sender, EventArgs e) in
> c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
> WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs e) in
> c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +750
>
> I know it is not opened by another user (including me, because this is the first
> thing I did after booting my computer). I tried looking at the security tab in the
> properties of nathansokalski_com.mdb, but the only 2 accounts there were mine and
> SYSTEM (it did not list others like Internet Guest Account, Launch IIS Process
> Account, VS Developers, etc.). It is listed in Visual Studio as part of the
> Application. What do I need to do to either the file or my code to be able to use
> the database? Thanks.
> --
> Nathan Sokalski
> nj********@hotmail.com
> http://www.nathansokalski.com/
>
> "Juan T. Llibre" <no***********@nowhere.com> wrote in message
> news:eG**************@TK2MSFTNGP09.phx.gbl...
>> Try :
>>
>> PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=
>>
>> DATA SOURCE is 2 words, not one.
>>
>>
>>
>> Juan T. Llibre
>> ASP.NET MVP
>> http://asp.net.do/foros/
>> Foros de ASP.NET en Español
>> Ven, y hablemos de ASP.NET...
>> ======================
>>
>> "Nathan Sokalski" <nj********@hotmail.com> wrote in message
>> news:%2******************@TK2MSFTNGP15.phx.gbl...
>>>I am trying to connect to a Microsoft Access Database from my ASP.NET Application.
>>>I use the following code to create my connection string:
>>>
>>> cmdSelect.Connection = New
>>> System.Data.OleDb.OleDbConnection("PROVIDER=Micros oft.Jet.OLEDB.4.0;DATASOURCE=" &
>>> Server.MapPath("/WebApplication1/nathansokalski_com.mdb"))
>>>
>>>
>>> Although the error does not occur until the Fill() method is called:
>>>
>>> dataadapterSelect.Fill(ratedpoems, "poemratings")
>>>
>>>
>>> I have a feeling the problem is in my connection string, but I do not know what
>>> the problem is. The error returned when I try to view the page in my browser is:
>>>
>>> [OleDbException (0x80004005): Could not find installable ISAM.]
>>> System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
>>> System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
>>> System.Data.OleDb.OleDbConnection.Open() +203
>>> System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
>>> ConnectionState& originalState) +44
>>> System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord,
>>> Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
>>> +304
>>> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32
>>> maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
>>> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
>>> WebApplication1.poetry.poemratings.SortPoems_Click (Object sender, EventArgs e)
>>> in c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
>>> WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs e) in
>>> c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42
>>> System.Web.UI.Control.OnLoad(EventArgs e) +67
>>> System.Web.UI.Control.LoadRecursive() +35
>>> System.Web.UI.Page.ProcessRequestMain() +750
>>>
>>>
>>> Can someone please help me figure out what I am doing wrong or what my connection
>>> string should look like? Thanks.
>>> --
>>> Nathan Sokalski
>>> nj********@hotmail.com
>>> http://www.nathansokalski.com/
>>>
>>
>>
>
>



Nov 21 '05 #8
Nathan,
when you select the security tab on the folder properties dialog, click on
the Locations button and select your computer. It should be at the top of
the list. After you do that, type in ASPNET in the textbox below that and
click the check Names button. It should find NJS\ASPNET.
Assuming you are using XP of course.

Steve

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:us**************@TK2MSFTNGP09.phx.gbl...
When I ran the code you gave me, the account it returned was NJS\ASPNET,
which is what I expected, however, that account is not listed under the
Security tab for the mdb file or the directory that the mdb file is in (I
could not find the account listed for anything). I did notice, however, that the following directory existed on my computer:

C:\Documents and Settings\NJS\ASPNET

How can I give the account the necessary permissions when it is not listed
under the Security tab? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:Os*************@TK2MSFTNGP10.phx.gbl...
Hi, Nathan.

Here's a short file you can use to determine
which account ASP.NET is running as :
-----------------
<%@ Page Language="VB" %>
<%@ Import NameSpace = System.Security.Principal %>
<script runat="server">
Sub Page_Load()
Dim tmp As String = WindowsIdentity.GetCurrent.Name()
Label1.Text = tmp
End Sub
</script>
<html>
<head>
<title>WindowsIdentity.GetCurrent.Name()</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" Runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
-------------

Run it, and it will tell you the name of the account you need to give
read/write
permissions to, for the directory where your mdb file is located, so it's allowed
to read and write to the database.

Are you running a secured database ( username/password needed to read it
? )
Or just using the admin with no password ?

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:ux**************@TK2MSFTNGP10.phx.gbl...
Thank you for that information, it was definitely an error that would
have caused me problems. However, I am now recieving the following error:
[OleDbException (0x80004005): The Microsoft Jet database engine cannot
open the file
'c:\inetpub\wwwroot\WebApplication1\nathansokalski _com.mdb'. It is
already opened exclusively by another user, or you need permission to
view its data.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
WebApplication1.poetry.poemratings.SortPoems_Click (Object sender,
EventArgs e) in
c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs
e) in c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42 System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

I know it is not opened by another user (including me, because this is
the first thing I did after booting my computer). I tried looking at the security tab in the properties of nathansokalski_com.mdb, but the only 2 accounts there were mine and SYSTEM (it did not list others like Internet Guest Account, Launch IIS Process Account, VS Developers, etc.). It is
listed in Visual Studio as part of the Application. What do I need to do to either the file or my code to be able to use the database? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:eG**************@TK2MSFTNGP09.phx.gbl...
Try :

PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=

DATA SOURCE is 2 words, not one.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Nathan Sokalski" <nj********@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
>I am trying to connect to a Microsoft Access Database from my ASP.NET
>Application. I use the following code to create my connection string:
>
> cmdSelect.Connection = New
> System.Data.OleDb.OleDbConnection("PROVIDER=Micros oft.Jet.OLEDB.4.0;DATASOUR
CE="> & Server.MapPath("/WebApplication1/nathansokalski_com.mdb"))
>
>
> Although the error does not occur until the Fill() method is called:
>
> dataadapterSelect.Fill(ratedpoems, "poemratings")
>
>
> I have a feeling the problem is in my connection string, but I do not
> know what the problem is. The error returned when I try to view the
> page in my browser is:
>
> [OleDbException (0x80004005): Could not find installable ISAM.]
> System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
> System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
> System.Data.OleDb.OleDbConnection.Open() +203
> System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,> ConnectionState& originalState) +44
> System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior) +304
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior) +77
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
> srcTable) +36
> WebApplication1.poetry.poemratings.SortPoems_Click (Object sender,
> EventArgs e) in
> c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:68
> WebApplication1.poetry.poemratings.Page_Load(Objec t sender, EventArgs> e) in c:\inetpub\wwwroot\WebApplication1\poetry\poemrati ngs.aspx.vb:42> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +750
>
>
> Can someone please help me figure out what I am doing wrong or what my> connection string should look like? Thanks.
> --
> Nathan Sokalski
> nj********@hotmail.com
> http://www.nathansokalski.com/
>



Nov 21 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Barb | last post by:
Hi there, I sincerely hope that someone out there can help. I have two instances of the SQL 2000 Desktop Engine running. One is on my local machine for development and the other is on another...
4
by: Dave | last post by:
Hey guys, I have an ODBC problem that has me stumped. I wrote a VBA script to run in Microsoft Excel that pulls data out of an application using that application's ODBC driver and puts it into...
1
by: Tom Wild | last post by:
Hi I am trying to create a webform that connects to an Access database. If I use the connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Gizmo\Gizmo.mdb" Then the application...
3
by: Jay | last post by:
Hello, I have Windows Forms application which uses MS Access Database and a Pocket PC application which uses Datasets, Iam trying to pass Datasets between these applications using WebServices. ...
12
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed...
14
by: Nick Gilbert | last post by:
Hi, I have an asp.net application which runs from a CD-ROM using Cassini. As such, it is single user only. The application connects to an Access database when it is loaded, and keeps the same...
1
by: Chris Love | last post by:
I have already asked this, but no one seems to know the answer. Here is the timeline. I wanted to use the membership/roles functionality in a site. I got all sorts of errors trying to get this...
2
by: shapper | last post by:
Hello, I added some profile properties to my web.config file. Then I started to use my profile properties in a page class and I get an error: An error has occurred while establishing a...
2
by: Patrick F | last post by:
Hi, i have SQL Server 2005 and a database set that is called, myCompany the problem is that i cant connect from my page to it, here is from the web.config: ( i have got this connectionstring from...
2
by: orandov | last post by:
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.