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!

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...