473,324 Members | 2,239 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,324 software developers and data experts.

Newie needs data access

I was not sure which group deals with this is I apologize.
I need to connect to an MS Access DB and add. delete & update from an ASPX
page (using vb.net for code behind if needed)

Are there any sites that show code snippets ?
Both DSN & DSNless connections please

I can find them for ASP but none for aspx
Looks like aspx uses ado.net instead of ado & code is probably different if
only slightly (I don't know)

Thanks a lot in advance.
Nov 17 '05 #1
2 1114
Hi Ralf,

ASPX (that is, ASP .NET) pages indeed use ADO .NET. ADO .NET, in turn, can
talk to the Microsoft Jet OLEDB provider through its Managed OLEDB Provider
found in the System.Data.OleDB namespace. As far as I remember DSNs are
related to ODBC and ODBC is not a native way of working with MS Access
databases. So, you will be using OLEDB-compatible connection strings as if
you were working with the Jet OLEDB provider.

You can find information and examples on working with ADO .NET in the
"Accessing Data with ADO.NET" on the MSDN Library
(http://msdn.microsoft.com/library).

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"ralf" <--********@yahoo.com> wrote in message
news:bl************@ID-158805.news.uni-berlin.de...
I was not sure which group deals with this is I apologize.
I need to connect to an MS Access DB and add. delete & update from an ASPX
page (using vb.net for code behind if needed)

Are there any sites that show code snippets ?
Both DSN & DSNless connections please

I can find them for ASP but none for aspx
Looks like aspx uses ado.net instead of ado & code is probably different if only slightly (I don't know)

Thanks a lot in advance.


Nov 17 '05 #2

Thanks for posting but unfortunately I have no time to reinvent the wheel by
studying ado.net from scratch
I posted because someone may already have written the code that I can reuse
and that is what I am
looking for .
"Dmitriy Lapshin [C# / .NET MVP]" <x-****@no-spam-please.hotpop.com> wrote
in message news:et**************@TK2MSFTNGP11.phx.gbl...
Hi Ralf,

ASPX (that is, ASP .NET) pages indeed use ADO .NET. ADO .NET, in turn, can
talk to the Microsoft Jet OLEDB provider through its Managed OLEDB Provider found in the System.Data.OleDB namespace. As far as I remember DSNs are
related to ODBC and ODBC is not a native way of working with MS Access
databases. So, you will be using OLEDB-compatible connection strings as if
you were working with the Jet OLEDB provider.

You can find information and examples on working with ADO .NET in the
"Accessing Data with ADO.NET" on the MSDN Library
(http://msdn.microsoft.com/library).

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"ralf" <--********@yahoo.com> wrote in message
news:bl************@ID-158805.news.uni-berlin.de...
I was not sure which group deals with this is I apologize.
I need to connect to an MS Access DB and add. delete & update from an ASPX page (using vb.net for code behind if needed)

Are there any sites that show code snippets ?
Both DSN & DSNless connections please

I can find them for ASP but none for aspx
Looks like aspx uses ado.net instead of ado & code is probably different

if
only slightly (I don't know)

Thanks a lot in advance.

Nov 17 '05 #3

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

Similar topics

2
by: ralf | last post by:
I was not sure which group deals with this is I apologize. I need to connect to an MS Access DB and add. delete & update from an ASPX page (using vb.net for code behind if needed) Are there any...
4
by: Nemisis | last post by:
Hi everyone, I have 2 classes, Company and Contact, a company can have 1 or more contacts. A contact can only be in one company. I have created a Company class object that contains all the...
11
by: Jamie | last post by:
Greeting! I hope someone can shine a light on a problem I am having. I have 13 users on Access 2000 running FE from various PC and the BE on a new HP Server with Windows 2003, plenty of power...
7
by: Gary | last post by:
Hello guys! Bear with me, I am a newbie. She is the Data Warehouse manager. She has about 50 users to use the Oracle database from M$ Access via ODBC connection. All those users have only...
10
by: Les Desser | last post by:
In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Not sure if I quite follow that. 1....
4
by: xperre van wilrijk | last post by:
Hi, I have inherited an access userinterface that links to sql server tables through ODBC. The SQL server database contains data related to villages in my country and is populated by my...
2
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
4
by: Christopher | last post by:
I am surprised this hasn't come up for me more in the past, but the situation is: I need to have an interface that is usable for all I need to have an interface that is only usable for some I...
1
by: dkriese | last post by:
I am using Quickbooks reporting tool that can export an xls or csv file. The data being exported needs to create a classroom scheduler. The data being exported is from a sales receipt via QB and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.