VB Forum / Database Access / September 2005

If I am querying a SQLServer database I normally use a connection string
based on the following:
Provider=SQLOLEDB;Password=****;Persist Security Info=True;User ID=**;Data
Source=*******;Initial Catalog=*****

On my server machine, I have number of DSN's i.e. for Access, SQL Server,
Sybase, Oracle, Excel etc. I want to write a generic COM method using ADO by
which I can retrive the columns for a particur table for a selected DSN.
Thanks

At present I am in the process of developing an application in VB6 that is
going to need to store and retrieve data from a database.
My problem is how to do it? The database application I am planning to use
will be Access. The problem is that on the machines that will be running ...

I made small app, which have to get data from FoxPro 2.6 table(dbf),
and export it to Excel worksheet. I wrote code to connect:
Dim cnn As New adodb.Connection
Dim rs As New adodb.Recordset

VB6, SP6 - using an ODBC driver for dbase tables, clientside cursor
I have an application that gives a ' 2147217887 - Multistep operation
generated errors' error. This does not seem to have any hard cause and the
offending operation can be repeated without problems. The problem ...

if i have a DB that havent normalize yet, like below:
OrderNo    PartsNo    Model    Speed
00001        00001       P4          2800
00001        00002       P4          2800

if have following:
SELECT id, date FROM resorts WHERE date BETWEEN day1 AND day2
within Access -> query everything works, but as soon as I put code in VB, and error occures.
day1 and day are public as date.

Here is another newbie question, but this one is driving me crazy.
I am inserting and updating records in a DataSet, which show up in a bound
DataGrid just fine. I am also issuing a DataAdapter.Update command, and the
updates are saved to the database but the inserts are not. As ...

Couple posts below, someone suggested that I should use the OLEDB driver for
JET instead of the ODBC driver becasue the ODBC driver for JET was buggy.
So, I changed the connection to use the OLEDB drvier for JET.  However, many
of my SQL did not work anymore.  Hours later, I ...

I have one out of 15 users suddenly getting error 48 - "error loading
dll" in one section of a VB6/ADO/Jet app.  MDAC component checker
results include the following "mismatch" listing:
- <group name="MISMATCH" count="1">

after i set the password for MS Access DB, i modify the vb connection string
from
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " & App.Path &
"\OrderListDBv2.mdb"

VB6, SP6 - using an ODBC driver for dbase tables, clientside cursor
I have an application that gives a ' 2147217887 - Multistep operation
generated errors' error. This does not seem to have any hard cause and the
offending operation can be repeated without problems. The problem ...

How can I find the number of records returned when using a command object?
With adoconn
   .ConnectionString = AS400CONN
   .Open

I've seen some threads that deal with Bitmaps, but what I want to do is:
Set a field in an Access database for OLE Object
Programmatically load and retrieve Word documents to/from this field
I'm using VB6 and Access 2000 - not against moving up to Access 2003 if I

Can someone tell me, how to do this:
Creating Access database and table in it and moving record by record
is slow and Select Into crashes my computer.
I can't use DTS, because I use MSDE 2000