www.Senthoor.info http://senthoor.info/blogs Fri, 10 Oct 2008 12:37:14 +0000 http://backend.userland.com/rss092 en HTML – Introduction Hyper Text Markup Language - HTML Welcome to Senthoor.info's HTML Tutorial. Here you will learn how the basics of the Hyper Text Markup Language (HTML), so that you may make your own web pages like the one you are viewing right now. HTML is not a programming language, but rather a markup ... http://senthoor.info/blogs/2008/07/10/html-introduction/ SQL Database Glossary Our database glossary explains common database terminology and SQL database jargon. A Access Microsoft Access is an entry-level database management software from Microsoft, which allows you to organize, access, and share information easily. Access is very user-friendly and easy to use for inexperienced ... http://senthoor.info/blogs/2008/06/25/sql-database-glossary/ Oracle connection strings Oracle ODBC connection strings Open connection to Oracle database using ODBC "Driver= {Microsoft ODBCforOracle};Server=Your_Oracle_Server.world;Uid=Your_Username;Pwd=Your_Password;" Oracle OLE DB & OleDbConnection (.NET framework) connection strings Open connection to Oracle database with standard security: 1. "Provider=MSDAORA;Data Source= Your_Oracle_Database;UserId=Your_Username;Password=Your_Password;" 2. "Provider= OraOLEDB.Oracle;Your_Oracle_Database;UserId=Your_Username;Password=Your_Password;" Open trusted connection to Oracle database "Provider= OraOLEDB.Oracle;DataSource=Your_Oracle_Database;OSAuthent=1;" http://senthoor.info/blogs/2008/06/25/oracle-connection-strings/ MySQL connection strings MySQL ODBC connection strings Open connection to local MySQL database using MySQL ODBC 3.51 Driver "Provider=MSDASQL; DRIVER={MySQL ODBC 3.51Driver}; SERVER= localhost; DATABASE=Your_MySQL_Database; UID= Your_Username; PASSWORD=Your_Password; OPTION=3" MySQL OLE DB & OleDbConnection (.NET framework) connection strings Open connection to MySQL database: "Provider=MySQLProv;Data Source=Your_MySQL_Database;User Id=Your_Username; Password=Your_Password;" http://senthoor.info/blogs/2008/06/25/mysql-connection-strings/ MS Access connection strings MS Access ODBC connection strings Standard Security: "Driver= {MicrosoftAccessDriver(*.mdb)};DBQ=C:\App1\Your_Database_Name.mdb; Uid=Your_Username;Pwd=Your_Password;" Workgroup: "Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:\App1\Your_Database_Name.mdb; SystemDB=C:\App1\Your_Database_Name.mdw;" Exclusive "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\App1\Your_Database_Name.mdb; Exclusive=1; Uid=Your_Username; Pwd=Your_Password;" MS Access OLE DB & OleDbConnection (.NET framework) connection strings Open connection to Access ... http://senthoor.info/blogs/2008/06/25/ms-access-connection-strings/ SQL Server connection strings SQL ODBC connection strings Standard Security:< br> "Driver={SQLServer};Server=Your_Server_Name; Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;" Trusted connection:< br> "Driver={SQLServer};Server=Your_Server_Name; Database=Your_Database_Name;Trusted_Connection=yes;" SQL OLE DB connection strings Standard Security: "Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;" Trusted connection: "Provider=SQLOLEDB;Data Source=Your_Server_Name; Initial Catalog=Your_Database_Name;Integrated Security=SSPI;" SQL OleDbConnection .NET strings Standard Security: "Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;" Trusted connection: "Provider=SQLOLEDB;Data Source=Your_Server_Name; Initial Catalog=Your_Database_Name;Integrated Security=SSPI;" SQL SqlConnection .NET strings Standard Security: 1. "Data Source=Your_Server_Name;Initial Catalog= ... http://senthoor.info/blogs/2008/06/25/sql-server-connection-strings/ My Play List http://senthoor.info/blogs/2008/05/20/my-play-list/ AJAX Suggest Source Code AJAX Source Code to Suggest Example The source code below belongs to the AJAX example on the previous page. You can copy and paste it, and try it yourself. The AJAX HTML Page This is the HTML page. It contains a simple HTML form and a link to a JavaScript. <html> <head> <script src="clienthint.js"></script> </head> <body> <form> First ... http://senthoor.info/blogs/2008/02/29/ajax-suggest-source-code/ AJAX Suggest Example We have seen that AJAX can be used to create more interactive applications. AJAX Suggest Example In the AJAX example below we will demonstrate how a web page can communicate with a web server online as a user enters data into a standard HTML form. Type a Name in the Box Below ... http://senthoor.info/blogs/2008/02/29/ajax-suggest-example/ AJAX – The Server-Side Script AJAX - The Server-Side ASP Script Now we are going to create the script that displays the current server time. The responseText property (explained in the previous chapter) will store the data returned from the server. Here we want to send back the current time. The code in "time.asp" looks like this: <% response.expires=-1 response.write(time) %> Note: ... http://senthoor.info/blogs/2008/02/28/ajax-the-server-side-script/