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)