Oracle 10g Connection problem

Posts   
 
    
dstrukov
User
Posts: 10
Joined: 08-Dec-2009
# Posted on: 10-Dec-2009 13:22:01   

Good day,

Sorry to bother you so often, but as soon as i overcame the driver loading issue, i have run into connection problem.

When pess fill in all data and press connect on Oracle 10g/11g Drivler (ODP.NET 10.2.x) screen, i get the following exception:


Object reference not set to an instance of an object.

Stack trace:


-----[Core exception]--------------------
   at SD.LLBLGen.Pro.DBDrivers.Oracle10g.OracleDBDriver.RetrieveAllCatalogsBody(String connectionString)
   at SD.LLBLGen.Pro.DBDrivers.Oracle10g.OracleDBDriver.RetrieveCatalogs(String serverName, String userID, String password)
   at SD.LLBLGen.Pro.DBDrivers.Oracle10g.OracleConnectionData.RetrieveSchemas()
   at SD.LLBLGen.Pro.DBDrivers.Oracle10g.OracleConnectionData.ConnectAndRetrieveSchemas()
   at SD.LLBLGen.Pro.DBDrivers.Oracle10g.OracleConnectionData._connectButton_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


My tnsnames.ora file is in correct location (10.2.0\client_1\NETWORK\ADMIN) and correctly configured:

VENDOR = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.9)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = VENDOR) ) )

any idea on how to work arround it?

Once again - configuration: Windows Vista 64bit LLBLGenPro 2.6 final DEMO (October 9th, 2009) + x86 louncher see thread: (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=17043) ODP.NET 2.102.2.20 Oracle client 10g latest

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39865
Joined: 17-Aug-2003
# Posted on: 10-Dec-2009 22:11:53   

We will look into it. We'll provide you a debug build of the driver to see on what line the driver crashes. Sorry for these inconveniences...

Frans Bouma | Lead developer LLBLGen Pro
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39865
Joined: 17-Aug-2003
# Posted on: 11-Dec-2009 10:47:38   

We saw there's a 64bit ODP.NET as well (see your other thread). The 10gR2 32bit ODP.NET installer refused to run on windows 7 64bit (dunno why, it required windows 6.0 or lower, windows 7 is v6.1), I'll now try the 64bit bit odp.net and see if that works at all on windows 7 64bit with llblgen pro.

I'll attach the debug driver and pdb file in a second so you can run these (on 32bit) and see what linenumber the exception occurs.

Edit Attached. Please copy the driver + pdb file in the Oracle10g folder and run the designer on 32bit, to reveal the line number where the error occurs exactly. (complete with stacktrace please).

However, as I said in the other thread, it's likely better to use 64bit ODP.NET on 64bit windows, considering it's a stack of wrappers around other code.

Frans Bouma | Lead developer LLBLGen Pro