VB Forum / Database Access / November 2006

This is annoying. I'm trying to call a SP in a MySQL database that has one
INOUT parameter. Whatever I use to call it I get error: "OUT or INOUT
argument 1 is not a variable". I am calling with ODBC User DNS.
I've tried ADO, DAO and RDO, same thing in all.

I'm writing a program in VB to do some engineering analysis.  I have
two text files with nearly the same format, same columns and data
types, but different data.  For the sake of argument, let's call one of
the files A.csv and the other B.csv.

i'm new in vb, n got some problem in connect with sql
i use the following code but can't, have error!
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset

Hi, well I'm using VB and Access as the db. I have made a crosstab query in
Access and it's work well, but when I do the same in VB through ADO (not the
control) it doesn't work.
I've just copied the SQL sentence as appear in Access to VB as something like:

Well I have a Server which hold my Database and all the Tables, now I copied
the Database and all the tables in it to another Server lets say Server 2...
My task is to copy or to insert only the  wanted data to Server 2 not all
the original Data stored in Database.

I want to insert null value in MS Access, please help me i want to insert
null values in every fields ,
(text field,number field,date field etc), I am unable to do so please help me.

I'm looking for a very good book for an absolute beginner on
VB.net or VB 2005 with emphasis on databases. What would you
reccommend?
Thanks!

instead of using:-
get #filenum, posmarker, tmp
to read a byte of data,
is there a way to read a large chunk of data within a text or binary

Just found out I have a legit copy of VS 6 at work, so I'm trying to write a
program to do some data imports from a SQL Server 2000 datamart to a local
Access database.  Initial tests worked fine using a simpel query against the
SQL Server and writing to an Access table.

I am having a password protected excel file which have some data in it.
I trying to open the file through my VB 6.0 application using ADODB
connectivity method and i am passing the password in pwd parameter.
But i am getting an error messge saying ( -2147467259)

According to this document:
http://msdn2.microsoft.com/en-gb/library/ms526970.aspx
we should be able to set the charset to be used in the CDO message fields.
The following code does not work though (sorry about being in c#, I was

I have a very simple Access data base. No new info is going to be
added...the only changes are to existing fields. I have 2 tables both with
one row each. I'm using vb.net.
I can easily retrieve the data via "Reader"...but how to I update for changes?

I have a new installation of SQL Server 2005 Express. It's set up with
a couple of small databases that are maintained and used by some
custom-written VB6 programs.
From the computer where the VB programs have been developed,

I'm using the code below to import an Excel datasheet into an ado.net
table. The problem is, when I
get to the point where I want to iterate the recods, it always thinks
that there is 999 records in the table! If the table (worksheet) is

Is it possible to return a record where a value can match any of 10 columns
without nine OR's?
/Henning