Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 18th, 2005, 12:41 AM
Authorized User
 
Join Date: Aug 2003
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default OLEDB and ODBC in a page !?

Hi all,

Could I use OLEDB and ODBC in a page ASPX !??

For example :
- Function 1: I use OLEDB to get data from a Excel file.

- Function 2: Use ODBC to insert data what I got to database mySQL.

Is my way wrong !?!

Please help me.
Thank you very much.

L.V.L
__________________
L.V.L
 
Old January 27th, 2005, 09:19 AM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Not at all. You can even create a single data adapter that has a select query going to one database (OleDb) and an update/insert/delete going to another. Each Command object that defines each operation (insert/select/update/delete) has its own connection property and this can be any type of connection.

-Peter
 
Old January 28th, 2005, 09:16 PM
Authorized User
 
Join Date: Aug 2003
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you very much. I have way to solve this problem.


L.V.L





Similar Threads
Thread Thread Starter Forum Replies Last Post
Error with ASP.NET opening OleDb/ODBC database gdelia1 ADO.NET 6 October 5th, 2005 01:50 AM
oledb or odbc? rupen Classic ASP Databases 2 September 28th, 2005 01:58 AM
OleDb.Net vs. ODBC.Net for Connecting to Oracle cjo ASP.NET 1.0 and 1.1 Professional 3 January 13th, 2004 07:18 PM
OleDb.Net vs. ODBC.Net for Connecting to Oracle cjo ASP.NET 1.0 and 1.1 Basics 1 December 23rd, 2003 10:56 AM
Which is preferred, ODBC or OLEDB? uit SQL Server ASP 2 December 3rd, 2003 05:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.