VB Forum / Database Access / February 2005

Could anybody supply me with the correct SQL statement to load a .csv file
into a SQL Server 2000 table.  I am hoping to run this statement from a VB6
application, thanks.
Alex

Hi people,
   I have a vb 6 aplication and i work with ado. I am interesting to
improve the application, with ado connections.
Do you know some link, pdf or book that help me?

I'm trying to figure out why an older VB6 application will not run on a new
Windows 2003 server. When the EXE is run, the application crashes without an
error message. The Application event log reports a vague Event ID 1000,
mentioning NTDLL.DLL.

i want to open a word file in my c drive. how do i do that in VB? i want to
open it when i click a button.
thanx
devin

I have a form with a tab control on it. When the user changes from one tab to
the next, I want be able to check and see if there are any changes on that
tab and prompt them to save or cancel.
Each tab contains data from different tables, all in the same dataset. All

Given the following string:
sql = "SELECT * " & _
         "FROM Pop3LocalMailBox AS T1 " & _
         "INNER JOIN TMP_EmailB AS T2 " & _

I want a combo box to auto-complete.  As the user types, if they only know
the first few letters, when they have typed what they know, I'd like the
combo box to drop down and show the content relevent to what they have typed
(similar to Windows Help Index boxes). Can it be done ...

This is such a basic question, but I can't find an answer.
I have a function in a class module that finds data from a series of
database tables. The data, when found, is placed into a new recordset within
the function. All OK here.

I want to do a batch query reading the criteria from a text file.  The query
should return in one recordset, and the result will be saved in another text
file.  I'm using array to read the input file, but it returns in more then
one recordsets... then the output file turns out ...

I've created an ADO recordset,at run-time, to hold VAccess configuration
settings.  I step through the values and update them after each loop.
All works well until I try to update a sort order value using a loop
statement in another function used after the initial loading of the ...

I have a number of applications that I have written in VB6 connecting to SQL
2000 or MSDE 2000 servers and all at one point or another seem to exhibit the
same issue.  My problem used to only occur at a few locations where the
application needed to run on a box other than the SQL ...

Hello, I am updating some SQL Server statements to Oracle and I've done
this task about 6 years ago.  I'm sure that I used a function inside
the SQL statement either called {TS} or {D} and this meant that the ADO
subsystem converted the date syntax for me - and hence one statement.

My environment: WIN XP SP2, VB6 SP5, MS ADO 2.5, Oracle 9.i, MS ODBC
for Oracle 2.575
I have a VB application in which I connect to a Oracle database via
ADO and ODBC. I used to use the ODBC driver from Oracle, but for some

I try to use dataenv object. I add new connection (jet 3.51 provider with
Biblio example) and then add command (all use server side cursor) and then
drag command in to Form .
However, when I run the project (vb6 sp5 WinXP sp1), I got nothing in the

I have a very simple xml file test.xml, which looks as following:
<?xml version="1.0" encoding="UTF-8"?>
<PDCdrom >
   <CheckItem></CheckItem>