works, thx

aaaaaAAAAAAAAAAA
stupid me
i just installed it (the driver) to the wrong directory oh f*****k - 7 hours of trying around *sigh*

thx anyway,
patrick

"Karsten Farrell" <kfarrell_at_belgariad.com> schrieb im Newsbeitrag news:eDYX9.2248$%g1.1951_at_newssvr19.news.prodigy.com...
> pat zes wrote:
> > i have an oracle9.0.1.1.0 db fully working on my system (winxp sp1).
> >
> > i want to connect to it using ODBC.
> >
> > first i tried the microsoft-odbc-driver-for-oracle and it worked for
login
> > but i got an error when i tried to execute a sql-statement
> >
> > i downloaded the ODBC-driver from oracle.com (version 9.0.1.5)
> > when i want to setup a new DSN in controlpanel everything seems ok but
when
> > i try to use it, it just fails connecting.
> > when i press the "test connection" button in the settings of the oracle
> > driver it says: "unable to connect. sql-state=IM004" and that something
went
> > wrong with the sqlAllocHandle-call while getting the environment handle.
> > even before asking for username/pwd.
> >
> > i entered the following values: in TNS Service Name the name of my
database
> > (there can't be anything wrong - the db is on the same machine and
TNSping
> > works)
> > user ID is left blank
> >
> > tried all settings that seem relevant - read the helpfile carefully -
> > nothing works - same thing everytime... have you got an idea?
> >
> > thanks in advance for helping,
> > patrick
> >
> The following describes the SQLAllocEnv call (which allocates a handle):
>
> http://odbcrouter.com/api/SQLAllocEnv.shtml
>
> You might also try the following (someone else had the same problem as
> you, and found a solution):
>
> http://www.orafaq.net/msgboard/windows/messages/2237.htm
>
Received on Thu Jan 23 2003 - 15:13:42 CST