VB Forum / Database Access / February 2004

when I open an ado.connection (VB6.0, mdac2.7) for MySQL  (cnn.open
"Provider=MySQLProv;Server=localhost;Data source=Test","root",""), a
window (MySQL data source name setup) comes up and asks me for the name
of the data source (???) etc. Is it possible to set the parameters in

I have an Access file with two tables:  One created on an older machine and a recent one on running on XP. The ADO will communicate with the older table but not the newer table.  I have downloaded the visual studio pack, hoping that would solve the problem. It did not.  Any ideas ...

I am using the adodc control and when i use the .addnew method i return a uniqueidentifier:
{00000000-0000-0000-0000-000000000000}
What methods should I use to the actual uniqueidentifier?

       Does anybody know what is this? or What happened to occurred this?
       I'm using a VB --> Com DLL (Com +) --> SQL Server 2000. And using
ADO MDAC 2.7 to access my DataBase.
       I looked for in MSDN and Technet and saw this 2 articles, but

- ok so dont spit the dummy yet because
for me this is a legit question...
i am going to write a little prog to run
on 9x system for a SINGLE USER.

I am revisiting an application I wrote quite awhile ago to add a sort
capability. I can't seem to get the SQL statement right......
I'm using a ComponentOne grid control to display the data... The grid
is connected to a DataControl that "mirrors" another DataControl

I have a VB6 application using ADO with an MS Access
database that we have upgraded from 97 to 2000 to 2002.  
We can't seem to get row level locking to work so we
created a small app to simulate the problem.  We used the

I have been looking around for a legit copy of VB 5 or 6, but cannot find
one....
Can anyone help?

Is there any way to kick everyone off an access database using VB.net 2003
or VB 6.0.
I have to be able to detatch any connected users from the database to
repopulate it with a DTS script.

Im searching for SAP OCX files / controls , plugins etc.  do you have any
clue where i can find
detailed and good documented information downloads ?
tia

Hello group, I'm developing a software and use SQL Server, but the name of
each server PC where my software will be instaled of  certainly will be
different one from another, please, anyone knows how to find the PC's name
and / or the SQL Server's name, thanks.

My name is Alejandro.
I need to merge several dBASE tables into a unique SQL query (in a
ADODC control), having some of theses tables in the \DBF directory and
other tables in the \DBF\2004 directory.

I am going to try to accessan existing Btrieve Database, but have no idea
where to start.
I know how to use ADO very well.
Please can someone give me a starter or a link to a website.

I have a table with data that looks like this
EMP#        DATETIME_STAMP                EVENT_TYP
3118    2/8/2004 9:00:10 AM             
3118    2/8/2004 11:30:26 AM          

I have a database that someone else designed to be integrated into a dynamic
web interface.  Two of the fields in particular are dealing with ntext
fields and I am thoroughly disappointed at the piss-poor documentation
available on handling these fields in MSSQL.