Ask a Question related to ASP.NET General, Design and Development.
-
Me #1
Microsoft Access with ASP.net
Is it possible to use ASP.net with Microsoft Access. From
what I can find ASP.net only works with SQL server.
That's kind of step backward from being able to access
any data source.
Me Guest
-
[microsoft][odbc microsoft access driver] syntax error (missing operator) in query expression error
I have a query I want to run using DBQwiksite siftware, which produces the syntax error (missing operator) in query expression error when... -
[Microsoft][ODBC Microsoft Access Driver] Could not start session.
Does anyone know what this problem means??? Microsoft OLE DB Provider for ODBC Drivers error '80004005' Could not start session. ... -
[Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error
This is probably an old problem that most of you know how to fix (I hope!). The scenario is that I have a web server running an ASP site that needs... -
ASP Microsoft Access
I am writing an sites for mulitple languages, even though in the script I tell the encoding type to be for the language in Microsoft Access it... -
Microsoft Access
go to webthang.co.uk, look in thier tutorial. good luck cheers vivian "Jonathan Fagan" <webforumsuser@macromedia.com> wrote in message... -
dot365 #2
Re: Microsoft Access with ASP.net
Yes, you can use Access with ASP.net.
Instead of the Sql objects, you can use the Oledb objects.
"Me" <me@me.com> wrote in message
news:00d301c33c13$6e1d3940$a601280a@phx.gbl...> Is it possible to use ASP.net with Microsoft Access. From
> what I can find ASP.net only works with SQL server.
> That's kind of step backward from being able to access
> any data source.
dot365 Guest
-
Me #3
Re: Microsoft Access with ASP.net
I'm new at ASP.net. I was playing with a dat grid but
could not figure out how to point it to an Access
database. I probably need to read more.
Thanks
objects.>-----Original Message-----
>Yes, you can use Access with ASP.net.
>
>Instead of the Sql objects, you can use the OledbFrom>
>
>"Me" <me@me.com> wrote in message
>news:00d301c33c13$6e1d3940$a601280a@phx.gbl...>> Is it possible to use ASP.net with Microsoft Access.>>> what I can find ASP.net only works with SQL server.
>> That's kind of step backward from being able to access
>> any data source.
>
>.
>Me Guest
-
Leif #4
Microsoft Access with ASP.net
I used this simple aspx page to get a used to interaction
with a Access database.
Hope it helps,
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
//ESTABLISH AND OPEN CONNECTION WITH Selection.mdb
string strConnection
= "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=C:DB\Northwind.mdb";
OleDbConnection objConnection;
objConnection = new OleDbConnection(strConnection);
try
{
objConnection.Open();
con_open.Text="Connection opened
successfully.<br />";
objConnection.Close();
con_close.Text="Connection closed.<br />";
}
catch (Exception e)
{
con_open.Text="Connection failed to open.<br />";
con_close.Text=e.ToString();
}
}
</script>
<html>
<body>
<h4>Testing the data connection
<asp:label id="data_src" runat="server"/></h4>
<asp:label id="con_open" runat="server"/><br />
<asp:label id="con_close" runat="server"/><br />
</body>
</html>
>-----Original Message-----
>Is it possible to use ASP.net with Microsoft Access. From
>what I can find ASP.net only works with SQL server.
>That's kind of step backward from being able to access
>any data source.
>.
>Leif Guest



Reply With Quote

