VB Forum / Database Access / October 2006

After users install my application they need to create a database to connect
with.  What I am trying to do is have the application start and recognize
this is the first time it is being used.  I do this my setting a registry
value of string to true and then checking this value ...

I have a VB6 application that was extracting data from an 8i DB but we
recently upgraded to Oracle 9i and started having problems with the
Oracle ODBC driver (v9.2.0.1.0).  We kept getting an error when trying
to create the connection to the DB but ther was no Oracle refused to

I've got this code :
       With oServer
           If chkTrusted.Value <> 1 Then
               .Disconnect

Can anyone Tell me why this code doesnt let me bind a Textbox field to
the Account# column in my SQL table.  It says "Cannot bind to the
property or column ACCOUNT# on the DataSource.
Parameter name: dataMember"  I've been looking around and some people

I have a list box loaded with Student Name, Social Security.  When the
user click on a specific record, the following code is assigned to the
lstStudent1_AfterUpdate procedure.
Private Sub lstStudent1_AfterUpdate()

I'm trying to move away from working in microsoft access and try and
work with SQL Server.  I'm going to be storing around 50K records of
data in a table within SQL server at first.  I tried using the visual
studio.net Dataset control to create all my bound fields in the set,

I'm using VB6 and Access 2003 and am trying to call a function inside
of an insert statement without any luck. I suspect my syntax is wrong
somewhere, but I can't seem to see it.
I appreciate any help you can offer.

I am wondering how I would go about changing the ID of a hard-drive.  I
know how to change the lable, but I want to be able to change the ID of
it.

I'm trying to create an application that will have multiple users
working off a table on a SQL server.  Since multi users will be
updating different records at any given moment, how can i get those
changes and merge them into my current Dataset.  I've been playing

Hi, Using this string I get the error
Run-time error ';214217900
line1: incorrect syntax new '01'
Set rdset = CONN.Execute("Select Name From TimeTable Where City=0 AND

I used to use this string in VB6 while connecting to MS Access 2000
1)
Dim conn As ADODB.Connection
Dim rdset As ADODB.Recordset

Hello, who can help me out?
I connected an Excel file to my VB6 application by:
Set adc = New ADODC.Connection
With adc

I am trying this lesson involving DBs.
"ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_vbcnexpress/html/caf3ecbd-87f5-4748-b990-7395409a19c7.htm"
I can successfully create the DB, Create the Access form, and "SEE" the data
I earlier manually placed in the DB outside of my ...

Hi, I'm using VB 6 and using ADO for my data connections. What I'm
trying to do is populate a combobox with a list of databases on the MS
SQL server. Does anyways know how this would be done?

Suppose i load a form once and the user doesn't close it and then he tries to
open it again from the menu but it doesn't come up as it's already open. How
can i bring the form to the foreground?