I really love this nice tool. Now I have aother question for you. After generating the sql from the FreeQueryBuilder, can I edit the sql script manually? For example, how to add the "distinct" to the sql script generated from the FreeQueryBuilder?
FreeReportBuilder has this function, but I found that it is quite buggy. I prefer to use SQLeonardo.
Thanks,
Hao
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Nicky,
I have more questions for you. Sorry for bothering you so much. I am really interested in your project.
question 1:
I have multiple databases on a SQL Server, and I want to connect to them at the same time. In SQLeonardo, it seems that I have to define a "new datasource" for each database that is the default database for the user.
But the problem is that I have to add a different user on my SQL Server for each database that I want to connect. Can I use one user name to connect to all my databases?
question 2:
Does SQLeonardo support the query crossing multiple databases? It looks like that all tables in a query have to be on the same database.
Thanks,
Hao
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For example, I have 5 databases on the same SQL Server. In order to connect to them at the same time in SQLeonardo, I have to create 5 users in my SQL Server, and assign one of the five databases as the default database to each user respectively. Am I right?
Is there a way that I can use one username to connect to multiple databases on the same SQL Server in SQLeonardo?
Thanks,
Hao
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Nicky,
I really love this nice tool. Now I have aother question for you. After generating the sql from the FreeQueryBuilder, can I edit the sql script manually? For example, how to add the "distinct" to the sql script generated from the FreeQueryBuilder?
FreeReportBuilder has this function, but I found that it is quite buggy. I prefer to use SQLeonardo.
Thanks,
Hao
Hi,
You can not edit the script manually. You can copy it and then...
In SQLeonardo to add the "distinct" use the menu: Action>Distinct
Nicky
Hi Nicky,
I have more questions for you. Sorry for bothering you so much. I am really interested in your project.
question 1:
I have multiple databases on a SQL Server, and I want to connect to them at the same time. In SQLeonardo, it seems that I have to define a "new datasource" for each database that is the default database for the user.
But the problem is that I have to add a different user on my SQL Server for each database that I want to connect. Can I use one user name to connect to all my databases?
question 2:
Does SQLeonardo support the query crossing multiple databases? It looks like that all tables in a query have to be on the same database.
Thanks,
Hao
Hi Hao,
...no problem for your questions, I am be happy to help you (where possible).
response 1:
1 datasource_profile == 1 database (SQLServer case)
response 2:
it would be beautiful to put out this, also among different db
Nicky
Hi Nicky,
Just want to confirm your answer.
For example, I have 5 databases on the same SQL Server. In order to connect to them at the same time in SQLeonardo, I have to create 5 users in my SQL Server, and assign one of the five databases as the default database to each user respectively. Am I right?
Is there a way that I can use one username to connect to multiple databases on the same SQL Server in SQLeonardo?
Thanks,
Hao
Hello,
SQLeonardo need for each database a connection, there's not availability to create a query on more databases at same time.
Nicky