I have a table in Oracle that I want to transfer directly to SQL.  What's
the best way of doing this?  I don't really want to use a DTS package, and
would rather use ADO.net.

I am creating a ODBC Connection to the SQL Server and I want the listing of
tables and columns.
How can I acheive this? I dont want to use a OLEDB Connection,
Regards,

VB.NET 2003
Windows App
SQL 2k Backend
Typed DataSet

I'm used to work with SQL Server. Now I have to connect to Oracle, and
it went all well so far, but...
We have a table with a field containing the euro-sign (charactercode
128 from codepage 1252).

using enterprise services from dot-net:
on windows application it did OK.
on ASP.NET i get the folowing error. (see in the end)
Access to the registry key HKEY_CLASSES_ROOT\EntSrvcTest1_direct.Global is

I have an ASP page that has an aspx page within an iFram on this asp
page. Once the user has filled in the form (within the aspx page) I
need to redirect the user back to the orginating page (an asp page)
within the iframe.

I currently have 3 servers, a dev server running
Server 1
.Net framework version 1.1
Win 2k3 standard edtion

my class is in enterprise services and "supports" transactions , but i want
that certain function will use transaction.
if there is no transaction - open a new one, and if there is - use the
current.

Is it possible to have a dropdown box in a datagrid record in the same way
you can have it in an Access table?
E.g.: When I populate my child table, I have a field which lookup a value in
the parent table. Access allow this and makes it easy to ensure that the user

Hi;
We have a case where it is virtually impossible to know when to close a
connection because we may be about to make another query. So...
1) By any chance does SqlConnection implement pooling under the covers so

Every table in my db has these 3 fields: Created, Modified, and
Expired.
3 of my tables are Person, Business, and Employment.
So Person.Created and Person.Expired store when a person is born and

In VB .NET 1.1 I have created an oledbcommand object that queries the
xp_cmdshell in the Master database.  This part works fine.  But when I try
to access the Return_Value parameter's value there is nothing there.
IsNothing() returns True; IsDBNull() returns False.  Shouldn't the ...

This is my code I am using (see bottom for my questions)
Public Sub SendAllSMS()
Dim myODBC As New clsODBCDataSMSVers
Dim ds As New Data.DataSet

How do you check if a value returned by a DataReader is null or not?
For instance, here's what I wish to check:
If Not Reader.HasRows Then
               mPreviousArchivalDate = Nothing

I'm trying to use a typed dataset and ObjectDataSource binding to a SQLX db
using a foreign key to filter the returned result set to display in a
GridView.
The error message in the subject line is generated when I try to bind the