VB Forum / Database Access / November 2005

I get the following
error when sql sting
(ADO) running in
vusual basic on db

I can't seem to figure this one out - - I've got code that, once connected
to a Server, will list the tables of a tables in a database, however, I
find, at least one database, it's leaving some of them out - -
I've tried it two different ways:

My VB application displays message 'not responding' when infact its
processing the data from the database.I am displaying the hour glass
cursor.The user is assuming that the application is not working and usually
close the application.Is there any work around ?

I am trying to connect via ADO to our SQL Server backend, but it's not
connecting. I am developing in VB6 SP5.
The code I have is this (relevant to what I am trying to do):
===

I have a program (written in VB6) running in a Win2000 server with SQL
server 2000 in it. However, the program runs very slow or even "Time Out
Expired" many times. My connection string is:
strConn = "Provider=SQLOLEDB;Data Source=myServer;Initial Catalog=myDB;User

Hi, I've been looking around trying to find an answer to my doubt, but
haven't quite find it. I have severeal asp pages that connecto to the
database using ADO. I've always close the connection and the recordset
objects as soon as I've finished using them.

I dont seem to be a ble to find an example where i write (save) the
results of my calculations in  an mdb table one by one. I'll explain what
I mean further down.
The reason is that there are a lot of calculations being produced AND I

How can I  select the version(compatibilty) for my database
I Use:
   Set db_Temp = WrkSpace.CreateDatabase(MF, dbLangDutch, dbVersion40)
'office 2000

Hello --
Very newbie question ...
How do I create one connection (after my login form) to one database which
will serve all recordsets I open in various forms and modules?

I am trying to install a program that I made, but in the customer it uses
XP SP2, and the MDAC this not functioning, my program shows error 430.
already tried to reinstall the MDAC. : 2.7 , 2.7 SP1, 2.8, 2.8 SP1 and
nothing functioned. what I must make to arrange the MDAC and my ...

OK i used the User-Level Security Wizard to secure the access databse i
created but i keep getting the pop-up of "You do not have the necessary
permissions to use the" but it have not asked for a login....of any
type...

in VB6 it was possible to set a reference on a particular ADO version
(2.1, 2.5 etc.)
How will I set a reference on a particular ADO version in Visual Studio
2003 or 2005?

Hi, Im new to reports writing in VB6. i've seens examples of creating
reports within VB apps. but most of the examples are using SQL commands
to extract data from access database. May i know how can i add values
from listbox/combobox/textbox into Reports???

anyone know of a good VB^ program that converts XLS  to MDB files
(source code please)
from a web site

I have a VB 6.0 application which uses ADO to access MS Access Database. One
of my clients is using this application on Windows Server 2003 Standard
Edition. The database connection gets lost every 30 seconds and my
application can re-establish the connection right after the ...