VB Forum / Database Access / May 2004

A bit of a newbie question
How do I display results from Joined tables?
[Ships Table]
ShipID

I am using VB6 with SP5 and Oracle OLE to Connect to my Oracle 9i
Database.  I have a table that has nearly 20,000 rows. I have Set the
CursorLocation as AdUseServer, and when working in a local network, I
have no problems. When I run the application over a 256 KB remote

I'm getting a TimeOut error executing a command using ADODB Command.
I'm not able to recreate the issue, but it look is happening when the data
volume execeed 50,000 records, and probably is raising because the server is
located in Spain, but client machineis on USA.

Hi friends.
I want to change my ADO version from 2.7 to 2.5 .
due to following reaso
First i have developed one application in  VB with ADO 2.

In the following code, I'm trying to repeatedly query a table and put the
results in a recordset.  I do not want to make and keep a connection opened,
but want to make a new connection to the database each time I query it.  The
first query works ok, but I get an error "Operation is ...

I have a system that reads a VF FoxPro Database version 6. It runs using an
MDAC 2.5 of the VFProDriver VFPODBC.DLL V6.1.8629.1
I have just heard that the system creating the databases is being converted
to VFoxPro v 7. I would be grateful for some advice as to which version of

Greetings All
I have a multi user application which requires the genertion of a
unique Counter for each new record.  Autonumber is not suitable in
this situation.

Using a DataEnvironment in VB6, I'm trying to write data from a text
box into a database as follows:
deDataBase.rsConfig("ST1Rate").Value = FormatNumber(mebTax1Rate.Text,
3, vbTrue)

I have this code:
.
.
dim lastDate as date

How can I programatically get a list of DSN's?

I have a newbie question here; I've Googled and searched through MSDN,
and I'm still a bit confused:
Can anyone point me as to how to connect to a SQLite
(http://www.sqlite.org)  database using ODBC in VB.NET? I've downloaded

I wish to do an enhanced search (using VB6) of last names in a customers
table of an Access2000 database.
I wish the search to be more refined than using "Like" or ">=" and able to
take into account things like mis-spellings etc. These fuzzy searches are

Here is my problem.  I'm a newbie to MS Access and using VB 6 script
with it.  I've worked with VB for years so that isn't a problem for
me.  Here is my current situation:
I've got a table named REPORT_OUTPUT with four columns(ReportName,

I'm using VB6 as a front end to access200 db. In this db there is a reports
'rptCityOrder' made already and I would like to display them when I click on
a button in the front end. The code below opens MS Access then closes
without displaying anything. Is there a way to display this ...

I have an application with an access db (ver. '97),  written in vb5.
I would like to protect the db in order that all users can read the
data, but only some users can write on it. i.e. I need to define for
each user the couple "username/pw"