Втр, 14 Сен 2010, gary ng писал(а):
> On Tue, Sep 14, 2010 at 8:12 AM, bill lam <[email protected]> wrote:
> > Thank you for information. I tested it failed under wine. May be it is a
> > wine issue.
> >
> > J can use odbc under window and linux.
> >
> did a quick test on my window system. After I have defined the DSN in
> the ODBC control panel(including connecting specifying the exact XLS)
> I can do a:
>
> ddcon 'dsn=myexcel'
>
> which returns a handle that I would assume to be working ok.
>
> But of course, this is very inconvenient. Is there a way to specify
> DSNless connection or supply the actual file name on call ?
You can do that by using sqldriverconnect instead of sqlconnect in ddcon.
and supply the connection string, eg
ddcon 'Driver={Microsoft Access Driver (*.mdb)};Dbq=/bill/db0.mdb;'
of course you need to supply correct parameters to sqldriverconnect.
--
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
