Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> works, thx

works, thx

From: pat zes <jonnypichler_at_gmx.net>
Date: Thu, 23 Jan 2003 22:13:42 +0100
Message-ID: <3e305adb$0$17580$91cee783@newsreader02.highway.telekom.at>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US