SQL LocalDB Support

Interested in developing new plug-ins? Got one to share? Post here!
JohnGalt
Posts: 58
Joined: Mon Sep 08, 2008 2:14 pm

SQL LocalDB Support

Postby JohnGalt » Mon Mar 12, 2012 6:31 am

I see the post and email regarding 2012 Express, but I don't see anything about the far superior and easier to install for Devs, LocalDB.

Is it supported? If not, when?

Should be able to specify instance, filestreaming enabled and what level, sql/integrated security and default sa password if sql security enabled via UI.

Thanks!

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: SQL LocalDB Support

Postby FrancescoT » Thu May 31, 2012 7:47 am

Dear John,

Actually seems not possible.
Anyway I will check for it and I'll tell you.

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE

erausner
Posts: 3
Joined: Wed Jul 06, 2011 12:20 am

Re: SQL LocalDB Support

Postby erausner » Thu Nov 15, 2012 9:08 am

So, what happened in regards to this thread?

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: SQL LocalDB Support

Postby FrancescoT » Thu Nov 15, 2012 9:22 am

Dear User,

I can only confirm that it is not actually availble with IA.
I will log this as request to our dev team ... but no promises on delivery.

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE

erausner
Posts: 3
Joined: Wed Jul 06, 2011 12:20 am

Re: SQL LocalDB Support

Postby erausner » Thu Nov 15, 2012 9:25 am

FrancescoT wrote:Dear User,

I can only confirm that it is not actually availble with IA.
I will log this as request to our dev team ... but no promises on delivery.

Regards


Thanks Francesco. Keep us posted and thank you for a swift answer.

Werner
Posts: 8
Joined: Fri May 13, 2011 12:08 am

Re: SQL LocalDB Support

Postby Werner » Mon Dec 03, 2012 7:15 am

I also realized that the plugin does not recognize LocalDB.

The plugin is not usable for us if it does not support LocalDB.

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: SQL LocalDB Support

Postby FrancescoT » Mon Dec 03, 2012 12:45 pm

Dear Werner,

honestly I never used it with LocalDB.

If you want to interact from CMD windows with a LocalDB installation, do you still use "SQLExec"?

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE

Werner
Posts: 8
Joined: Fri May 13, 2011 12:08 am

Re: SQL LocalDB Support

Postby Werner » Tue Dec 04, 2012 2:08 am

Hi Francesco,

I never used SQLExec from CMD window.

But after having installed SqlLocalDB.MSI (the inst file from MS for LocalDB based on SQL Server 2012 Express) I can connect to LocalDB using instance name "(localdb)\v11.0" from SQL Server 2012 Management Studio as well as from my application like to every other "normal" SQL Server 2012 database.

My app uses
SQLRETURN SQL_API SQLExecDirect
(
SQLHSTMT StatementHandle,
__in_ecount_opt(TextLength) SQLCHAR* StatementText,
SQLINTEGER TextLength
);
from SQL.h (from MS) for SQL commands.

But from InstallAware the command "Detect MS SQL instances" does not detect LocalDB instances
and "Microsoft SQL Server Script" returns errors if called with instance name "(localdb)\v11.0".

For info about LocalDB see http://msdn.microsoft.com/en-us/library/hh510202.aspx

Regards

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: SQL LocalDB Support

Postby FrancescoT » Wed Dec 05, 2012 10:43 am

Dear Werner,

I will try to install the MS SQL LocalDb to verify this behaviour ... I never used it and I am not able to give you a proper answer actually.

I will be back as soon as possible.

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE

Werner
Posts: 8
Joined: Fri May 13, 2011 12:08 am

Re: SQL LocalDB Support

Postby Werner » Mon Jan 14, 2013 8:52 am

Hi Francesco,

any progress in this matter ?

Regards

Werner

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: SQL LocalDB Support

Postby FrancescoT » Mon Jan 14, 2013 2:14 pm

Dear Werner,

I have added this request to our feature request list, but actually I can tell when and if it will be released.

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE

chamsoft
Posts: 11
Joined: Tue Jun 24, 2008 6:12 pm

Re: SQL LocalDB Support

Postby chamsoft » Tue Jan 14, 2014 3:47 pm

Hi Francesco, just wondering if there has been any progress on this?

Regards
David

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: SQL LocalDB Support

Postby FrancescoT » Thu Jan 16, 2014 1:23 pm

None currently.

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE

chamsoft
Posts: 11
Joined: Tue Jun 24, 2008 6:12 pm

Re: SQL LocalDB Support

Postby chamsoft » Tue Mar 25, 2014 12:38 am

Hi Francesco, I assume there has still been no progress on this? If not I need to work out some other way to install LocalDB myself. Could you please provide some guidance on how to use the msi provided by Microsoft from within an installaware script?

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: SQL LocalDB Support

Postby FrancescoT » Tue Mar 25, 2014 12:46 pm

Dear Chamsoft,

Unfortunately, the LocalDB Runtime package is not yet included with our product.

Anyway, InstallAware is an extensible development tool and it is possible to customize or to extend its functionality.

There two possible ways to include that Runtime package with your project.

A- you could add the "LocalDB " Redist Installer distributed by Microsoft, to the Project SUPPORTDIR and then to call it using "RUN PROGRAM" from your main script. The SUPPORTDIR is a special temporary location used at Runtime by the installer. To find out how to use the SUPPORTDIR, please search for "Modifying Support Files" with the included IA documentation (just press F1 in IA IDE).

B- You can integrate additional custom runtime packages with creating a custom IA runtime package module. The document "Extending the Application Runtimes View" describes all the steps required to develop and integrate a custom IA runtime package module.
http://www.installaware.com/publications-whitepapers.htm

Hope this helps you.

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE


Return to “Plug-In Development”

Who is online

Users browsing this forum: No registered users and 50 guests