Trax
Posts: 46
Joined: Wed May 06, 2009 5:24 pm

Oracle Database Connection Issue

Hello everyone,

We've been trying to connect to an Oracle database to install SQL code. We followed the Oracle Database Connection tutorial and we continue to get the error, SQL_STATE:IM006.

Given the credentials, is there another way to build a connection? what parameters are going to be used?

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle1.mydomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTDB)
)
)
User = ROOT01
Pass = Pass01

Thank you,
TRAX
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Oracle Database Connection Issue

Hello TRAX,

I'm not sure why this happens. In order to achieve what you want you should follow our "Configure Oracle Database Connection" article steps. If the connection fails to establish during installation, then can you please manually test your ODBC connection parameters and see if they are valid ones?

Also, please make sure that on your test machine is installed a 32-bit ODBC driver. Currently, our "SQL Scripts" support is not compatible with 64-bit ODBC drivers, therefore it is mandatory to have a 32-bit ODBC driver on your test machine. Starting with our next version of Advanced Installer we will add an improvement to our "SQL Scripts" support to use 64-bit ODBC drivers too.

Let us know if this helped.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Trax
Posts: 46
Joined: Wed May 06, 2009 5:24 pm

Re: Oracle Database Connection Issue

Hey Daniel,

Thanks for your reply. I have followed the article steps and still have the same issue and receive the SQL_STATE:IM006 error. I have also tested my ODBC parameters and was able to connect and make queries using SQL Developer.

I have also made sure that my test machine uses a 32-bit ODBC driver. Not sure what else I can do.


Thank you for you help,
TRAX
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Oracle Database Connection Issue

Hello TRAX,

Can you please send us the .AIP (project file) and a verbose log of the installation to support at advancedinstaller dot com so we can investigate them?

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Trax
Posts: 46
Joined: Wed May 06, 2009 5:24 pm

Re: Oracle Database Connection Issue

Hello again Daniel,

Just sent the .AIP file as well as the verbose log. Will be waiting for your reply!

Thanks,
TRAX

Return to “Common Problems”