Re: Any REAL reason to use ADO vs. DAO?

I only use the ODBC (DSN) so the web page can connect to it when displaying
the table - I don't use the ODBC from the VB6 code. Is there a more concise
way to connect to a Jet .MDB from VBScript than a DSN connection? Seems to
work fine and is simple.

-b :-)

"Ralph" <nt_consulting64@xxxxxxxxx> wrote in message
news:iamdnQSsPIYPdqHbnZ2dnUVZ_qKqnZ2d@xxxxxxxxxxxxxxx

"Bruce W. Roeser" <broeser@xxxxxxxxxx> wrote in message
news:%23TmXEe0jHHA.1624@xxxxxxxxxxxxxxxxxxxxxxx
Same here. I just have a small website that I keep my bible studies on.
The reference table is maintained in a nice little Access MDB on my local
machine here with an ODBC connection set up and, yes, I use Front Page
2003
too - it's *very* nice to work with. In fact I like the entire Office
2003
line - they just work.

Then if I need to get at the database through a VB6 application I've
already
got a small library of functions written for DAO that make life easy. No
... I won't write enterprise-level applications with this but for nice
little Windows desktop applications it's pretty tough to beat the
VB6/Access
combination.

-b :-)

You're doing everything right except for the ODBC driver (or perhaps
ODBCDirect). Lose it.

ODBC is not optimal for ISAM data stores, ie. mdb files. Use the
appropriate
Jet driver/s directly, which are optimal for Office files.

-ralph




.

Relevant Pages

  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Silly ODBC Connection problem
    ... it seems to me this must be done interactively on each client--either that or use the magical "DSN-less" connection. ... It's been 11 or years or so since I wrote about ODBC so it's getting kinda fuzzy. ... 556-9205 (Pacific time) ... > created a System DSN named "MyDSN" in the ODBC Administrator tool. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Beginner: How do I link via ODBC from a PC into an AS400?
    ... Options, Miscellaneous, How to keep Microsoft Office Documents Protected, ... The moment I select ODBC Databases from Files of Type, ... I have added a User DSN based on the Client Access Driver, ...
    (microsoft.public.access.externaldata)
  • Re: Database or Project?
    ... I just create a blank database, copy the mdb file to the ... On that PC you create an ODBC DSN and then use ... that to create links to the tables on the SQL Server (with code the links can ... cases passthrough queries which use the same ODBC connection. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... you have to use ODBC (or the old DDE ... but then you go onto say that an "ODBC connection set up ... >> Document to connect to a Secured Access Database, ... >they have a .dsn extension. ...
    (microsoft.public.word.mailmerge.fields)