Mailing List Archive


Back to the month index Back to the list index
Dirk Ohme (dohme@transtec.de)
Tue, 24 Sep 1996 16:45:10 +0200 (MET DST) 

Date: 	Tue, 24 Sep 1996 16:45:10 +0200 (MET DST)
From: Dirk Ohme <dohme@transtec.de>
Subject: Re: [mSQL] about ODBC
Message-Id: <Pine.SUN.3.93.960924163854.19624A-100000@cpu3>

Hi,

> I have questions again, about ODBC. Is it right that to interface
> msql I need to have with the gorta ODBC driver, an ODBC driver Manager ?

Yes.

> I have some difficulties to know what I really need, if I have to make
> an application on Windows 3.11, to interface the msql server on unix.
> Do I need anything else ?

You have to have the following files from

        ftp://ftp.Bond.edu.au/pub/Minerva/msql/Contrib/ODBC/

                installd.zip
                gortarts.2.10.0.3.zip

The "installd.zip" package contains an ODBC driver manager and an old
version of the Gorta ODBC driver for mSQL. You have to install this
package first. Then you may overwrite the Grota mSQL driver by a newer
version.

> I have read documentations about ODBC but it is still confused in my mind.
> What is an ODBC server ?

Don't know ;-) Normally there are only ODBC driver manager and drivers ...

> Is OBDC.DLL the driver Manager ?or is it something else ?
> After installing gorta odbc driver, I tested the installation with
> wmsqlrs.zip(it works),but it doesn't work with gorta.1.0.zip
> I have something like this (in the sql.log file):
>
> ....
> SQLConnect(hdbc18B70000,"test",11,"",0,"",0)
> SQLError(henv08670000,hdbc18B70000,hstmt00000000,szSqlState, ....
>
> Can anyone help me,please?
> Is it because I don't have the ODBC driver Manager ?

Not necessarily. ODBC.DLL should be the driver manager. If it would be the
driver manager, you should get errors at execution of "SQLAllocEnv". I
think your problem is, that you have not specified a DSN entry for "test"
in the driver manager setup.

There is a *.EXE within the 'installd.zip' package. Start it and configure
ODBC properly - what does your ODBC.INI contain?

  So long,
    -+- Dirk -+-

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!