cancel
Showing results for 
Search instead for 
Did you mean: 

I got error message [ASE Error SQL30011:01S00][SAP][ASE ODBC Driver]Invalid port number

0 Kudos

Dear all,

i'm configuring in ECC 6.0 EHP8 HANA DB e connection to SAP IQ database using DBCO Transaction. I've defined the following parameter DB connection = ILM_STOR_IQ_servername DBMS = SIQ (tried also with SYB)

User name = sapuser (defined in sap iq DB)

DB password = password

conn info =servername:2640 (ip port db has been started)

conn limit = 5

optimum conn = 5 .

Telnet command is ok to port 2640 but with report

ADBC_TEST_CONNECTION

specifying DBCN entry I got error msg

[ASE Error SQL30011:01S00][SAP][ASE ODBC Driver]Invalid port number

Any help will be appreciated

Regards

Giovanni

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

thanks Harpreet problem solved with correct driver

Answers (2)

Answers (2)

Incorrect odbc driver is getting loaded. This error "ASE ODBC Driver]Invalid port number", means ASE (Adaptive Server Enterprise) odbc driver is getting loaded instead of IQ odbc driver. You should have a libdbodbc16.so or libdbodbc17.so depending on your version of IQ in your path before the ASE odbc driver.

HTH
Harpreet

0 Kudos

solved with the right odbc driver