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!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...