Hi;
SQLDMO gives you a way to enumerate all SqlServer databases on the network
and for a given server, all databases on that server.
Is there a way to do this for Oracle?

I am creating datasets that I use to creat reports (using Crystal).  I have
been creating a dataset, then do the writexml, which I then use as the
basis for report creation.  
If I use the xml file, I can preview the data in Crystal, but it does not

I have a windows service that will insert records into an Access database.  Or at least that's the idea.  The insert isn't happening, but the code runs without raising any errors.  When I run the generated sql statement from a query window in Access, the record inserts just fine. ...

I am executing a query as below;
Dim insStr As String = "INSERT INTO MyTable1 ( field1, field2, ...) ) " & _
                                  "SELECT MyTable.f1, MyTable.f2,  " & _
                                  "FROM MyTable "

I have a typed DataSet that contains approximately eight DataTables with
foreign key relationships that I am returning from a ASMX web service to a
Winforms application.  The rows of a few particular tables don't seem to be
making it across the wire.

I hope some one can help me with this.
I have been trying for ages to update a disconnected dataset and then write
the changes back to the SQL database.  However when I make changes to the
relivant fields it updates the datagrid but does not write the edits back to

I created an untyped dataset using the tables collection editor and
the columns collection editor.
The table was the employee table from the pubs database which has the
following eight (8) fields

Hi, friends,
In a VC# app, I have a DataGrid with DataTable as its SourceData. This
DataTable has a ColumnStyle collection for each field. In Form_Load event, I
set

I am going to select buch of rows from database and update a field in them
,is there a good way of doing that ?
thanks for your help.
Ali-R

I am developing a multi-thread app.
In this, each thread must take a number from a table and then update
table with the number + 1. This number is to insert in other table by
primary key. My problem is while I select number and update number,

I'm trying to open a connection to a SQL Server DB in C# (so that I can
later execute a stored procedure).  The code I have included below produces
the following exception when "connection.Open()" is executed:
   Unknown ProviderConnection string is not valid

Hi all, I have a web service that opens a sqlconnection to the db and does
some work. The other day for the first time for about 30 mins I started
getting the following error message:
Timeout expired.The timeout period elapsed prior to obtaining a connection

Can I use ADO.NET to connect to a mdb database?  I have not been able to find
anything on this.
Also, I am trying to use ADO in VB.NET and for some reason I can't seem to
get a command to work.

Sorry, but I didn't find a group for SQL questions. May be someone can
answer here.
In my app I want to reflect a hirarchy in a tree view. Therefore in the
database I have a table like this:

I want to use the parameters call like this:
cmd.Parameters.Add(new OracleParameter("arg_username"), OracleType.VarChar,
strName, ParameterDirection.Input ));
but the Microsoft OracleClient driver does not allow the above syntax, I