I have some VS 2005 VB.NET code that uses the writeToServer method of a
sqlBulkCopy object to write records in a dataTable to the SQL server.
The code works fine against our SQL Server 2000 database, but we get a
'login failed' error against 2005.

I just started doing some basic exercises with Visual Basic 2008 Express
Edition (Version 9.0.21022.8 RTM, Microsoft .NET Framework Version 3.5) and I
do not seem to have what I would call routine data drivers installed.  
Initially, I only want to connect to a Northwinds db in my ...

I have writing easy to moderate SQL in the DataSet Designer and Query
Builder, using a Jet 4.0 connection to an Access 2003 DB. I am running
VB.NET 2005 sp1.
As soon as I try to do anything more than the most trivial SQL (e.g. simple

is there are ready component (maybe an data adapter) existing which has
advanced features like paging (with server cursors) but still allows
merging?
Thank you,

Anyone,
I'm looking for a way to load flat files into a datatable in vb.net (2005)
My flat files are tabbed delimited files with the field names on the first row
I could dump the data into a sqlserver via DTS and then query against a

My vb.net seems to be slow on initial loading. My clients are not impressed
as they had used the ms access version of the app previously and think that
the old app is faster in loading. I understand .net apps need to compile
themselves before execution. Is there any way I can ...

What's the best way to import all the tables (w/data) from an SQL Server
database (in production) to my SQL Express database (on my local dev
machine)?

Is there a way to disable EnforceConstraints on a dataset? I have this
statement ds.EnforceConstraints = true in MyDataSet.Designer.vb but I am
reluctant to set it to false as the designer may overwrite the code.
I only wish to do it temporarily to speed up fill operations.

In my language, Italian language, we have words with accent, for example
"città" or "perchè"; can I create tables or columns in sql server with
names that contain letters with the accent (i.e. "à" "è" "ì" "ò" "ù")?
Is this absolutely not recommended? Or is it an acceptable ...

I've a method in my web service..which makes a call to db
and sends back a dataset..
the query takes 2 mins to fetch the results..by that time i'm seeing a
'operation has timed out error' on my screen..

I am trying to take a very strangely delimited text file and put it into
access.  So far I was able to get the text file into a dataset and figured
from there I could get it into access.  I am trying to use the code below but
the insert query(oledbcommandbuilder) just will not ...

Hello. Using XP Pro w/SP4 and VS 2003. I wrote my program with the
connection string and the path for loading the Maps as follows:
C:\MVB.NDbProJim\Ch7\ROE6AllRecords2\Maps. The Maps sub-directory containes
all 116 Maps of the Lots and also the ROE6.mdb database. But when I deplay ...

The following code would fail, with the error:
     "The '' string cannot be converted to the double type."
when trainTable contains rows with DBNull in some of the columns.
How can I pass NULL to MSAS?

I am running an Update routine that calls a function.  It appears that the
function never executes because I receive:
Must Declare The Scalar Variable @Country.  
Code:

System.Data.Odbc.OdbcConnection conn = new
System.Data.Odbc.OdbcConnection(@"Driver={Microsoft Access
Driver(*.mdb)};Dbq=C:\abc.mdb;Uid=Admin;Pwd=");
when invoke conn.Open(); the program throw an OdbcException