Upload File

accessing microsoft sql server.docx

20
Accessing Microsoft SQL Server (mssql) from PHP under Apache o n Unix or Linux PHP is an open-source scripting language used to create database-driven web applications. PHP supports a number of database extensions that e nable PHP scripts embedded within web pages to access data stored in relational databases and display the results. PHP includes ODBC support through its Unified ODBC database extension. This tutorial shows you how to use ODBC to access remote SQL Server databases from PHP scripts running under the Apache web server. Connect PHP to SQL Server 2000, SQL Server 2 005, SQL Server 2008, SQL Server 201 2 and SQL Server Express When developing this tutorial, we accessed SQL Server 2000  – 2012 and Express databases from PHP on UNIX and Linux. PHP and Linux To access SQL Server from PHP on Linux, we used Easysoft ODBC drivers with PHP on RedHat and Ubuntu (Edgy Eft, Feist y Fawn, Gutsy Gibbon and Hardy Heron). Easysoft ODBC drivers should work with any recent 32-bit or 64-bit Linux distribution  — CentOS, Debian GNU/Linux, Fedora, Kubuntu, Mandrake/Mandriva, OpenSUSE/SUSE, RedHat Enterprise Linux (RHEL), Slackware and so on. PHP SQL Server Pre-requisites To connect PHP on UNIX/Linux with SQL Server, we used:  PHP 4.2 or later .  Apache 2.0 or later .  SQL Server ODBC driver . PHP 4.2 or Later To check which version of PHP you are running, use the php -v command from the shell  prompt.

Upload: somaacy

Post on 14-Apr-2018

234 views

Category:

Documents


0 download

Report

TRANSCRIPT

Page 1: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 1/20

http://www.easysoft.com/products/data_access/odbc-sql-server-driver/index.html?advert=mssql_php&referring_page=Accessing%20Microsoft%20SQL%20Server%20(mssql)%20from%20PHP%20under%20Apache%20on%20UNIX%20or%20Linux&location=prerequisites
http://www.easysoft.com/developer/languages/php/sql_server_unix_tutorial.html#driver
http://www.easysoft.com/developer/languages/php/sql_server_unix_tutorial.html#apache2
http://www.easysoft.com/developer/languages/php/sql_server_unix_tutorial.html#php42
Page 2: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 2/20

http://www.php.net/docs.php
http://www.php.net/
Page 3: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 3/20

Page 4: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 4/20

http://www.easysoft.com/products/data_access/odbc-sql-server-driver/manual/sql-server-toc.html
http://www.easysoft.com/cgi-bin/productdownload.cgi?p=30
http://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.html#platforms
http://www.easysoft.com/cgi-bin/account/register.cgi
http://www.easysoft.com/cgi-bin/account/register.cgi
http://www.easysoft.com/cgi-bin/productdownload.cgi?p=53
Page 5: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 5/20

http://www.easysoft.com/products/data_access/odbc-sql-server-driver/index.html?advert=mssql_php&referring_page=Accessing%20Microsoft%20SQL%20Server%20(mssql)%20from%20PHP%20under%20Apache%20on%20UNIX%20or%20Linux&location=sql_server_odbc_driver
Page 6: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 6/20

http://www.easysoft.com/products/data_access/odbc-sql-server-driver/index.html?advert=mssql_php&referring_page=Accessing%20Microsoft%20SQL%20Server%20(mssql)%20from%20PHP%20under%20Apache%20on%20UNIX%20or%20Linux&location=odbc_tables
Page 7: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 7/20

Page 8: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 8/20

http://www.easysoft.com/products/data_access/odbc-sql-server-driver/index.html?advert=mssql_php&referring_page=Accessing%20Microsoft%20SQL%20Server%20(mssql)%20from%20PHP%20under%20Apache%20on%20UNIX%20or%20Linux&location=calling_procedures
Page 9: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 9/20

Page 10: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 10/20

http://www.easysoft.com/developer/languages/php/sql_server_unix_tutorial.html#driver
Page 11: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 11/20

Page 12: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 12/20

http://www.easysoft.com/developer/languages/php/apache_odbc.html
http://www.easysoft.com/developer/languages/php/apache_odbc.html
Page 13: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 13/20

Page 14: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 14/20

http://www.easysoft.com/support/kb/kb01037.html
Page 15: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 15/20

http://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.html
Page 16: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 16/20

http://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.html?advert=mssql_php&referring_page=Accessing%20Microsoft%20SQL%20Server%20(mssql)%20from%20PHP%20under%20Apache%20on%20UNIX%20or%20Linux&location=oob_data_sources
http://www.easysoft.com/products/data_access/odbc_odbc_bridge/manual/oobTOC.html
http://www.easysoft.com/products/data_access/odbc_odbc_bridge/manual/oobTOC.html
Page 17: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 17/20

Page 18: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 18/20

Page 19: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 19/20

http://www.easysoft.com/developer/languages/php/sql_server_unix_tutorial.html#examples
http://www.easysoft.com/developer/interfaces/odbc/linux.html#testing_dsns_unixodbc
http://www.easysoft.com/developer/interfaces/odbc/linux.html#testing_dsns_unixodbc
http://www.easysoft.com/products/data_access/odbc_odbc_bridge/manual/connection.html#798156
http://www.easysoft.com/products/data_access/odbc_odbc_bridge/manual/connection.html#798156
Page 20: Accessing Microsoft SQL Server.docx

7/30/2019 Accessing Microsoft SQL Server.docx

http://slidepdf.com/reader/full/accessing-microsoft-sql-serverdocx 20/20

http://www.easysoft.com/developer/interfaces/odbc/diagnostics_error_status_codes.html
http://www.easysoft.com/developer/interfaces/odbc/64-bit.html
http://www.easysoft.com/developer/interfaces/odbc/linux.html
http://www.easysoft.com/support/kb/products/odbc_odbc_bridge/index.html
http://www.easysoft.com/support/kb/products/odbc_sql_server_driver/index.html
http://www.easysoft.com/developer/languages/php/apache_odbc.html
http://www.php.net/
http://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.html
http://www.easysoft.com/products/data_access/odbc-sql-server-driver/index.html

SQL Server 2012 Session: 1 Session: 8 Accessing Data Data Management Using Microsoft SQL Server

SQL is a Standard Language for Accessing

SQL Server Tools - University of Houstonsmiertsc/2336itec/SQL_Server_Tools.pdf · Microsoft SQL Server – Tools for Accessing the Server By Susan L. Miertschin. SQL Server 2008 Client

BD05/06 PL/SQL Introduction Structure of a block Variables and types Accessing the database Control flow Cursors Exceptions Procedures

Module 3: Changes to Transact-SQL. Overview Accessing Object Information New Transact-SQL Syntax Changes to Objects Distributed Queries

Structured Query Language. SQL stands for “Structured Query Language”. Used for accessing and modifying information in the database. Some of the SQL commands

Structure Query Language - LPU GUIDE€¦ · STRUCTURED QUERY LANGUAGE SQL is a standard language for accessing and manipulating databases. What is SQL? •SQL stands for Structured

How to Install and Configure Windows Server 2008 DHCP Server.docx

Accessing SQL 2000 via HTTP - pearsoncmg.comptgmedia.pearsoncmg.com/images/0735711127/samplechapter/... · 2009-06-09 · sql=and then the SQL query itself.Separate all words in the

SQL is a standard computer language for accessing and ...bookish.synthasite.com/resources/sql_all_queries.doc  · Web viewSQL can insert new records in a database . SQL can delete

Accessing Your Enterprise Geodatabase Using SQL · 2018-03-28 · Accessing your geodatabase using SQL •Query schema and properties of existing datasets-Use SQL statements to query

Accessing Non-Relational Data with SQL - OMNI Useromniuser.org/downloads/Accessing_Non_Relational_Data_with_SQL.pdfIBM Systems Lab Services and Training Accessing Non-Relational Data

Accessing SQL Server from IBM Cognos BI Server - … · T U T O R I A L > ACCESSING SQL SERVER FROM IBM COGNOS BI SERVER

PHP is a powerful server.docx

Chapter 8 Databases. Objectives Explain the structure of a relational database Use SQL for creating, maintaining, and accessing relational databases Use

laptop dan server.docx

Accessing Your Enterprise Geodatabase using SQL€¦ · 2015 Developer Summit Europe--Presentation, 2015 Developer Summit Europe, Accesssing Your Enterprise Geodatabase using SQL,

Accessing SQL Server and OLE DB from.NET Svetlin Nakov Telerik Corporation

Lecture BigData Analytics Julian M. Kunkel · Relational Model Accessing Databases with SQL Data WarehousesSummary 1 Relational Model Overview ER Diagrams Keys Normalization 2 Accessing

Let’s try Oracle. Accessing Oracle The Oracle system, like the SQL Server system, is client / server. For SQL Server, –the client is the Query Analyser

Accessing SQL Server Databases with PHPdownload.microsoft.com/.../sql_server_access_via_php.docx · Web viewAccessing SQL Server Databases with PHP24 Accessing SQL Server Databases

new database engine component fully integrated into SQL Server 2014 optimized for OLTP workloads accessing memory resident data achive improvements

Structured Query Language. SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems

Accessing Your Enterprise Geodatabase through SQL · 2016-03-15 · -Supported on ALTIBASE, Dameng , DB2, Informix, Netezza, Oracle, PostgreSQL, SAP HANA, SQL Server, Teradata. A

Introduction to Teradata Client Tools. 2 Introduction to Teradata SQL OBJECTIVES : Teradata Product Components. Accessing Teradata – Database

Información general de SQL Server.docx

Accessing Your Enterprise Geodatabase through SQL · •You can access spatial or non -spatial data in a DBMS to use in ArcGIS -Oracle, SQL Server, DB2, Informix, PostgreSQL, Netezza,

ACCESSING D WITH JDBC€¦ · JDBC provides a standard library for accessing relational databases. By using the JDBC API, you can access a wide variety of SQL databases with exactly

SQL is a standard computer language for accessing … · Web viewSQL is a standard computer language for accessing and manipulating databases. In this tutorial you will learn how

Accessing SQL Server and MySQL from.NET and C# Learning & Development Team Telerik Software Academy

SQL From: . SQL It is a standard language for accessing and manipulating databases – MySQL, SQL Server, Access, Oracle, Sybase,

Chapter 5-2: Advanced SQL. 2 Join Expressions Views Integrity Constraints SQL Data Types and Schemas Authorization Accessing SQL From a Programming Language

sql server.docx

SQL is a standard computer language for accessing and ...rimesproduction.yolasite.com/resources/SQL Tutorial.doc  · Web viewSQL is an ANSI (American National Standards Institute)

SAS 9.2 SQL Procedure: User's Guide · iv Accessing SAS System Information by Using DICTIONARY Tables 120 Using SAS Data Set Options with PROC SQL 127 Using PROC SQL with the SAS