VB Forum / Database Access / March 2007

I have created a VB.Net application that used classic ADO to access the
oracle database. I have mentained a persistant connection in it. When i start
the application and it works fine. All of a sudden i start receiving the
following error messages countineoully as my appllication ...

I'm selecting 5 rows from a view. When I fetch the results with
CursorLocation set to vbUseClient i get the response in one second.
When I use vbUseServer I wait about 1 minute. Can anyone explain this
behaviour to me?

Hi Experts,
Is Microsoft Jet Database Engine with all Windows (2000, XP, Vista)?
I have a softwre using Access database. Do I need the user to have MS Access
installed?

Hi i have a program that was created in Visual Studio 6 Pro, which links to
an access 97 Dahe database! everytime i try to access the database from the
program i get the following error
ADODC1

I am trying to create an ODBC connection to an access database.
My procedure is as follows:
Select System DSN
I click add

This has cropped up a few times, but I have yet to find a satisfactory answer.
My company uses an .mdb with tables linked to an Oracle backend through ODBC
(MS Oracle driver).  Until recently this was working fine, however something
changed (no one can say what) and now  for all ...

Dim db As DAO.Database
    Dim tdef As DAO.TableDef
    Dim MyIndex As DAO.Index
    Set db = OpenDatabase("Test.mdb")

Im devoloping a vb.net Application
im using dll file for excel managment,internet explorer
the application working in my computer and some other computer,
But one computer is not working when it execte after installing

I am developing an application that keeps track of employee points for
the company I work for. I pull in all my employee data from another
database through a web service and keep the information I want to edit
(the points, awards, etc.) in a SQL database.

short description:
i've got a .net web site set up using a tableadapter attached to a sql
server table - returning results only, no update of data.  i've got a
query (qry code below) set up to search and return based on

SQLStr= "select id, name from patient order by id"
Set RS = DB.OpenRecordset(SQLStr, dbOpenDynaset)
rs.movefirst
clipboard.settext rs.fields("name")

is there an reason that the statement
DBEngine.BeginTrans would cause an ActiveX component can't create object
error? I've never seen this before and am a little stumped.
If I remove the begin and end trans lines of code, the code execute as

when using VBA to open an automated access DB our engineering dept has
created a default macro warning form pop up that requires user input before
the DB will open. I cannot get the VBA script to focus on the warning form or
bypass it. I want the VBA to go to th e"Open" tab and ...

I have a VB6 application using SQL Server 2000(SP4) database. One user
entered about 50 timesheets on one computer yesterday. This morning they are
gone. I restored it from the backup database as of midnight 12:00 and those
records are not there. We checked everything we can ...

I am trying to replace VB6 SaveSetting command, to use a parameter file
rather than the registry.
I want to make the equivalent of :
     SaveSetting appname, section, key, setting