Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

A weblog about Microsoft Access, SQL Azure, and SQL Server Tips and Code Samples
Browse by Tags · View All
Access Tips 45
Microsoft Access 45
VBA 41
database 33
Access 33
Code 32
Software development 31
Microsoft Access Software Development 26
Free Access Downloads 25
Software 25

Archive · View All
October 2010 4
September 2008 4
June 2009 4
January 2008 3
July 2009 3
June 2007 2
May 2009 2
March 2011 2
July 2010 2
August 2011 2

Patrick Wood's Blog

The New Microsoft Access and SQL Azure Information Center for Developers

Feb 22 2011 8:16AM by Patrick Wood   

Learning to develop Microsoft Access Cloud applications using SQL Azure as a back end is new territory. Although there are many similarities to developing an Access application that uses a hosted SQL Server database, there are also a number of differences that can trip you up unless you are aware of them. For example in one place Microsoft informs us that "Connecting to SQL Azure Database by using OLE DB is not supported." Since ADODB uses OLE DB this means that ADO is not supported for connecting to SQL Azure. However in other places we are informed that we can use ADO if we use the SQL Native Client and that support for OLE DB is being considered for official support. To make ADO work we must use Provider=SQLNCLI10; instead of Provider=SQLOLEDB; in our connection strings. This is the type of critical information we work to provide.

The biggest problem I faced when I began developing with Access and SQL Azure was finding the information and help I needed. I have found no single web page, site, help file, document, or source of information on how to develop Access Applications that could use SQL Azure. I spent countless hours using online searches, downloading documents, using SDKs, reading books and reading online to get the necessary information and solve problems. Some vital information could not be found so at times I had to learn through trial and error. There needs to be a better way for Access developers to get the crucial information we need to develop with SQL Azure.

So I am gathering together information, links, tips, scripts, and articles and building a Microsoft Access and SQL Azure Information Center for Developers to save you some valuable time and headaches. We will list important links, downloads, articles and blogs, scripts, code samples, tips, and new developments.

You are welcome to submit your own tips, code samples, links, comments, and articles. You can contact me at patwood@gainingaccess.net. Be sure to let us know if you want us to publish a link or email address so we can give you credit for your submission. We want to maintain a standard of high quality and usefulness so all submissions will be screened for value and relevance.

Even as I was preparing this post I received a request in an email from a developer asking where they could get information about developing Access and SQL Azure applications. It looks like I had better get busy.


Republished from Access Easy Tips [18 clicks].  Read the original version here [32134 clicks].

Patrick Wood
102 · 2% · 521
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"The New Microsoft Access and SQL Azure Information Center for Developers" rated 5 out of 5 by 1 readers
The New Microsoft Access and SQL Azure Information Center for Developers , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]