VB Forum / Database Access / February 2007

Dear Sir,
I had developed Application using VB6 Enterprise Edition, Service Pack 6, I
am using ADODB Object of Microsoft ActiveX Data Object 2.5 Library
(msado15.dll) for Connection & Recordset.

I am facing a really strange problem
I am making a connection with DSN. However strangely, when a
uniqueidentifier column is included the recordset does not return any
row. And when the uniqueidentifier column is removed, the records are

I'm not sure if this is the right group, but here goes.
I'm relatively new to VS and VB, but did some projects in VBA.
I took the guided tours in VS of creating databases, user objects,
user properties/methods/events, classes etc.

I use this in vb & access. but now i want to used this query in
oracle. But i not used it properly.oracle return an error messages
when i used this query.is there any ssolution to used this query in
oracle.

Say I create a connection object this way in a COM+ DLL...
dim dbConn as new adodb.connection
dbConn.open <connect string>
Is there any difference between following when assigning a connection

I have an MS Access database with just one table.  In that table are
several dozen columns, each one called Variable1, Variable2,
Variable3, etc.
Is there any way to use a For/Next loop to write information to this

My question has to do with the connection between these two.  Right
now on the userform I have textboxes for the user to input values.
What I want to do is to have buttons with the names of ADD Record,
MODIFY Record, and DELETE Record.

I am trying to retrieve the value of the autonumber field after adding and
updating a record to a SQL Server 2005 database. I can't get it working, it
always shows the value 'empty'.
I've been through a lot of documentation which advises me to use

Will pay for need help and occasional advise on using excel
database
" sorry if this is off post ...will be my last"
Thx in advance for your help and interest.

Hi every body
Alguien tiene idea de como convertir una base de datos de la siguiente
manera:
Anyone have any idea to convert a table like

In my program, I am inserting up to 10,000 rows of data into a SQL
Server DB Table.  When my program reaches this code, the application
appears to freeze until the for loop ends.  After this loop is over,
the program acts normally and all of the ADODB.Commands worked

What conditions would cause this error to appear? My form has an ado control
which refers to a table in an Access database. When I look at the local
variables as early as form initialize, this error already appears under the
Active Connection for the ado control's recordset. I ...

Can anyone tell me what the difference is between the vfpodbc.dll
versions are?
ver 6.1.8629.1 dated 12/7/1999 956KB in size and ver 1.0.2.0 dated
10/20/2001 24KB in size.

I've an old VB6 program design to use a Access 97 database.  We've
recently decided to convert the program so it would use an Access 2000
database instead.
So I converted our database to the access 2000 format, changed the

Hello.  I have an application written in Visual Basic 6.0 using the Microsoft
ActiveX Data Objects 2.8 Library.  I send a query in plain text to the an
ADODB.Recordset's Open method.  The query returns 0 records.
Then, when I take that same exact query, copy (from VB's immediate