VB Forum / Database Access / September 2006

I know there's the cancel method for connections and recordsets but I can't
find an example in VBA only C++.  I want to give my users the ability to
cancel a SQL query on demand.
cheers,

I have an application that uses a secure SQL Server Database with a
UserID/Password that is different from the NT (XP) Workstation
Login/Password on the Domain.  The SQL Server is setup for NT
Authentication Only.  Simply stated, I need the APPLICATION to login

CursorLocation, Connection Mode, adLockPessimistic, adShareDenyWrite, WITH
(ROWLOCK) hint ..... I'm getting a headache! Simply, what I want to do is as
follows;
User 1 has a grid with a list of rows

I need help.
I have a VB 6 library which get data from a GIS Server. The data is a xml
string.
I want to parse the string by MSXML DLL. I knew 'DOMDocument' can load xml

I would like to create data grid view that will load values from BOOK
table but I want to get real name of author
from table AUTHOR and not author_id from BOOK table.
Actually, I want to make data bound...

I have a vb program that connects to odbc to an sqlexpress server. When
i try to write data to the db, i get this message:
Release Error: Script #1 (Ascent Capture Database) [3146 Index Table
(dbo.DIGIDOS): ODBC: de oproep is mislukt.]

What are the guidelines to make portable app.?
I've been using MSSQL server for database but if I compile app and then
install it on some other comp.
there'll be error because it has no MSSQL installed.

MDAC_TYP.EXE: Distribute or not?
I have created a simple VB6 database application that uses an MS Access
db, for which ADO 2.0 is enough. When I create the setup package with
the Package And Deployment Wizard, the large file MDAC_TYP.EXE is

Ok, this is my first time posting to google, so here it goes.  I am
trying to query an Access database for latitude and longitude so that I
can show a marker on Google maps.  Here is the code if anyone can help!
Dim MyConnection As ADODB.Connection

We finally got MS SQL Server 2005 and we are trying to learn how to
work with it, as far as getting it to run the original queries we have
in MS Access 2000 database.  We are still using the Access as our front
end gateway, so we have links to the server that were created by our IT

I could use the following statement to transfer data from Excel to SQL
Server.
With objConnMisc
   .Provider = "Microsoft.Jet.OLEDB.4.0"

Would appreciate some help here. Throws a Error 94 Invalid use of Null.
"UPDATE TBL_EMPLOYEES SET [Benefit_Date] = " & IIF(Isnull(Me!txtbenefit),
"Null", "#" & me!txtbenefit & "#") & "),....
this doesn't work either, still throw error 94

I am attempting to use a typed dataset with an Access database. I have the
data showing in a grid and that works prefectly but when I try to update, it
does nothing. I tracked the problem down to the fact that the DataAdapter
wizard does not generate UPDATE and DELETE statements. ...

I'd like to know the most efficient way to process a set of records.  I've built a composite record that is to contain columns from 6 other "Master"
tables.  I need to update the composite record with the values of those columns and perform some calculations along the way.  I ...

I have an interesting problem. With the code below, the loop takes ages to
run:
For intA = 0 To aryJobs.Count - 1
Dim strJobx As String = aryJobs(intA).ToString