SQL Anywhere 10 is still in Beta and soon it will be released. I think it is a very interesting product. I have worked with verion 9.0, and this version looks lot better.
Let's say I have a database on Oracle 10g XE around which I need to set up a mobile application, a migration of the table to SQL Anywhere would be just what I would be looking for.
http://www.devshed.com/c/a/Oracle/Migrating-from-Oracle-10G-XE-to-SQL-Anywhere-10/
XML Islands and ADO will be what I will be writing about next week or so...
http://www.devarticles.com/c/a/XML/The-Why-and-How-of-XML-Data-Islands/
This is possible only in ADO.NET 2.0. Too much RAD, I may forget how to code.
http://www.aspfree.com/c/a/Database-Code/Using-the-AccessDataSource-Control-in-VS-2005/
Thursday, July 20, 2006
Creating a new database in SQL 2005 Server
Creating a new database in SQL 2005 Server
Step-by-step procedure to create a new database
It's very easy to create a SQL 2005 database using the SQL 2005 Server Management Studio. This has not changed very much from SQL Serve except that the GUI has changed somewhat and its architecture is more tightly integrated with the other services and the .NET framework. Let's go directly and create a database, and when you find time, read about it in the BOL [Book on line]. Of course you may send me an email, or look up my other SQL and database articles at: http://www.angelfire.com/vt2/hodentek.
I assume you have installed the SQL Server and you are the sa. Login and connect to the Database Engine as shown in the next picture.
If login is accepted you will see the next screen. Right click on the database node to reveal the drop-down.
On this menu click on New Database... sub-menu item.
This opens up the next window as shown. You must give a name, the name of your database; keep it simple by associating it with some functionality, like say Address_ Book, Accounting, etc. In fact this is all that is needed to create the database. I created a database called SsisEditor by typing "SsisEditor" in Database name box and clicked OK. Presto the SsisEditor database was created.
The program creates many objects in this database that are needed because the two files created during this process are important files with extensions *.mdf for data and *.ldf for the transaction log (a log for things that gets changed in the database).
Step-by-step procedure to create a new database
It's very easy to create a SQL 2005 database using the SQL 2005 Server Management Studio. This has not changed very much from SQL Serve except that the GUI has changed somewhat and its architecture is more tightly integrated with the other services and the .NET framework. Let's go directly and create a database, and when you find time, read about it in the BOL [Book on line]. Of course you may send me an email, or look up my other SQL and database articles at: http://www.angelfire.com/vt2/hodentek.
I assume you have installed the SQL Server and you are the sa. Login and connect to the Database Engine as shown in the next picture.
If login is accepted you will see the next screen. Right click on the database node to reveal the drop-down.
On this menu click on New Database... sub-menu item.
This opens up the next window as shown. You must give a name, the name of your database; keep it simple by associating it with some functionality, like say Address_ Book, Accounting, etc. In fact this is all that is needed to create the database. I created a database called SsisEditor by typing "SsisEditor" in Database name box and clicked OK. Presto the SsisEditor database was created.
The program creates many objects in this database that are needed because the two files created during this process are important files with extensions *.mdf for data and *.ldf for the transaction log (a log for things that gets changed in the database).
Friday, July 14, 2006
Zidane apologizes but does not regret
It does not help France now, but at least he cares for some people. I am not sure whether he apologized by himself, or he was made to, by his manager. Now let's see what our italiano does?
In the mean time despite Copa de Mundo, I have been able to add a few more articles:
On Oracle 10G XE:
Creating an Oracle Web Service Client for a Web Service Created in VS 2005
Developing Applications on Oracle 10g XE: Generating a Report
SQL Script Support in Oracle 10G Express Edition
On VB.NET:
Exploring Dailogs Controls in VB.NET
Creating a Database Project in VS 2005
Explosion on Mumbai trains costed ~190 lives. The people who ride trains in Mumbai are the guys who carry food to the workers in Bomaby, milk men, daily workers who clean buildings, etc.
What a waste of human life? Misery would only appear ten fold more.
In the mean time despite Copa de Mundo, I have been able to add a few more articles:
On Oracle 10G XE:
Creating an Oracle Web Service Client for a Web Service Created in VS 2005
Developing Applications on Oracle 10g XE: Generating a Report
SQL Script Support in Oracle 10G Express Edition
On VB.NET:
Exploring Dailogs Controls in VB.NET
Creating a Database Project in VS 2005
Explosion on Mumbai trains costed ~190 lives. The people who ride trains in Mumbai are the guys who carry food to the workers in Bomaby, milk men, daily workers who clean buildings, etc.
What a waste of human life? Misery would only appear ten fold more.
Wednesday, July 05, 2006
ADO with ASP
You may use the following:
I have created a system DSN called 'ForAsp' for your illustration
I have an IIS Server on my machine
I have this page in my root directory:
---------------
<%@ Language=vbscript %>
<html>
<head><title></title></head>
<body>
<%
dim conn
set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=ForAsp", "sa", "xxxxxxx"
dim rs
set rs=Server.CreateObject("ADODB.Recordset")
dim sql
sql="Select * from Employees"
rs.open sql, conn
do while not rs.eof
response.write(rs("LastName") & "<Br>")
rs.MoveNext
loop
rs.close
conn.close
%>
</body></html>
--------------------------------------
I call this file, hodentek.asp
When I browse this file on the local server using this http://localhost/hodentek.asp
I will see one line each, all the last names of employees in the Northwind's Employee table.
This should give some ideas to you.
Hope this helps.
sincerely,
Jay
I have created a system DSN called 'ForAsp' for your illustration
I have an IIS Server on my machine
I have this page in my root directory:
---------------
<%@ Language=vbscript %>
<html>
<head><title></title></head>
<body>
<%
dim conn
set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=ForAsp", "sa", "xxxxxxx"
dim rs
set rs=Server.CreateObject("ADODB.Recordset")
dim sql
sql="Select * from Employees"
rs.open sql, conn
do while not rs.eof
response.write(rs("LastName") & "<Br>")
rs.MoveNext
loop
rs.close
conn.close
%>
</body></html>
--------------------------------------
I call this file, hodentek.asp
When I browse this file on the local server using this http://localhost/hodentek.asp
I will see one line each, all the last names of employees in the Northwind's Employee table.
This should give some ideas to you.
Hope this helps.
sincerely,
Jay
Tuesday, July 04, 2006
June 2006 Articles
New articles written during June 2006
----------------------------------------
Loading Spread Sheet Data into Oracle 10G XE
Migrating from Oracle 10G XE to SQL Anywhere 10
On Using AccessDataSource Control in VS 2005
Provider Factory in ADO.NET 2.0
On Using ADO's Record Object with URLS
Exporting XML from MS Access 2003
Importing XML into MS Access 2003
A demo using the Wizard Control in ASP.NET 2.0
The Why? and How? of XML Data Islands
Introducing Jasper (SQL Anywhere 10 Beta)
All these articles should appear on one of these sites:
http://www.devarticles.com/cp/bio/Jayaram-Krishnaswamy/
http://www.aspfree.com/cp/bio/Jayaram-Krishnaswamy/
http://www.devarticles.com/cp/bio/Jayaram-Krishnaswamy/
This month was crowded with activities. There was World Cup and I wanted to watch my favorites (the Brazilian team) win, but alas! they did not.
The semi-finals between Italy and Germany was fantastic and there was a big party at Circo Maximo in Rome. How I wish I was there with a glass in my hand and my favorite girl, my wife with me? But anyway, I did put in some work to get the articles going.
Jasper (Sql Anywhere 10 in beta) is real cool.
Flex2 is not in beta anymore. I miss coding with it, because I cannot aford to buy it, just because I fancy it.
Exporting XML from Access 2003 works great, but not importing XML.
I did get this other article on Oracle 10G XE online as well in June. It's about creating a front end program for Oracle 10G XE using none other than MS Access 2003. Well, Oracle 10G XE also has an excellent built-in application tool. But it is always good to know an alternative method. Actually, MS Access 2003 does a good job of it. Read more on this at:
Creating an MS Access 2003 Front End for an Oracle 10g Express Edition Database
----------------------------------------
Loading Spread Sheet Data into Oracle 10G XE
Migrating from Oracle 10G XE to SQL Anywhere 10
On Using AccessDataSource Control in VS 2005
Provider Factory in ADO.NET 2.0
On Using ADO's Record Object with URLS
Exporting XML from MS Access 2003
Importing XML into MS Access 2003
A demo using the Wizard Control in ASP.NET 2.0
The Why? and How? of XML Data Islands
Introducing Jasper (SQL Anywhere 10 Beta)
All these articles should appear on one of these sites:
http://www.devarticles.com/cp/bio/Jayaram-Krishnaswamy/
http://www.aspfree.com/cp/bio/Jayaram-Krishnaswamy/
http://www.devarticles.com/cp/bio/Jayaram-Krishnaswamy/
This month was crowded with activities. There was World Cup and I wanted to watch my favorites (the Brazilian team) win, but alas! they did not.
The semi-finals between Italy and Germany was fantastic and there was a big party at Circo Maximo in Rome. How I wish I was there with a glass in my hand and my favorite girl, my wife with me? But anyway, I did put in some work to get the articles going.
Jasper (Sql Anywhere 10 in beta) is real cool.
Flex2 is not in beta anymore. I miss coding with it, because I cannot aford to buy it, just because I fancy it.
Exporting XML from Access 2003 works great, but not importing XML.
I did get this other article on Oracle 10G XE online as well in June. It's about creating a front end program for Oracle 10G XE using none other than MS Access 2003. Well, Oracle 10G XE also has an excellent built-in application tool. But it is always good to know an alternative method. Actually, MS Access 2003 does a good job of it. Read more on this at:
Creating an MS Access 2003 Front End for an Oracle 10g Express Edition Database
Subscribe to:
Posts (Atom)
