Read the docs for DBD::Proxy, your connect statment is wrong and never
specified to use ODBC on the server side.
In your connect change
dsn=northwind.mdb
to
dsn=DBI:ODBC:dsn_name
where dsn name is the name of the dsn that you set up on the server ODBC
applet.
If you are connecting from a non windows machine to a windows machine, you
must have ODBC configure on the windows machine and DBI::ProxyServer
installed on the same windows machine. For the non-windows machine you must
have DBD::Proxy installed. If both machines are windows then you don't need
to use Proxy.
Ilya Sterin
-----Original Message-----
From: Vasquez, Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 7:59 PM
To: 'Michael Ragsdale'
Cc: [EMAIL PROTECTED]
Subject: RE: DBD::OBDC
OK, more confused. Do I need DBD::OBDC to connect remotely or can I just
install DBD::Proxy(which I have) for this to work.
Re: DBD::OBDC
When I try to do make test I get the following error:
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/01base............ok
t/02simple..........Can't connect(), no database driver specified and
DBI_DSN env var not set at t/02simple.t line 16
dubious
Test returned status 255 (wstat 65280, 0xff00)
Undefined subroutine &Test::Harness::WCOREDUMP called at
/usr/lib/perl5/5.00503/Test/Harness.pm line 288.
make: *** [test_dynamic] Error 255
line 16 of t/02simple says: my $dbh = DBI->connect() || die "Connect failed:
$DBI::errstr\n";
***********************************************************
Re: DBD::Proxy:
When I try to connect with this connect string my "$dbh =
DBI->connect("dbi:Proxy:hostname=$host;port=$port, dsn=$db", "$username",
"$password", { RaiseError => 1,
} );
I get this error DBI->connect(hostname=$myhostname;port=6969,
dsn=northwind.mdb) failed: Missing remote dsn
Any suggestions?
Mike (newbi)
Sr. Webcast Manager - Broadcast Lab
Akamai Technologies
6815 Flanders Ave.
San Diego, CA 92121
858.909.3106 (w)
858.442.9287 (c)
http://akamai.com
-----Original Message-----
From: Michael Ragsdale [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 4:12 PM
To: Vasquez, Mike
Subject: Re: DBD::OBDC
At 03:53 PM 3/27/01 -0800, you wrote:
>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)
Actually, you will set all three of them in the same place: In Control
Panel on whichever machine the Access DB resides, go to the ODBC Data
Sources icon and double click. Within the ODBC Data Source Administrator,
click on System DSN tab and then click "Add...". Select Microsoft Access
Driver and then fill in the blanks regarding the location of the actual MDB
file, username, password, etc. Whatever you name it in the "Data Source
Name" field is what you'll put in as the DBI_DSN in your DBI script. If
the database is residing on another machine, don't forget to put the
hostname (IP name) of the DB machine in your connect string.
Good luck,
************************************************************
Michael Ragsdale Voice: (865)974-3957
Programmer/Systems Admin Fax: (865)974-8474
The University of Tennessee Email: [EMAIL PROTECTED]
