Home arrow SQL Server arrow Page 3 - Executing SQL Server Stored Procedure from Perl
SQL SERVER

Executing SQL Server Stored Procedure from Perl


This article illustrates how to setup a development environment using Perl and SQL Server on the following platforms: Microsoft Windows, Red Hat Linux, and Sun Solaris. Step by step, you can learn, and may choose, the best way that fits into your own requirements.

Author Info:
By: Jack Zhang
Rating: 4 stars4 stars4 stars4 stars4 stars / 99
June 01, 2004
TABLE OF CONTENTS:
  1. · Executing SQL Server Stored Procedure from Perl
  2. · History Lesson: SQL Server(s)
  3. · TDS protocol
  4. · Setup Perl and SQL Server on Windows
  5. · Create A Stored Procedure on Sybase Adaptive Server

print this article
SEARCH DEVARTICLES

Executing SQL Server Stored Procedure from Perl - TDS protocol
(Page 3 of 5 )

SQL Server uses a typical Client-Server architecture. The SQL Server client is a set of C APIs plus management tools such as iSQL query tool and SQL Server Enterprise Manager. SQL Server Server-Side component is usually a system service, listening to specific TCP ports (Microsoft use 1433, Sybase use 4100 or 5000), and is ready to accept the signal from an SQL Server client at anytime.

The protocol used between an SQL Server client and server is traditionally called the TDS protocol (Tabular Data Stream). Microsoft SQL Server 4.2, 6.0, and 6.5 use the same TDS protocol as Sybase SQL Server 4.2 and 10, which is known as TDS4.2.

From Version 11, Sybase stopped further development of the old set of APIs (we call DB-Library) and started a new set of APIs, known as CT-library. They also redesigned the TDS protocol, which is now known, industry-wide, as TDS 5.0. At the same time, Microsoft chose to stick to DB-Library but enhanced the TDS protocol, which we call TDS 7.0.  But, do not think that TDS 7.0 is more advanced than TDS 5.0 or compatible with TDS 5.0. In fact, TDS 7.0 belongs solely to Microsoft SQL Server (we’re better off to call it Microsoft TDS) and TDS 5.0 belongs specifically to Sybase (Sybase TDS).   

So, we easily understand that the latest version of Microsoft SQL Server (2000) supports TDS 7.0 and TDS 4.2 (backwards compatibility) and Sybase SQL Server’s latest version 12.5 supports TDS 5.0 and TDS 4.2 (backwards compatibility).


blog comments powered by Disqus
SQL SERVER ARTICLES

- Executing SQL Server Stored Procedure from P...
- How to Search for Date and Time Values Using...
- Replication: SQL Server 2000 - Part 2
- Replication: SQL Server 2000 - Part 1
- SQL Sever: Storing Code in Binary or Text Fi...
- Execute SQL on Multiple Tables/Columns - New...
- How to Connect to a SQL Server from Visual F...
- SQL Server Hardware Tuning and Performance M...
- Primary Key on Multiple Tables – New RDBMS C...
- Migrating from Sybase to SQL Server
- What's Best for DBAs? GUI or T-SQL Comma...
- How to Perform a SQL Server Performance Audit
- An Introduction To The Bulk Copy Utility
- SQL Server Stored Procedures 101
- Building Your First SQL Server 2000 Database

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials