APL+Win and Microsoft SQL Express 2012

The discussion area related to the APLNext Database Interface Tools that simplify the use of Microsoft SQL Server, Oracle or IBM DB2 data bases in an APL+Win application system.

APL+Win and Microsoft SQL Express 2012

Postby joe_blaze » May 7th, 2012, 8:15 am

The attached pdf-format documents provide information about:
    Installing Microsoft SQL Express 2012
    Using the Microsoft SQL Server Management Studio
    Using the APLNext Database Interface Tools for SQL Server


Microsoft SQL Express 2012 is a free version of Microsoft SQL Server 2012 which has the full functionality of the commercial versions, a relatively large data limit of 6Gb and can be distributedd royalty-free. The attached document provides detailed instructions for installing this software.

The Microsoft SQL Server Management Studio is an application to create and manage Microsoft SQL databases. It is included in the installation of Microsoft SQL Express 2012. The attached document provides detailed instructions to use this software to create databases, including a sample database.

The APLNext Database Interface Tools for SQL Server is an interface between APL+Win and Microsoft SQL Server using methods which support the Transact SQL (structured query language) used by Microsoft SQL Server. The attached document provides detailed instructions to use this software with a sample database.
Attachments
Using APLNext DataBase Interface Tools for Microsoft SQL Server.pdf
(2.16 MiB) Downloaded 451 times
Microsoft SQL Server 2012 Management Studio.pdf
(1.85 MiB) Downloaded 445 times
Installing Microsoft SQL Express 2012.pdf
(1001.27 KiB) Downloaded 438 times
Last edited by joe_blaze on May 9th, 2012, 12:09 am, edited 1 time in total.
joe_blaze
 
Posts: 383
Joined: February 11th, 2007, 3:09 am
Location: Box 361 Brielle, NJ 08730-0361

localdb

Postby G_Littlefield » May 8th, 2012, 5:48 pm

Is it possible to connect to localdb with the APLNext Database Interface Tools for SQL Server? If so, how you do that?
G_Littlefield
 

Microsoft SQL Express 2012 - localdb

Postby joe_blaze » May 8th, 2012, 11:28 pm

The attached document "Use Microsoft SQL Server Management Studio to Connect to LocalDB.pdf" describes how to use Microsoft SQL Server Mangement Studio to connect to and manage the 'localdb' SQL Server which can be installed with Microsoft SQL Express 2012.
Attachments
Use Microsoft SQL Server Management Studio to Connect to LocalDB.pdf
(803.78 KiB) Downloaded 476 times
joe_blaze
 
Posts: 383
Joined: February 11th, 2007, 3:09 am
Location: Box 361 Brielle, NJ 08730-0361

localdb supported only in .Net 4.0+ projects

Postby joe_blaze » May 9th, 2012, 12:05 am

The attached document indicates why the current (as of 05/09/2012) version of the APLNext Database Interface Tools for SQL Server cannot access the 'localdb' instance of the Microsoft SQL Express 2012 database software.

A future version of the APLNext Database Interface Tools for SQL Server may resolve this Microsoft limitation.
Attachments
Using LocalDB with APLNext Database Interface Tools for SQL Server.pdf
(486.71 KiB) Downloaded 403 times
joe_blaze
 
Posts: 383
Joined: February 11th, 2007, 3:09 am
Location: Box 361 Brielle, NJ 08730-0361


Return to APLNext Database Interface Tools

Who is online

Users browsing this forum: No registered users and 1 guest

cron