Tags: Linux SQL Server PHPConnecting to a SQL Server 2012 databaseHttp://www.freetds.org/userguide/choosingtdsprotocol.htmDownload and install ftp://ftp.freetds.org/pub/freetds/stable/freetds-1.00.20.tar.gz./configure--prefix=/usr/local/freetds--with-tdsver=7.4--enable-msdbl
In CentOS 5.4 Linux, PHP (FastCGI) needs to connect to the SQL Server 2000 database of the relevant department and configure the extended FreeTDS extension.
1. Compile and install FreeTDS
mkdir-p/data0/software/
cd/data0/software/
wgetftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
Server|sqlserver
Ask a question
A few days ago did a very strange project, my company developed a set of China Unicom SGIP Protocol of the SP terminal Short Message Service software, to provide unicom 130 SMS services. This system is under Windows 2000, the database is using Microsoft SQLServer2000, and has been running for some time. Recently, because to provide some information on the web for short message users, you need to read and write the
This article will provide some examples of Perl connections to Microsoft SQL Server databases. Perl scripts run on Windows and Linux platforms.
Windows platform
If you run a Perl script under the Windows platform, it is recommended that you use a two modular package that relies on DBI to provide a standard database interface module.
Dbd::odbcDbd::ado
Using DB
Previous blog about SQL Server on Linux installation, address: http://www.cnblogs.com/fishparadise/p/8057650.html, Now the test migrates a database under the Windows platform to the Linux platform.1. EnvironmentWindows:microsoft SQL Serv
Tags: BIEE SQL Server RPD Linuxbiee11g default installation of MSSQLSERVER data-driven, do not need to reinstall on the server side, the configuration process is mainly based on the ODBC implementation, this article mainly describes the client for the Windows Server-side Linux
Label:Linux down through ODBC Connection SQL
server1, demand:
recently, there is a need to Linux down connection (can be performed SQL statement) SQL
server2, Environment
Operating System: Centos6.5
database: SQLServer2014 Span lang= "en-us" >
Database has users Admin , the passw
, you can install it independently: Download the source package according to the current PHP version, assuming the current is php-5.5.14 3.1, decompression php-5.3.17.tar.gz source package. 3.2. Enter the ext/mssql/(/export/software/php-5.5.14/ext/mssql/) 3.3, the implementation of/export/servers/php-5.5.14/bin/phpize 3.4./configure--with-php-config=/export/servers/php-5.5.14/bin/php-config--with-mssql=/export/servers/ freetds-1.0018/ 3.5, Make-j 4 (can also be directly made),-j 4 simultaneously
database does not exist. If the database exists, you need to overwrite it with the following command:Restore database TestDB from disk= '/opt/dbbackup/testdb.bak ' with replaceSQL Server also has two operations: detaching a database and attaching a database.First, detach the database:sp_detach_db TestDBSo, where are the separated files? In fact, do not worry at all, it is too easy to find a file under the Linux
server|sqlserver| Resolution steps:
First step: Compile and install FreeTDS:
cd/tmp/
Tar xzf freetds-*.tgz
CD freetds-*/
./configure--prefix=/usr/local/freetds
Gmake
Gmake Install
Step two: Compile and install PHP4
./configure--with-mysql--with-sybase=/usr/local/freetds .... (The following parameters differ according to their respective needs)
#例子 (My compilation parameters):./configure--prefix=/usr/local/php--with-mysql--with-apxs2=/usr/local/apach
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.