Windows Desktop Shortcut that can take a user right to a query.

User, date Message
Written by feinstev
9 months ago
Category: General
3 posts since Thu, 09 Aug 12 		Is there anyway a user can execute a command file from within Windows, by using a CMD file, that would execute the program, log them in, identify the database, and take them to a specific query in the database. I'm converting right now from an old Access system I had put together, and would like to duplicate this feature with HeidiSQL.

Thanks,
Written by jfalch
9 months ago
222 posts since Sat, 17 Oct 09 		create a link (.lnk) to the heidisql.exe file, add parameter -d "name_of_stored_session" to the call, using the name of a session stored from heidisql´s session manager. This is the simplest method; all other db access paramters sre part of the session definition, set from the session manager.

Alternative is using one or several of -h "hostname" -P "port" -u "user" -p "password" -D "database_name". You can try and omit the quotes unless the value contains space, quote or other unusual characters. Also -P is usually not necessary (defaults to 3306).
Written by feinstev
9 months ago
3 posts since Thu, 09 Aug 12 		Thank you. So that gets me to the Database name. But I'm greedy, I want more. Can it take me to a specific query within that database, and then to the DATA Tab?
Written by ansgar
9 months ago
3950 posts since Fri, 07 Apr 06 		No, HeidiSQL has only the above mentioned parameters, which are documented in the readme file (see Help > Readme)
Written by jfalch
9 months ago
222 posts since Sat, 17 Oct 09 		You cannot specify a query, but you may specify an .sql file name as last parameter - this will open the file, load its contents into a query tab, and make this the current tab (F9 will then execute it).
It is, alas, not possible to specify a parameter to make the Data tab the current one (sigh)...
Written by ansgar
9 months ago
3950 posts since Fri, 07 Apr 06 		feinstev, I just tried to send you a pm to thank you for your donation, but the mail was bounced with a "550 Previous (cached) callout verification failure (state 13)". If you wish I can add a link to your website here on the donators page, if you want.
 

Please login to leave a reply, or register at first.