Dear Authorities:
Could you please tell me how to get a list of all ADO Providers on a client
machine (without using the DataLink).  I would assume they are within the
Registry but I don't know where to look.

while trying to load excel file with oledb connection, it seem to turn integer values in string fields into DbNull, i also tried copy & paste with the clipboard and the CSV but i cant find any tool that would parse the data back into a dataset / table
is there a solution out there ...

I create oledbcommand to query Access database e.g. (select
accno,accname,email from account ...). If I use ExecuteScaler, I get only
accno. If I use ExecuteNonQuery, it does not work. Of course, I can use
ExecuteReader. But, can I do with ExecuteNonQuery?

I have a delete statement that when run from Query Analyzer takes about 45
minutes to complete.  When I put that statement into a dataAdapter and
execute with an ExecuteNonQuery, it gets a timeout after a few seconds.  How
can I keep this long running process from getting a timeout? ...

I have a dataset with one table and I want to find a specific row # or index
in that table where one of the columns (which contains a unique value) is
equal to a value I pass.
Any help?

Is ADO .NET performance adequate for processing large volumes of data?
For example, say you have a 500,000 customers with 700,000 orders a
month.  You want to identify trends over one year, so you need to scan
over those 500,000 customers and 12 x 700,000 orders.  During the

we run oracle here and i need the oracle component, so that I can use the oracleclient namespace. any ideas where it is ?

I have a temporary table which contains around 2.7 million records. I am iterating through these records in a WHILE Loop and performing certain business rules on these records. Within the loop too i am using a large number of temporary tables.
This entire processing is being done ...

When displaying data from the database, very often the field names are not
suitable so custom headings have to be created,  For example, the column
storing zip code may be named zip, but when displayed, it may need to be
displayed as "Zip", "Postal Code", "Zip/Postal Code" etc.  ...

I need to raise a customized error message from a stored procedure in
Oracle 8i and catch this error in my Try...Catches in VB.NET. Can
anyone point me to an article or something that teaches how to do it?
OTN site is terrible to find anything!!!

I have been asked to write a program and allow the end user to create
custom fields in a SQL Server database in addition to the premade
fields.
I understand how to add the column, the data type and such.

I'm trying to work my way through this book, but keep having trouble
with the example programs.
The trouble is my version of Northwind seems to have a similar, but
different schema to that used for the examples.

ExecuteScalar is great - it returns the first field of the first row.
Is there a command that returns just the return value from the stored
proc?  I can't seem to find it.
Thanks

I am looking for a tool that will connect to the database and script the
entire thing out (i.e. tables structured, stored procs, views, etc...
including the data in the tables) to a file.
I would then run this script elsewhere to restore the database.  I'd

I am using a DataRowView object that contains exactly one row.  Here's my
code:
Dim dv as New DataView(ds.Tables(0), "City = 'Hammond'", "",
DataViewRowState.CurrentRows)