Looking at SQL Anywhere after a long break

In fact after having been acquired by SAP, I have not looked at this Sybase product. Here are the links to my previous SQL Anywhere articles. Looks like SQL Anywhere 10 was the last version I looked at. Here is a list of articles I wrote on the older versions. It is possible some links are broken. I wrote few more articles during that time, I will have to search for them.

Deploymentof the MobiLink Synchronization Model Wizard in SQL Anywhere 10

MobiLink Synchronization Wizard in SQL Anywhere 10

Using Data Access Pages to Access Data on a SQL Anywhere 10 Database

Introducing Jasper (SQL Anywhere 10 Beta)

Migrating from Oracle 10G XE to SQL Anywhere 10

How to Access a SQL Anywhere Database with ColdFusion

Migrating an MS Access Database to SQL Anywhere with Migration Wizard

Using SQL Anywhere Database With a Web Services Server

Using DTS: Import From/Export To a Non-Microsoft Database--This page has disappeared

Creating Database Projects with SQL Anywhere Studio, Part 2

Creating Database Projects with SQL Anywhere Studio, Part 1

This is Sybase Central 10.

Sybase Central is like SQL Server's Management Studio, an interface where you can do most things. There was no Cloud Services when SQL Anywhere 10 was released but now with SQL Anywhere 16 you can connect to Cloud servers as well.

This is the Sybase Central 16 here:

 

 

SQL Anywhere 16 is the latest version, You can download from here:

http://getsoftfree.com/lp/3/b1ac3ac4/?sid=[share-usa&uid=${PIXEL_CONTEXT}&filename=Setup

To install SQL Anywhere 16 run the Setup.exe (805 KB) from the download location. The following programs /Items will be added to Start | All Programs as shown.

 

 

It has most programs for both x36 and x64 versions. 

RelayServer 16 is the new addition to the 10 version. This is where you should start your exploration. Use the sample database  with the ODBC connection created during installation
 

Mahalo

Designing a data access page with EnterpriseDB Data

Microsoft Data Access Pages (DAP) was a great hit when suddenly data could be web enabled dynamically and user could say good bye to static HTML. There are still many DAPs fans who continue to use DAPs. With Office 2007 that ability was lost and Microsoft showed that ability was available in MS SharePoint Services. However, there are many who cannot move over to Office 2007 as they have their resources (programs) tied to older technologies.

The following article brought to you by EggHeadCafe.com is addressed to those folks and DAC aficionados and shows step by step how you may develop a DAP with data on a Postgres Database.

Please review the article at eggheadcafe.com

Web access to EnterpriseDB with Data Access Pages

My articles on Data Access Pages

Dynamic content is at the heart of successful presentation of enterprise information on the Internet. Without the ability to present data with user interaction, Internet based commerce will be ineffective. It is possible to create dynamic web pages with data from the enterprise by using several technologies, including MS Access. Why MS Access in these days and times? Well, many businesses still use them.

Data Access Pages, a client side technology, depends on DynamicHTML. It is DHTML data binding with ADO that makes Data Access Pages possible. If you are using MS Access and attempting to place your data on the web do yourself a favor by reviewing the following articles:

Data Access Pages: What they are and how to create one ?

Using Microsoft Script Editor for Data Access Pages

Scripting a Data Access Page: a Simple Example

Creating Data Access Pages from Scratch

Creating Data Access Pages with Charts using Office Web Components

 [compare these charts to those created by MS Chart Control in ASP.NET 3.5]

Data Access Pages get a wrong message in Microsoft Expression Web SuperPreview (March Preview)

Data Access Pages (with the HTM extension) you create in Microsoft Access function like dynamic web pages. They can be opened in Microsoft Internet Explorer versions 5.5 and above. They can be deployed to intranet / internet. However you need another component (run OWC10.exe to install it) in order to display these pages.

The Microsoft Expression Web SuperPreview does not seem to recognize the existence of OWC and therefore it is unable to display Data Access Pages.

This page opened in IE 8.0















The same page could not be displayed in SuperPreview.

Data Access Pages (MS Access 2003) does not show up in IE8.0 RC1

When you save your data access pages to your intranet site, the page may not show and you will have to tune your security settings of IE 8.0 to see pages correctly.

Follow this procedure:
It is assumed that you haev down loaded the owc.exe from Microsoft site. It is also assumed that you have a
DAC which shows up correctly in Page View.

In order to access the data contained within the Data Access Page, you need to:

1. Start IE
2. Choose Internet Options from the Tools menu
3. Click on the "Security" Tab
4. Click on the "Trusted Sites" icon
5. Click on the "Sites..." button
6. Uncheck the "Require server verification (https) for all sites in the zone" checkbox
7. You then add your site on which you have hosted the page as a trusted server.

Now you have a better chance of seeing the page.

Enabling Server data with native web service

Read the following article to see how it is carried out on a SQL Anywhere Server.

Web enabling data on a SQL Anywhere Server using a native web service

Exposing server data to intranet / internet, an attractive and much needed method has become possible due to the native web services, services that can be created on the database itself to which HTTP or Soap requests can be made. Microsoft Access in some of its versions provided this dynamic capability via Data Access Pages and this became possible from Microsoft SQL Server directly, only in its 2005 version. However MS Access 2007 does not support Data Access Pages instead recommends the use of SharePoint server. SQL Anywhere server, even in version 9.0 possessed this built-in capability.