Re: Inserting into a SQL database - any provider
- From: "Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx>
- Date: Mon, 13 Mar 2006 20:41:46 +0100
David,
Another post here (somewhere) said that the MySqlClient (not using
OleDbClient) does not support the ProviderFactory. If that's true it blows
this whole approach as the big 4 among our customers are Oracle, MySql,
Sql
Server, and DB2 (in that order).
I think we need to experiment here with the other three databases and see
what works. I have a bad feeling we are going to have to write our own
layer
to create a common API.
I think you are right, I saw something on Google by the way with MySQL and
DBProviderFactory.
Cor
"David Thielen" <thielen@xxxxxxxxxxxxx> schreef in bericht
news:E1EB7D3A-360D-4A8B-9BD0-4CC64055E19B@xxxxxxxxxxxxxxxx
Hi;
Another post here (somewhere) said that the MySqlClient (not using
OleDbClient) does not support the ProviderFactory. If that's true it blows
this whole approach as the big 4 among our customers are Oracle, MySql,
Sql
Server, and DB2 (in that order).
I think we need to experiment here with the other three databases and see
what works. I have a bad feeling we are going to have to write our own
layer
to create a common API.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
"Cor Ligthert [MVP]" wrote:
David,
I have no Oracle database to test and all our samples are tested.
http://msdn2.microsoft.com/en-us/library/system.data.common.dbproviderfactory(VS.80).aspx
It should work as well as ODBC (the class description is not wide, but it
is
in it).
Cor
.
- References:
- Re: Inserting into a SQL database - any provider
- From: Cor Ligthert [MVP]
- Re: Inserting into a SQL database - any provider
- From: Cor Ligthert [MVP]
- Re: Inserting into a SQL database - any provider
- Prev by Date: Re: DataAccessApplicationBlock without stored procedures?
- Next by Date: Re: databinding problem
- Previous by thread: Re: Inserting into a SQL database - any provider
- Next by thread: Re: Inserting into a SQL database - any provider
- Index(es):
Relevant Pages
|
