On 13 Aug 98, at 18:28, Ivan Sergio Borgonovo wrote:
> Anbody know how to setup ODBC on W95 or NT?
> I (now after repeating it about 100 times I think that evrybody
know it)
> have 2 Wintel box. An NT running PWS and ASP and a W95 box. I'm working on
> the NT box of course... I would like to use Access DB files. Do I need to
> install Access on the NT box or it will be enough to setup the ODBC driver
> and save an Access file on this machine? What step are needed to make the
> ODBC whole system to work??
That, I do not know. I do know that I can user perl/dbi to access
access databases on my NT machine. I wrote a routine to convert
tables from access to msql -- uhhh...not completely but I extract
from access and then save in an ascii file which I can just say:
msql database_name < my_ascii_file
and now I have a new table in the database. Going from binary to
binary is something to look forward to.
But I don't think you need to even mess with ODBC if you are using
access. Just today I showed an aspiring webmaster how to import a
text data file into access and we went nowhere near ODBC. Database
was created with tables etc.
Don't forget that a database is just a name. That is the name you
put in the ODBC.
Here is how I work it in my perl script (on NT):
> use DBI;
> my $driver = "ODBC";
> my $dbase = "8_10_98_service_master";
> my $data_source = "dbi:$driver:$dbase";
> my $db = DBI->connect($data_source) || die "dbi fail: $!\n";
8_10_98_service_master is the name of the database. All the work is
done with the tables therein.
> Nobody write the answer to the most stupid questions in tutorials!!!!
I had a nightmare of a time trying to get PWD to get cgi's to run.
After I did the initial setup (it did it actually) even its own asp
files would not run. I tried setting all the permissions and this and
that and it was just a nightmare. Setting up Apache on Linux with
msql and mysql with full cgi etc was so much easier.
Peter
_________________________________________________________
Peter J. Schoenster [EMAIL PROTECTED]
Exercise Your Brain..Read a Book http://www.rede.com/
Free CGI Scripts and Applications
http://www.rede.com/samples/index.html
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
