cancel
Showing results for 
Search instead for 
Did you mean: 

dbisql command line options

Former Member
0 Kudos

Hi all,

I've just added a HANA client to my computer and came across a few details when trying to connect to HANA using interactive SQL.

1. (this is not precisely HANA related, but came to my attention in this context) There are command line options to advise dbisql to connect to a HANA (-hana), IQ (-iq) or UltraLite (-ul) database, but I didn't find any for SQL Anywhere or Generic ODBC. When starting dbisql without parameters, the connect dialog box is preset with the database type I had picked the last time. I think additional options for these two types would be systematic.

2. When connecting to HANA using an ODBC data source, the ODBC style connection parameters UID and PWD are not recognized. "user" and "password" are expected instead.

dbisql -hana -c "dsn=VolkerOnMonsoon;uid=Volker;pwd=Ger0nimo" doesn't recognize the userid / user name and prompts for missing connection parameters.

dbisql -c "dsn=VolkerOnMonsoon;uid=Volker;pwd=Ger0nimo" works, but gets me a generic ODBC connection.

dbisql -hana -c "dsn=VolkerOnMonsoon;user=Volker;password=Ger0nimo" works and gets me a qualified HANA connection.

dbisql -datasource VolkerOnMonsoon -c "user=Volker;password=Ger0nimo" dto.

dbisql -datasource VolkerOnMonsoon -c "uid=Volker;pwd=Ger0nimo" brings me to a SAP HANA connect dialog without user name or password preset.

(of course Ger0nimo is not the real password)

What I would consider consistent: At least when connecting using an ODBC data source name, ODBC connection parameters should be recognized, regardless of database type. If dbisql recognizes that the data source is one of the explicitly supported systems, all the better.

What do you think about my ideas?

Thanks & regards

Volker

Accepted Solutions (0)

Answers (1)

Answers (1)

jeff_albion
Employee
Employee
0 Kudos

Hi Volker,

1. I've opened CR #782623 to address this point. This behaviour has also affected me when I was doing my HANA testing - you can't connect to a SQL Anywhere database if you have manually changed the database type. I agree, this is not convenient at all...

2. We are aware of the discrepancy in the HANA connection options. I had made an attempt to document some of these settings on the "Starting Interactive SQL" page a while ago: DocCommentXchange. Adding a DSN to the mix really just complicates the problem further - is this a major issue for you?

Regards,

Jeff Albion

SAP Active Global Support

Former Member
0 Kudos

Thanks Jeff,

none of these is a major issue for me. It's more like I'm trying to suggest what I would consider improvements. For anything causing s.th. similar to pain, I'd use a different channel.

Thanks again & best regards

Volker

JasonHinsperger
Advisor
Advisor
0 Kudos

Thanks Volker - I had already forwarded your suggestions to the dbisql developers, but I also should have posted a reply saying that I did so.

--Jason

Former Member
0 Kudos

Thank you, Jason.

Regards

Volker