Home » Open Source » Programming Interfaces » help me overcome this error in jdbcodbc (windows xp,oracle9i)
help me overcome this error in jdbcodbc [message #446940] Thu, 11 March 2010 00:48 Go to next message
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
Re: help me overcome this error in jdbcodbc [message #446943 is a reply to message #446940] Thu, 11 March 2010 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is a bug in your code.

Regards
Michel
Re: help me overcome this error in jdbcodbc [message #446947 is a reply to message #446940] Thu, 11 March 2010 00:57 Go to previous messageGo to next message
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();
Re: help me overcome this error in jdbcodbc [message #446953 is a reply to message #446947] Thu, 11 March 2010 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And did you check the return code?
And did you declare the variables?

Regards
Michel
Re: help me overcome this error in jdbcodbc [message #446965 is a reply to message #446953] Thu, 11 March 2010 02:52 Go to previous messageGo to next message
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
Re: help me overcome this error in jdbcodbc [message #446969 is a reply to message #446965] Thu, 11 March 2010 03:13 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not answer my questions.

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


Current Time: Thu Mar 28 17:19:28 CDT 2024