> # Define the connection string
> my $prov = "Provider=Microsoft.Jet.OLEDB.4.0; ";
> my $dsourc = "Data Source=C:\\inetPub\\wwwroot\\dbfolder\\database.mdb; ";
> my $dbprog = "Jet OLEDB:Database; ";
> my $pw = "Password=password4;";
> my $dbopen = $prov . $dsourc . $dbprog . $pw;
Where do you specify a username?
You could setup a DSN entry:
---
http://www.w3schools.com/ado/ado_connect.asp
An ODBC Connection to a MS Access Database
Here is how to create a connection to a MS Access Database:
1.Open the ODBC icon in your Control Panel.
2.Choose the System DSN tab.
3.Click on Add in the System DSN tab.
4.Select the Microsoft Access Driver. Click Finish.
5.In the next screen, click Select to locate the database.
6.Give the database a Data Source Name (DSN).
7.Click OK.
---
<%
use Data::Dumper;
my $conn = $Server->CreateObject("ADODB.Connection");
$conn->{Provider}="Microsoft.Jet.OLEDB.4.0";
$conn->Open("c:/webdata/northwind.mdb");
$Response->Write("<PRE>".Dumper($conn)."</PRE>");
%>
Pay special attention to the State property and make sure its one before
proceeding.
> Any suggestions about how to use passwords, or do passwords not work with
> PerlScript and ADO?
What benefit is there in developing a database product that doesn't
support passwords? Indeed ADO is a language independent interface that
_does_ support passwords.
- Ron
_______________________________________________
Perl-Win32-Web mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
