I'll be using a Linux server running the Web Server and the Access DB will
reside on another machine running a win2k server. The Linux box will be the
main web server that currently uses DBD::Oracle to connect to the main
oracle database on a different machine. The access database is a smaller
database on the win2k machine.
In the DBD::Proxy manual it shows that the connect string should be:
$dbh=DBI->connect("dbi:Proxy:hostname=$host; port=$port; dsn=$mydb",
$user, $passwd);
I understand all except for the port. What port number should I be using in
the connect string. Is there a default port to connect to?
Mike
-----Original Message-----
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 4:46 PM
To: Vasquez, Mike; [EMAIL PROTECTED]
Subject: RE: :OBDC
Well depends on what machine you application will reside. We need more
info.
If win32 machine, then just use ODBC to create a DSN to the remote Access
db, if Unix/Linux type, then you need to either use DBD::Proxy and
DBD::ProxyServer or you can use a third party ODBC driver.
Ilya Sterin
-----Original Message-----
From: Vasquez, Mike [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 6:54 PM
To: '[EMAIL PROTECTED]'
Subject: DBD::OBDC
I want to be able to access an Access db that resides on another machine.
Can I access this small database using DBD::OBDC. If so, how and where do I
set up the following:
DBI_DSN The dbi data source, e.g. 'dbi:ODBC:YOUR_DSN_HERE' DBI_USER
DBI_USER
DBI_PASS
ODBCHOME
The DBI_USER and DBI_PASS I understand. I'm not sure about the DBI_DSN.
How would one set this variable?
Mike (a newbie)
