Thread: SQLAPI++ library

I seem to be getting an unhandled exception though... Throws an exception when trying to connect... My Username : example Password : example Conn : XE are all correct because i can access the DB

Originally Posted by hk_mp5kpdw

That's where all this try/catch code comes in handy:

Code:

    // Make sure we get a connection to the database in question, otherwise quit.
try
{
    cout << "Enter password for user YOUR_USER_HERE: ";
    cin >> strPass;
    conn = env->createConnection(strUser,strPass,strConn);
}
catch (SQLException &sqlExcp)
{
    cerr << sqlExcp.getErrorCode() << ": " << sqlExcp.getMessage()
         << "Press a key to continue..." << endl;
    cin.ignore();						// Ignore previous ws
    cin.get();
    Environment::terminateEnvironment(env);
    return EXIT_FAILURE;
}

Can you post a small sample of your code, at least the code around where you attempt to do the env->CreateConnection call?

Code:

Environment * env = Environment::createEnvironment();
    Connection * conn = NULL;
    const string strUser = "example";       // User we connect as
    const string strConn = "XE";   // Database connection
    string strPass;                                // Password for above

    // Make sure we get a connection to the database in question, otherwise quit.
    try
    {
        cout << "Enter password for user YOUR_USER_HERE: ";
        cin >> strPass;
        conn = env->createConnection(strUser,strPass,strConn);
    }
    catch (SQLException &sqlExcp)
    {
        cerr << sqlExcp.getErrorCode() << ": " << sqlExcp.getMessage()
			 << "Press a key to continue..." << endl;
        cin.ignore();						// Ignore previous ws
        cin.get();
        Environment::terminateEnvironment(env);
        return EXIT_FAILURE;
    }

The red part doesn't print "Press a key to continue" instead i get 24960: printed and a Microsoft DEBUG error window with don't send/send error options ... I think it throws an exception on the red part

Originally Posted by csonx_p

Code:

Environment * env = Environment::createEnvironment();
    Connection * conn = NULL;
    const string strUser = "example";       // User we connect as
    const string strConn = "XE";   // Database connection
    string strPass;                                // Password for above

    // Make sure we get a connection to the database in question, otherwise quit.
    try
    {
        cout << "Enter password for user YOUR_USER_HERE: ";
        cin >> strPass;
        conn = env->createConnection(strUser,strPass,strConn);
    }
    catch (SQLException &sqlExcp)
    {
        cerr << sqlExcp.getErrorCode() << ": " << sqlExcp.getMessage()
			 << "Press a key to continue..." << endl;
        cin.ignore();						// Ignore previous ws
        cin.get();
        Environment::terminateEnvironment(env);
        return EXIT_FAILURE;
    }

The red part doesn't print "Press a key to continue" instead i get 24960: printed and a Microsoft DEBUG error window with don't send/send error options ... I think it throws an exception on the red part

"Unhandled exception at 0x104f1795 (msvcp80d.dll) in dbtester.exe: 0xC0000005: Access violation reading location 0xcccccccc."

Originally Posted by hk_mp5kpdw

What's your TNS_NAMES file look like (if you don't mind ...you can omit stuff like IP addresses)?

Code:

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = officepc)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ORACLR_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) 
    ) 
    (CONNECT_DATA = 
      (SID = CLRExtProc) 
      (PRESENTATION = RO) 
    ) 
  )

i didn;t specify any ip address anywhere AFAIC

Originally Posted by hk_mp5kpdw

I think this might be a DLL issue... since the code seems to compile/link fine. In the instructions for downloading/installing the library code you were instructed to unzip the Oracle libraries somewhere (there should have been some DLLs for you to download [or maybe they came with everything else] as well). Can you verify all the libraries .LIB and .DLL that you've downloaded. Also there were those instructions to put the location (the folder path) of the .DLL files into your path environment variable. Did you do that?

unzipped to C:\oraclexe\app\oracle\product\10.2.0\server\OCI\l ib\MSVC\Vc8
got the needed lib/dll there ... went to project properties and added other dependencies pointing to this path

Originally Posted by hk_mp5kpdw

I think this might be a DLL issue... since the code seems to compile/link fine. In the instructions for downloading/installing the library code you were instructed to unzip the Oracle libraries somewhere (there should have been some DLLs for you to download [or maybe they came with everything else] as well). Can you verify all the libraries .LIB and .DLL that you've downloaded. Also there were those instructions to put the location (the folder path) of the .DLL files into your path environment variable. Did you do that?

How do i attach files here? would like to show you my project environmental settings ....

Originally Posted by hk_mp5kpdw

Project properties and the dependencies takes care of the .lib issues and linking. Setting up the PATH such that the folder where the .dll files are is included takes care of those (according to the instructions) They are probably in the same location so your first PATH setting should also be pointing to that same folder as in your project's "Additional Library Directories". You should have the following LIB/DLLs present wherever they may be:

I've also got a couple other files in that directory for whatever reason:



When you click on Post Reply, there is an area titled "Additional Options" with a "Manage Attachments" button. Click on that button and another pop-up window should appear where you can browse files on your computer and then click on the "Upload" button for each file you wish to attach. When you're done with all the files you want to attach you can close the pop-up window with the "Close this Window" button. When you finally post, those files will be attached to your post.

this statement ...

Code:

sqlExcp.getMessage()

its what's throwing "Access violation reading location 0xcccccccc", i doubt if it has anything to do with the libraries ...

This code

Code:

conn = env->createConnection(strUser,strPass,strConn);

probably threw an exception and was catched ...

Code:

    try
    {
        cout << "Enter password for user YOUR_USER_HERE: ";
        cin >> strPass;
        conn = env->createConnection(strUser,strPass,strConn);
    }

    // HERE ... 
    catch (SQLException &sqlExcp)
    {
        cerr << sqlExcp.getMessage() << "Press a key to continue..." << endl;
        cin.ignore();						// Ignore previous ws
        cin.get();
        Environment::terminateEnvironment(env);
        return EXIT_FAILURE;
    }

but then somehow sqlExcp.getMessage() is throwing another exception ???

Originally Posted by hk_mp5kpdw

Project properties and the dependencies takes care of the .lib issues and linking. Setting up the PATH such that the folder where the .dll files are is included takes care of those (according to the instructions) They are probably in the same location so your first PATH setting should also be pointing to that same folder as in your project's "Additional Library Directories". You should have the following LIB/DLLs present wherever they may be:

I've also got a couple other files in that directory for whatever reason:



When you click on Post Reply, there is an area titled "Additional Options" with a "Manage Attachments" button. Click on that button and another pop-up window should appear where you can browse files on your computer and then click on the "Upload" button for each file you wish to attach. When you're done with all the files you want to attach you can close the pop-up window with the "Close this Window" button. When you finally post, those files will be attached to your post.

where do i get oraociei10.dll file as it seems to be the only file not present according to your list.....