[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
DBD::ODBC connections
Hello folks,
Its been a while! Took some time away from e-commerce to hone my
Java/Corba skills and now I'm back doing what I love. This is my fifth
minivend installation for a corporate client using NT, but the first one in
which I am using DBI and DBD::ODBC to connect to a database. I'm going to
be scaling this to a Sparc/Oracle system very shortly, but for the sake of
time and because Minivend conceptually allows it, I'm prototyping the whole
thing on NT using Access.
My problem: I don't clearly understand what is happening when I use ODBC
to get datafiles, so I can't debug what's going on. When using db_file
with ascii files all files are imported into .db's (berkely hash files).
Then anytime someone makes a query, the .db file is used. Any updates that
are made do not carry over to the ascii files. How does this work when you
use dbd.odbc? Is there a way to connect to the ODBC directly and totally
bypass the text files?
My second problem: What is the proper syntax for using a database residing
on the same machine as minivend with a good and tested odbc connection?
(tested using a simple Tk/DBI program, I'll send it to the first person to
offer me the help I need to make this work.)
Currently I am using (the DSN is Portal, there is no login/pwd required):
Database products products.asc TAB
Database products INDEX category
The above works fine for the .asc file. However, when I try to connect to
the dsn "Portal" which contains a table "products" with the following code
nothing happens:
Database products products dbi:ODBC:Portal
This is the only line of code I change, other than removing the .asc, and
INDEX line for products.
Any and all help that you can give me will be greatly appreciated. Before
you flame, remember, I've been generous with my help and code in the past
so please give me a hand here, ok?
Mike Van (aka vandy...)
founder, Annapolis.pm (the Annapolis Perl User's group)
founder, the Great Annapolis JUGerNaut (Java User's group)
---------------------------------------------------------
This message sent using EMUmail -- http://www.emumail.com
---------------------------------------------------------
<HTML>
<font face="arial,helvetica" size=2>
Attention <B>PDA Users</B>: Get your existing email from your Palm VII<BR>
with HoboMail.com. You're free to roam with HoboMail.<BR>
<P>
http://www.hobomail.com
<img src="http://ad.vert.net/hm.cgi?991031"></font>
</HTML>
