Table of Contents. Getting Started Introduction Getting Started with MotoCalc. What's New What's New in MotoCalc 8? The MotoWizard Using the MotoWizard. I just downloaded and installed LO4. I attempted to connect to one of my Access 2013 databases. However I get the error message: The connection to the database could not be established. The connection could not be created. Maybe the necessary data provider is not installed. What is the solution for this.
Prerequisites: • Microsoft Azure Account: If you do not have account, open a. It comes with one-month free trial. Auto Finance Affiliate Program on this page. • Office 365 subscription • Visual Studio 2013/2015: You need to have Visual Studio installed on your machine. • Install the or the. Let’s start: Create Azure Web application: • Login to with your Azure Account.
• Go to New, Web + Mobile, then Web App. Provide a unique name, and click Create. • It will take a moment to create app web and display details. • If you click on URL, it will open empty web app. We’ll use this app later to host add-in. Create SQL Database in Azure • In Azure portal, Go to New, Data + Storage, then SQL Database. Provide DB Name.
• In server configuration - You can either select an existing server OR select ‘ Create a new server’. In this project I am using an existing Database Server I created earlier. Now select database, and then click Create. For new server: Server name can be any unique name, user name & password – a new user name and password to connect to DB server, Location as south-east Asia.
Select source – ‘ Blank database’, Pricing – leave it to default ‘ Standard S0’, Resource Group – create new as ‘ webappsample’. Click ‘ Create’. • It will take few minutes to create the DB and it will be visible in SQL Databases where you can see the properties and manage settings. • Now we need to allow Client IP address to connect to SQL DB server. In left navigation, click on All resources, then select the SQL DB server we created, click all settings and select Firewall.
• You can see client IP address there. Click on ‘ Add Client IP’ link, IP will be added in the panel below. Now click Save. • We are all set here. Create Tables in Database • Open Visual Studio 2013/2015. In server explorer, select SQL Server Object Explorer.
• Click on Add SQL Server button. • Provide the SQL server name you’ve already created.
Select ‘ SQL Server Authentication’ and enter user name & password you provided while creating database server in Azure, click Connect. • Once connected, you can see the ‘ mymuzicdb’ in explorer. Navigate to Table, right click and create new table. • Create table ‘ Albums’ with 4 columns as given in snapshot. Use ‘ Update’ button to update database. • Now table is ready to use.