Re: I dont know how to link VB to database (ODBC) table.

If you are using VB6 have you installed service pack for VB? the latest
version of service pack is SP6.
I am using VB with SP6 installed. I think VB 6 without Service Pack
installed could not recognize MS Access 2000, CMIIW.

Would try using ADO Data Control to check whether you can connect to
database
I think frist you must add this ADO Data Control (Project > Component) or
CTRL - T and Select Microsoft ADO Data Control (OLEDB). I usually test
whether I can connect to database or generate a connection string using this
data control.

Regards,

Gun

"Howk013" <Howk013@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5308AB66-0CA0-40B6-BD1C-20EC3459BB87@xxxxxxxxxxxxxxxx
Hi Ralph,
The book i was following is : The complete reference Visual Basic 6 , by
Noel Jerke Copyrighted @ 1999, Pages 110 onwards..I tried his example on a
smaller scale , meaning out of all the 5 textboxs in his examples i used
only
1 textbox to help me appreciate the idea at a lower complexity, but found
that I could not get it properly done

My version is VB6
MS Access is 2000

Oops..that was a typo, it is a .mdb , apologies~!

Your Code -> Uses an Data Access Library (ADO or DAO)
The Data Access Library -> Uses a Provider (ADO) or Driver (ODBC)
The Provider/Driver -> Uses a Connection String to access a Database
engine
(In your case the "Jet Engine")
The Jet engine -> Uses your data store (In this case a MDB file).

Can i have an idea of how I should key them, or learn how to configure
them?
Thanks Ralph!


"Ralph" wrote:


"Howk013" <Howk013@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6CE69FE3-7BC3-47BF-AD79-6FB1E97DEA61@xxxxxxxxxxxxxxxx
Hi

This is what i have in Form, one text box, one Data

Under the Data Properties

Name: Data1
Connect : Access
DataBaseName: C:\Sample\Sampledb.mdt
Default Type: ODBC
Recordset Type: 1 Dynaset
Record Source : (This is the part i had problem with)

The rest are default properties


Under TextBox Property

Name: txtSample
Data Field txtSample
Data Source Data1


There's no coding done yet.

This part I am clueless, I enter administrative tools, DataSource(ODBC)
,
is
there anything i should set in there? so that the textbox inputs can
be
saved in my database table?

Have I done anything wrong or missed out certain parts? I was
following a
book's procedure.

When i try to change the recordsource in properties, The msgbox popped
up
is
this : You cannot emunerate Table names in ODBCDirect mode (Default
type
set
to UserODBC)

Clueless about what that means too. Thanks for all help!


What book are you using (it might help to know). How old is it?
You might need to read a little farther.

What version of VB are you using VB6? Standard? Pro? Enterprise? If the
latter two then there are Wizards available to make things a bit easier
in
the beginning. When you click "Add... Form" do you see on option to
create a
"Data Form Wizard"?

What version of MSAccess are you using?

In the beginning accessing a database from code can be a bit intimidating
as
there are a host of new technologies you need to get a passing
acquaintance
with. It comes even more confusing to discover that many of these can be
mixed together, and some are mutually exclusive. These technologies are
easier to understand if you note they form a "stack" of blocks or
components
that reach from your code to your database...

Your Code -> Uses an Data Access Library (ADO or DAO)
The Data Access Library -> Uses a Provider (ADO) or Driver (ODBC)
The Provider/Driver -> Uses a Connection String to access a Database
engine
(In your case the "Jet Engine")
The Jet engine -> Uses your data store (In this case a MDB file).
[I hope the ".mdt" extension is a typo...
DataBaseName: C:\Sample\Sampledb.mdt]

Answer the above questions and we'll see if we can get you going... <g>

-ralph







.

Relevant Pages

  • Re: I dont know how to link VB to database (ODBC) table.
    ... The Provider/Driver -> Uses a Connection String to access a Database engine ... The Jet engine -> Uses your data store. ... Under TextBox Property ...
    (microsoft.public.vb.general.discussion)
  • Re: Using python for a CAD program
    ... relational database models. ... While it might be possible to do this fast enough with Python, ... Basically what the retained mode engine does for you is it ... The retained mode engine will take care of things such as ...
    (comp.lang.python)
  • Re: sorter script [was: Frustrated newbie question]
    ... was from the "perldoc -q sort" as a way of ... most 'elegant' of looking algorithms. ... that bogged the database engine down. ... was due to bad implementation on the db engine. ...
    (perl.beginners)
  • Re: Database Alternative
    ... We built our engine with C#, using the subset of functionality available ... convenient to use the databinding functionality available with .NET. ... a database file. ... What do your customers use "GT40" for? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Question about an embedded database engine
    ... I am looking for an embedded database engine for our analysis application. ... The requirements include a good SQL implementation and TDataset ... currently implemented as a user-interface module that can execute multiple ...
    (borland.public.delphi.thirdpartytools.general)