[Fwd: [unixODBC-DEV] - UnixODBC, Wine, Crystal Report -- would appreciate insight]]

[Ulrich Czekalla]

On Wed, Jan 07, 2004 at 07:11:54AM -0800, Bill Medland wrote:
> On January 6, 2004 07:35 pm, Dan Kegel wrote:
> > Can somebody have a look at this?
> > Thanks,
> > Dan
> 
> I'll do what I can; everyone else feel free to jump in.
> 
> >
> > -------- Original Message --------
> > Subject: [unixODBC-DEV] - UnixODBC, Wine, Crystal Report -- would
> > appreciate insight Date: Tue, 06 Jan 2004 15:07:11 -0500
> > From: Aurelien Marchand <aurelien.marchand at researchcapital.com>
> > Reply-To: unixodbc-dev at unixodbc.org
> > To: unixodbc-dev at easysoft.com
> >
> > Hi,
> >
> > I am a bit confused as to who I should send this email. Please let me
> > know if this is the wrong place.
> >
> > I am really, really close to making the whole thing work (I'll show in a
> > minute why I think that) but I'm stomped and need some help.
> >
> > I've dumped my WinNT workstation and replaced it with Linux. So far, I
> > can do exactly everything I was able to do (except updating my calendar
> > on the Exchange server used where I work), minus using Crystal Report.
> > I have installed it using CodeWeavers' CrossOver Office and it installed
> > without even a hiccup.
> > I've also installed unixODBC and tested the odbc.ini configuration using
> > isql. It works great when I try to connect to the company's AS400
> > database. The default library is set to my username and I can query
> > other libraries using the dot (.) as a separator (e.g: SELECT * from
> > OTHERLIB.OTHERTABLE).
> >
> > So far so good: UnixODBC works perfectly to talk to IBM's AS400.
> >
> > Now I need to tell Crystal which drivers to use. I've read on the web
> > that Crystal is not a very good student and thus ignores Windows'
> > ODBC.ini settings but checks what's in the registry. I've also come to
> > understand I must set ODBC.dll = "builtin, native" in my Wine's config
> > file so that it will try to use whatever is set for
> > LIB_ODBC_DRIVER_MANAGER env variable for Windows' ODBC connections.
> 
> Those instructions were put together in order to get Crystal Reports runtime 
> working.  Do you get anywhere if you change the override to "native"?
> 

This is the way I do it. Switch to native odbc32, install mdac (available
with ms office or download from MS site) and then setup the dsns
using odbcad32.exe.

/Ulrich