VB Forum / Database Access / April 2005

I have an app written in VB6 that manages data exchange between 3 different
applications, each of which uses a different DB format.  Briefly:
1.  Data entry is done using an ancient DOS app called DataEase.  DataEase
will not directly interact with any modern db, but it can export ...

I have built a VB app that interacts with an MSAccess97 database
via DAO. The app basically goes through a specified folder and saves
a bunch of file info to the database. My question is this:
What would be more efficient..

Dear experts,
How can I change a column width in a Datagrid (VB.Net) ???
Thanks for your answer!

Please HELP!  I am a total beginner. I have a web application that queries a
sql database and then returns only on row to a dataset.  This row is then
manipulated for an indeterminate amount of time. (this is a work order app)
so I chose to use the dataset to accomplish this.  ...

I'm getting ADO connection errors when I attempt to connect to a SQLServer
2000 DB.  I'm using VB6 & ADO 2.8.
My connection is as follows:
 Set oCN = New ADODB.Connection

i am a VB6 programmer who likes to use DAO! Don't laugh!!!!!
I've been talking to a potential customer who needs me to be able to
link into their existing data. This data is an Oracle database.
However, it is a system critical database and as such they are not

hi, can i do this in ado:
dim rs
dim sql
sql = "SET nocount on "

I want to connect to an Access DB using a DAO connect string that uses a
system file (.mdw).
I have not found any connect string that will do this. I have seen one where
you can enter a password - but I am assuming this is a database password as

Below is my scipt: It asks for a two sets of date ranges, both from
column J, and then it does the rest.
Script works, no problem..
After the two sets of dates are entered for the range of column J, it

I used the following code to copy some records from one MDB file to another

strDst = "C:\Folder\accessfile.mdb"
Set cnnSrc = New ADODB.Connection

I am using vb6 connect to SQL Server,
I hv a query that filter records by date field (the input is by user
using dtpPicker with "dd/MM/yyyy" format)
This is how i write in vb6:

From:     Jacob Nichols via .NET 247 <anonymous@dotnet247.com>
Subject: Update fails with System.NullReferenceException
Newsgroups: microsoft.public.dotnet.datatools
Date: Mon, 07 Mar 2005 11:15:12 -0800

Hi, newbee question.
What software would be best for the following situation?
Web enabled database with an SQL back-end over a Windows based intranet
network system.

I want to use ADO Connection transactions from a VB 6 Middle-Tier to SQL
Server 2000, but I don't understand how transactions are managed relative to
connection pooling.
I have 4 Web server boxes hitting the VB Middle-tier via COM+/DCOM on a

I have this code that is returning run-time error 7004. The rowset is not
bookmarkable.
Cn.CursorLocation = adUseServer
  Set iWebOrdLookup.ActiveConnection = Cn