OraFAQ Forum: Programming Interfaces » help me overcome this error in jdbcodbc

Home » Open Source » Programming Interfaces » help me overcome this error in jdbcodbc (windows xp,oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help me overcome this error in jdbcodbc [message #446940]

Thu, 11 March 2010 00:48

punithap
Messages: 3
Registered: March 2010

Junior Member

i have installed oracle9i and now am trying to connect java to the database i have created.
i have created DSN and Test was successful.
But while executing the program i get error as java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
on SQL_HANDLE_ENV failed

how to solve this plse help....its very urgent

Report message to a moderator

Re: help me overcome this error in jdbcodbc [message #446943 is a reply to message #446940]

Thu, 11 March 2010 00:49

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is a bug in your code.

Regards
Michel

Report message to a moderator

Re: help me overcome this error in jdbcodbc [message #446947 is a reply to message #446940]

Thu, 11 March 2010 00:57

punithap
Messages: 3
Registered: March 2010

Junior Member

and in my java program i have given

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:mca","mca","mca");
stmt=con.createStatement();

Report message to a moderator

Re: help me overcome this error in jdbcodbc [message #446953 is a reply to message #446947]

Thu, 11 March 2010 01:19

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And did you check the return code?
And did you declare the variables?

Regards
Michel

Report message to a moderator

Re: help me overcome this error in jdbcodbc [message #446965 is a reply to message #446953]

Thu, 11 March 2010 02:52

punithap
Messages: 3
Registered: March 2010

Junior Member

my prgm is compiling without errors and it is taking data from text file...but when i try to connect with database..it throws error during runtime

Report message to a moderator

Re: help me overcome this error in jdbcodbc [message #446969 is a reply to message #446965]

Thu, 11 March 2010 03:13

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This does not answer my questions.

Regards
Michel

Report message to a moderator

Previous Topic:	ole2 in oracle 9i pl/sql
Next Topic:	Problems with Bind Variables and Prepared Statements

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 22 17:43:07 CDT 2025