From a FreeBSD box to a Windows box using this method?
No. I don't have a FreeBSD box. I can try it from a Linux box; but i
thought I'd leave a little work for the OP to do. He will learn
something from the exercise.
Linux - FreeBSD - all Unix - NOT Windows. Read the OP.
IIRC, works fine on this Win32 system, as I had set it up several
times. It's working in a CGI environment (IndigoPerl) on this Win32
system; so access from FreeBSD, if I had it, should work. It *does*
work from other Win32, as well as Linux buxes on this network.
A CGI environment. In other words, you used a web server to connect
to the ODBC datasource? So, the drivers needed to access the ODBC
datasource were on the Windows box, right? And the connection to the
Windows box was through a web server, right? So, basiclly, it didn't
work FROM the non-Windows machine without the use of a web server.
Which is why I suggested useing DBI:
roxy - same concept, different
approach. Still need a server or drivers to run on one box or the
other to accomplish the task. Simply setting up a DSN on the Windows
box won't work without a server or having drivers on the foriegn
machine. Interesting approach, but not what the OP was after.
No. I understand what the OP is seeking. AFAIK, a System DSN would
work. Have you proved your claim that it "can not be done as ...
indicated"? Why don't you try it with *your* FreeBSD system and I'll
try it with Linux? I'll post the results of my tests.
I have. When I first started using Linux (and later FreeBSD and
SunOS and variants of Windows and MVS), I used the approach the
setting up a DSN on a Windows machine
would fit the bill. Not so. But hey, don't take my work for it.
Here's a blurb from the book "Programming the Perl DBI". In the
section for DBD::ODBC, it states:
"For Win32, the driver manager is included with the operating system.
For Unix and varients, the iODBC driver manager is included in the
iodbc directory. While iODBC acts as the driver manager (in italics),
you still have to find an actual driver for your platform and
database."
It goes on to mention, get this, ODBC drivers for Unix. One mentioned
is ... UnixODBC. I'm sure if you take the time to do some research on
your own, you'll see what I'm talking about.
I placed the OP below your review. The OP mentions mounting the
Windows partition, which tells me the person posting wanted to use the
file WITHOUT using a server.
I'm done with this thread. Have a nice day.
===START ORIGINAL POST====
I find myself with the eed to obtain some data stored in Microsoft
Access
format files from a perl script ruinning on a FreebSD box.
What's the best way to do this?
The files are actually on a Windows machien, but I can mount the
partiton
using Samba.
===END ORIGINAL POST====