Deployment Architecture

Getting error connecting to informix database db connect

mmohiuddin
Path Finder

I am getting the following error when connecting to informix database:

Encountered the following error while trying to save: In handler 'databases': Error connecting to database: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][4.13.80] Invalid database URL syntax: jdbc:informix-sqli://<IP address>/cms:INFORMIXSERVER=demo_on;user=axm1203;password=XXX. ERRORCODE=-4461, SQLSTATE=42815

I have properly placed the ifxjdbc.jar file under $SPLUNK_HOME/etc/apps/dbx/bin/lib location.

Is there someother configuration change that needs to be done on database_types config file to include the database URL syntax?

Please let me know.

Thanks,

Tags (1)
0 Karma
1 Solution

jimodonald
Contributor

the documentation specifies to add the 'informix.server=demo_on' as an additional parameter. That should be the name of the informix server connection, not exactly "demo_on" . the documentation could be more clear on that parameter.

Please award points if his helps solve your problem.

View solution in original post

0 Karma

jimodonald
Contributor

the documentation specifies to add the 'informix.server=demo_on' as an additional parameter. That should be the name of the informix server connection, not exactly "demo_on" . the documentation could be more clear on that parameter.

Please award points if his helps solve your problem.

0 Karma

mmohiuddin
Path Finder

Thanks Jim, I was able to establish the connection.

0 Karma
Get Updates on the Splunk Community!

Splunk AppDynamics Agents Webinar Series

Mark your calendars! On June 24th at 12PM PST, we’re going live with the second session of our Splunk ...

SplunkTrust Application Period is Officially OPEN!

It's that time, folks! The application/nomination period for the 2025 SplunkTrust is officially open! If you ...

Splunk Answers Content Calendar, June Edition II

Get ready to dive into Splunk Dashboard panels this week! We'll be tackling common questions around ...