Getting error "Can't resolve OCI Stack Trace: at Quest.Toad.Oracle.ToadOracleHome.get_Is64Bit() " when trying to connect to Oracle (4335242)

Complete error message

System.ArgumentException Can't resolve OCI Stack Trace: at Quest.Toad.Oracle.ToadOracleHome.get_Is64Bit() at Quest.Toad.Oracle.OracleConnectionControl.ConnectionHome(ArrayList toadOracleHomes, OracleConnectMediator connectMediator) at Quest.Toad.Oracle.OracleConnectionControl.RefreshHomesUI(OracleConnectMediator connectMediator) at Quest.Toad.Oracle.OracleConnectionControl.RefreshUI(ConnectMediator connectOptions) at Quest.Toad.Oracle.OracleConnectionControl.InitUI(ConnectMediator connectOptions, ConnectionFormStyle displayStyle) at Quest.Toad.ConnectionManager.ConnectionPropertiesControl.CreateContainer(ConnectMediator connectOptions) at Quest.Toad.ConnectionManager.ConnectionPropertiesControl.GetContainer(ConnectMediator mediatorTemplate) at Quest.Toad.ConnectionManager.ConnectionPropertiesControl.groupSelectionControl1_GroupChanged(Object sender, EventArgs e) at Quest.Toad.Grouping.GroupSelectionControl.OnGroupChanged() at Quest.Toad.Grouping.GroupSelectionControl.DoClosePopup(PopupCloseMode closeMode) at DevExpress.XtraEditors.PopupBaseEdit.ClosePopup(PopupCloseMode closeMode) at Quest.Toad.Grouping.GroupSelectionControl.groupTree_MouseUp(Object sender, MouseEventArgs e) at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e) at DevExpress.XtraTreeList.TreeList.OnMouseUp(MouseEventArgs e) at Quest.Toad.TreeList.ToadTreeList.OnMouseUp(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m) at DevExpress.XtraTreeList.TreeList.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)

Please install an Instant Client and try again.

To download an Instant Client, go to the following link:

http://www.oracle.com/technetwork/topics/winsoft-085727.html

Select the “instantclient-basic-nt-12.1.0.2.0.zip” file to download.

NOTE: If you wish for the SQL Plus tool for the Instant client, then you can also download the "instantclient-sqlplus-nt-12.1.0.2.0.zip" file.

A. Extract all Instant Client files to one directory file length path.

Example: C:\Ora12c_32bit

NOTE: If you downloaded the SQL Plus tool, extract all the files to the same location as the Instant client files. i.e. C:\Ora12c_32bit.


B. Place the new Oracle_Home path of Instant Client to the Environment Variable PATH.

1. Right click on My Computer and select Properties.
2. In the Advanced tab select "Environment Variables" button.
3. In the System Variables section, highlight Path and press edit.  Edit your path so that your Oracle Instant Client directory path is first.

For example: PATH=C:\Ora12c_32bit;

NOTE: Ensure you have a semicolon at the end, no space.

4. Click OK on all windows.


C. If planning to use TNSnames.ora file to Connect try the following:

1. Right click on the Computer icon on your Desktop and choose Properties option.
2. In the System window click on Advanced system settings link in the left pane.
3. In the System Properties window select Advanced tab and click on Environment Variables button.
4. Under the System variables section of the new window, NEW button.
5. Enter TNS_ADMIN for the variable name and for the variable value type in C:\TNSnames.
6. Then manually create a folder called TNSnames in your (C:) drive and paste your TNSnames.ora file there.