VB Forum / Database Access / February 2004

I've got a VB6 project that works perfectly on any machine that has
visual studio 6.0 installed.  If I install and run the program on any
machine w/o visual studio installed all of my DBgrid's do not populate
at all. At first I thought this was a dll or service pack issue.  I've

I'm doing the following code, but it's not working:
Set cn = New ADODB.Connection
Set rst = New ADODB.Recordset
strExcelCn = "Provider=Microsoft.Jet.OLEDB.4.0;Data

I have a program written with VB.NET with Access X
I'm connecting to the DB like this
'----------------------------------------
REM the sDsnName is the "System DSN" name

I wrote a 3 tier application using vb6 as the front end, a vb6 ActiveX
dll as the middle tier and SQL 7 as the back end.  There are about 300
to 400 Stored Procedures which produce the DB updates and give me a thin
client.  The application has been running for about a year without ...

1 of the fields in record is date/time field. What I want to do is to filter
ado recordset, so i only have records with complete day. In SQL in would be:
"Select * where myDate Like '**/**/**** **:**:**'" Unfortunately it doesn't
work with ado filter. What i am doing wrong?

Just would like to double check (Don't have the time to test.)
If I do: Set rst2 = rst1.Clone
If I change rst2 does it in any way affect rst1?
Francois

I'm writing code for an Excel 2000 AddIn using Microsoft ActiveX Data
Objects 2.5 Library under Win 2K. I can open an ADODB.Connection, set it to
be the ActiveConnection for an ADODB.Recordset, and then call the Open
method of the Recordset object, passing it a SQL string. So far so ...

Kevin,
I've tried many different ways of implementing the sub query to the seperate
database and have drawn a blank.  The articles you referenced are for an
external Excel spreadsheet.  I've tried to incorporate some of the

I am using DAO  (in a Jet Wrokspace) to access a Microsoft SQL Server
database via ODBC.
But whenever I execute  a query from my code to create a temporary table in
the database, DAO returns back an error, even when I use the 'sa' account to

I have a FoxPro 2.6 table I query and I want to loop through the records and
synchronize it with another database. Everything works fine until I try to
move to the first record. When I do that I get an error. The error is "Data
provider or other service returned an E_FAIL status" ...

MSDE-centric VB 6 application (actually version of full blown Sql2K app)
having issues running on Windows XP service pack 1. Specifically:
Dim cn as adodb.connection
set cn = new adodb.connection

I have this challenge.  This following code snip generates and writes a list
of dealers that meet a use-entered distance criteria according to
user-entered zip code location.
It's performing fine, EXCEPT...  I need the results sorted by distance,

I am struggeling to use an excel workbook as "database". Reading
(SELECTs) with vb and dao runs fine, but I could not write anything so
far.
I also tried to update with ado, but I was confused by the driver

I'm trying to update all connections in all dts packages on the server if the specified value is found in the connection data source.  The code seems to work fine  as in there are no unexpected errors or halts except that the change doesn't actually occur.  After the script runs ...

CCyy-mm-dd is written to MS-Access database as CCdd_mm_yy (where CC represents the century).  This only occurs at two sites out of 50 sites. Regional setting is English(Canada).   Any ideas?