All Apps and Add-ons

DB connect 2: Is "-" allowed in database names?

suarezry
Builder

I'm running Splunk v6.2.2 with DB Connect v2.0.2 to connect to MS SQL Server 2008 R2. I am able to Validate the connection. When trying to Query, I am able to select the Catalog but I get "No schema found". The database is called "vmware_vdi-events". Is "-" allowed in database names? If not then is there a workaround (I'm unable to change the database name)?

I am getting this error in dbx2.log:

06/04/2015 14:41:15 [ERROR] [init.py] Incorrect syntax near '-'.
Traceback (most recent call last):
File "/opt/hunk/lib/python2.7/site-packages/splunk/rest/init.py", line 184, in dispatch
methodOutput = method()
File "/opt/hunk/etc/apps/splunk_app_db_connect/bin/dbinfo.py", line 44, in handle_GET
return self.get_schemas(conn, cat)
File "/opt/hunk/etc/apps/splunk_app_db_connect/bin/health.py", line 206, in wrap_it
return w.logIt (self, f, l, *args, **kwargs)
File "/opt/hunk/etc/apps/splunk_app_db_connect/bin/health.py", line 177, in logIt
if err : raise err
AvroRemoteException: Incorrect syntax near '-'.

Tags (2)

worshamn
Contributor

Have a similar issue, mine says incorrect syntax near '.'
My database name has both a space and '-' in it. Seems to be a bug to me. When I switch to advanced query mode and put brackets [ ] around the database name in question (instead of quotes), I am able to return results.

0 Karma
Get Updates on the Splunk Community!

Index This | Why did the turkey cross the road?

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

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...