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!

Developer Spotlight with Brett Adams

In our third Spotlight feature, we're excited to shine a light on Brett—a Splunk consultant, innovative ...

Index This | What can you do to make 55,555 equal 500?

April 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Say goodbye to manually analyzing phishing and malware threats with Splunk Attack ...

In today’s evolving threat landscape, we understand you’re constantly bombarded with phishing and malware ...