Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
What Are the Requirements to Use ODBC Connections in PHP Scripts?
Submitted by: AdministratorIf you are planning to use ODBC connections to access SQL Server databases in PHP scripts, you need to check the following requirements:
* The PHP engine must support ODBC functions. If you install PHP 5.2.2 from The PHP Group, the ODBC functions are already included in the default installation.
* The SQL Server must have TCP/IP protocol enabled for a specific port.
* The SQL Server Browser Service must be running on the SQL server machine.
* An ODBC DSN must be created on machine where you are running PHP scripts.
* The ODBC DSN connection must be tested to make sure it is working.
You need to following other tutorials provided by GlobalGuideLine.com to install PHP engine, install SQL Server, configure TCP/IP protocol, start SQL Server Browser Service, create and test ODBC DSN connections.
Submitted by: Administrator
* The PHP engine must support ODBC functions. If you install PHP 5.2.2 from The PHP Group, the ODBC functions are already included in the default installation.
* The SQL Server must have TCP/IP protocol enabled for a specific port.
* The SQL Server Browser Service must be running on the SQL server machine.
* An ODBC DSN must be created on machine where you are running PHP scripts.
* The ODBC DSN connection must be tested to make sure it is working.
You need to following other tutorials provided by GlobalGuideLine.com to install PHP engine, install SQL Server, configure TCP/IP protocol, start SQL Server Browser Service, create and test ODBC DSN connections.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.