VB Forum / Database Access / January 2005

I am writing a VB.NET 2003 web application to operate on my company's
intranet. It accesses data in an SQL Server database. I have developed a
couple of pages that display data successfully. However, there is one area
that I am having trouble getting a handle on, despite ...

           If  IsNull(rs3.Fields("middlename")) Then
              strTmpMName = "-"
           End If
           Debug.Print rs3.Fields("middlename")

I need to insert a large amount of data in MS-SQL Server. The input file is
a CSV file. The programming language is VB6. The application needs installed
on a client station (the server on the same network). Is there a function
that can help me achieve it?

I want to run a parameterized query that is reusing the same parameter more
than once; i.e.
select * from table1 where isnull(col1,@parm1) = @parm1
Is there a way to execute such command from ADO without using a stored

I'm going mad.
I've added a counter in a table of my db.
Now I want my string connection open the db and get the record that has the
counter number that i've selected in a listview

Using vb6/ado 2.6/access 2000 mdb.
After opening a connection and a table-type recordset none of the properties
seem to be initialized.  e.g. .bof and .eof are False; .State returns
adStateOpen, .AbsolutePosition returns -1, .Recordcount returns 0 (I know

how complicatd is to leave RDO and switch to ADO?
how would this code look if ADO is used?
    Dim cnMySql As New rdoConnection
    Dim rdoQry As New rdoQuery

Hi all -
I am developing a MDI windows app that uses MSDE as it's data-store.  I am
coding some simple maintenance procedures (pickable as a menu item from the
parent form), such as backup database, delete old records, and restore

I have a list box on a form with a list of jobs. To edit a job I double
click on the selected job and a form comes up which all the job details.
I have a combo box on the Job Details form which I populate at form load()
with the list of clients from a table. I add the Client_ID ...

I have to store word documents, excel spreadsheets, text documents ... in a
sql server database (SQL2000).
I have to use VB.net to solve this problem but I really don't know where to
start.

I don't know why this confuses me so much. I try to use the help files
and MSDN documentation and Google. I just can't seem to bring it
together properly.
Could someone please create a new Standard exe project and drop only:

I am populating a combo box with data from a database; when you delete
one of the items out of the database in the application's run time it
is removed from the database but still appears in the field list. Once
I restart the application the field list changes have been made, how

I know that:
Changes you make to one Recordset object are visible in all of its clones.
How about the other way around:
Will changes in a cloned RS be updated in the database?.

Hello  All,
I have two Queries. I am developing a samll application to be used for
dataentry .
The dataentry will be used by multiple users. Each user will be adding about

I'm going mad.
I've added a counter in a table of my db.
Now I want my string connection open the db and get the record that have the
counter number that i've selected in a listview