categorized question
QandAEditors
<p>Regarding CGI programing:</p>
<p>I am new to DB in Perl and
I'm not sure what the difference between these
2 methods below is. I have a MS access mdb file with
tables and data on a server. I can't ask my ISP
to create a DSN for me. I have used "method2" below and it works fine.
<ul>
<li>I wonder if these methods are multi threading?</li>
<li>If several users access access my DB at the same time it will function properly?</li>
</ul>
</p>
<p>Thank you in advance.</p>
<p><b><u>method 1:</u></b>
<code>
use Win32::OLE;
$ConnStr = "DSN=DsnName;UID=UserName;PWD=pass;
APP=PerlTest;WSID=MyComp;DATABASE=MyDB";
$Conn = Win32::OLE->new('ADODB.Connection');
$Conn->Open($ConnStr);
</code>
</p>
<p><b><u>method 2:</u></b>
<code>
use Win32::ODBC;
$DriverType = "Microsoft Access Driver (*.mdb)";
$DSN = "Win32 ODBC --MAOmaoMAOmaoMAO--";
$Dir = "c:\\perl\\cgi-bin";
$DBase = "mydb.mdb";
Win32::ODBC::ConfigDSN(ODBC_ADD_DSN, $DriverType,
("DSN=$DSN", "Description=MAO Win32 ODBC Test DSN for perl",
"DBQ=$Dir\\$DBase", "DEFAULTDIR=$Dir", "UID=", "PWD="))
or die "ConfigDSN(): Could not add temporary DSN" .
Win32::ODBC::Error();
$db=new Win32::ODBC($DSN) or die "couldn't ODBC $DSN because",
Win32::ODBC::Error(), "\n";
</code>
</p>
1831