ciamack has asked for the wisdom of the Perl Monks concerning the following question: ⭐ (database programming)
Regarding CGI programing:
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.
- I wonder if these methods are multi threading?
- If several users access access my DB at the same time it will function properly?
Thank you in advance.
method 1:
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);
method 2:
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";
Originally posted as a Categorized Question.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: What is the difference between ADO and ODBC ?⭐
by jehuni (Pilgrim) on Oct 09, 2001 at 16:43 UTC | |
Re: What is the difference between ADO and ODBC ?⭐
by CubicSpline (Friar) on Oct 09, 2001 at 17:00 UTC | |
Re: What is the difference between ADO and ODBC ?⭐
by Anonymous Monk on Apr 07, 2003 at 14:12 UTC | |
Re: What is the difference between ADO and ODBC ?
by Anonymous Monk on Feb 10, 2004 at 04:34 UTC | |
by inman (Curate) on Feb 10, 2004 at 09:11 UTC | |
Re: What is the difference betwwen ADO and ODBC ?
by Anonymous Monk on Feb 06, 2002 at 08:27 UTC | |
Re: What is the difference betwwen ADO and ODBC ?
by Anonymous Monk on Jan 15, 2004 at 06:04 UTC | |
Re: What is the difference betwwen ADO and ODBC ?
by Anonymous Monk on Apr 28, 2004 at 07:43 UTC |
Back to
Seekers of Perl Wisdom