RE: MS Access/CGI/Apache on WinNT questions

2002-03-12 Thread MacGown, Peter
; [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions That, unfortunately, can be a bad message because of the way that DBD::ODBC handles opening the database. What's happening is that DBI can't open the database using the DSN-less style open (SQLDriverConnect) which fails

RE: MS Access/CGI/Apache on WinNT questions

2002-03-12 Thread Jeff Urlwin
-Access security? Does the web server user have access to the admin database? Regards, Jeff -Original Message- From: MacGown, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 10:05 AM To: [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions Jeff

RE: MS Access/CGI/Apache on WinNT questions

2002-03-12 Thread MacGown, Peter
To: MacGown, Peter; [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions Pete, Right before the connect, do the following: DBI-trace(5, c:/trace.txt); Then, send me the trace.txt from the web server's C: drive. (and, look at it yourself to see if the error is recognizable

RE: MS Access/CGI/Apache on WinNT questions

2002-03-12 Thread MacGown, Peter
Jeff, In answer to your other questions: What version of DBD::ODBC are you using? PPMquery DBI DBI [1.201] Database independent interface for Perl Are you using MS-Access security? I am not using mdw files, if that is what you mean, but I do have the mdb file

RE: MS Access/CGI/Apache on WinNT questions

2002-03-12 Thread Jeff Urlwin
To: [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions Hi Jeff: This is a snippet of the code: use DBI; my $dsn = driver=Microsoft Access Driver (*.mdb);dbq=nrent01\\fssdata\\Roster03b.mdb; DBI-trace(5, c:/trace.txt); my $dbh = DBI-connect

RE: MS Access/CGI/Apache on WinNT questions

2002-03-12 Thread MacGown, Peter
-Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 1:32 PM To: MacGown, Peter; [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions What version of DBD::ODBC are you using? PPM query ODBC DBD-ODBC [0.28

RE: MS Access/CGI/Apache on WinNT questions

2002-03-12 Thread Jeff Urlwin
: MacGown, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 1:59 PM To: 'Jeff Urlwin'; [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 1:32 PM

RE: MS Access/CGI/Apache on WinNT questions

2002-03-12 Thread MacGown, Peter
-Original Message- From: MacGown, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 1:59 PM To: 'Jeff Urlwin'; [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Tuesday

RE: MS Access/CGI/Apache on WinNT questions

2002-03-12 Thread Jeff Urlwin
:\tmp and then install c:\tmp\DBI.ppd, etc Let me know if you have issues. Thanks, Jeff -Original Message- From: MacGown, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 5:11 PM To: 'Jeff Urlwin'; [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions

RE: MS Access/CGI/Apache on WinNT questions

2002-03-11 Thread Jeff Urlwin
That, unfortunately, can be a bad message because of the way that DBD::ODBC handles opening the database. What's happening is that DBI can't open the database using the DSN-less style open (SQLDriverConnect) which fails and then tries to call SQLConnect, which expects a 32? character or less