VB Forum / Database Access / January 2006

we have following problem. We have two tools. The first tool only insert new
records in a sqlserver table. The other tool read, modify or delete this
records. Now sometimes it happens, that we get a deadlock error. Can anybody
explain me, why this happens?

I wonder wether a software or a device (or script) allowing to migrate data
from an existant database to a new database by using correspondant ODBC
drivers existed.
Thanks for your help.

I link to a SQL Server 2000 through a windows network.  I installed Visual
Basic .NET 2003 on my workstation pc.  When I attempt to create a data link
to the server, I get the message "It is only possible to conect to SQL Server
Desktop Engine databases and Microsoft Access ...

Issue:
I am trying to convert my old VB / SQL to now use MySQL.
Setup:
I have installed the MySQL ODBC 3.51 driver

How would I write a SQL "SELECT" statement with a calculated field based on
the following:?
Fields: fieldOne, fieldTwo, fieldThree
Table: myTable

The Vb6 I'm using is probably very scaled down considering
it came with a book (Sams Teach Yourself Visual Basic 6)
I'm trying to use my Access 2003 data to create queries but
I get the dreadful 'Unrecognized database format' so I'm

I'm going to create some custom reporting software using
VB6.  It needs read-only access to the Peachtree 2005 data.
 I have some questions for anyone that has done something
like this.  I also need to say that the budget is really

Hi who has tried out the fix
http://support.microsoft.com/default.aspx?kbid=308644
Is this finaly the fix fot the long lasting memory leaks?
who has any experiance with this fix.

I've a problem using a connection to SQL Server via ADODB. When using two
opened connections the SQL Server seems to maintain the second connection
active 60 seconds after the close & nothing in my application. To do what
i'm saying you need to reproduce this code for example;

Im currently making my first real world program which involves a
program written in vb.net to display and update information kept in
sqlserver tables.
Ive been having some trouble getting vb.net to insert into tables where

I have done some more homework and found that:
* Peachtree is using stock Betrieve 6.15 files (I think).
* 6.15 is out of date and is no longer directly supported.
* There seems to be/have been an ODBC driver, but not sure.

Using vbscript and ADO, I would like to know how to...
   SELECT field1, field2 FROM file1.xls UNION SELECT field1, field2 FROM
file2.xls
Please give example connection strings and SELECT statements.

Please specify the perfect compatible VB-ADO constant (for example
adChar, adVarChar,adVarWChar) for the following datatypes in oracle:
varchar2(size), char(size).
I have done a lot of search to execute a stoted procedure in Oracle

Hi all,  I'm having quite a bit a trouble trying to get a query to
export to Excel from Access using VB6.  Currently I have an Access
backend with a VB6 frontend.  I want the user to select an employee and
click a button to export a query with the results to Excel.  The query

I am not sure what I am doing wrong here, but I have been through MSDN and a
couple of texts for an answer with no solution. Hopefully it is something
that will be obvious to a more experienced programmer...
VB6 ADO accessing a MS Access database with tables and relative fields as ...