StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POsqlsrv_connect: Data source name not found and no default driver specified
primarykey
Id
13305242
data
AcceptedAnswerId
13305281
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-11-09T09:25:09.637
FavoriteCount
0
LastActivityDate
2016-09-06T21:02:02.483
LastEditDate
2017-05-23T12:32:47.690
LastEditorUserId
-1
OwnerUserId
1465910
ParentId
0
PostTypeId
1
Score
1
ViewCount
6333
LastEditorDisplayName
text
Body
I am facing difficulties in connecting PHP with SQL SERVER 2008 running on a remote computer. I have php version 5.4.3 and apache 2.2.22. I already have SQL SERVER 2008 running on my computer. I have following files included in my wamp\bin\php\php5.4.3\ext folder: <ul> <li>php_sqlsrv_54_ts.dll</li> <li>php_pdo_sqlsrv_54_ts.dll</li> </ul> On running simple code like <pre><code>$conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn ) { echo "Connection established.\n"; } else { echo "Connection could not be established.\n"; die( print_r( sqlsrv_errors(), true)); } </code></pre> I am getting following error: <pre><code>Connection could not be established. Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 [message] => This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 ) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) ) </code></pre> But I dont know why I am being asked for Microsoft SQL Server 2012 Native Client installation. phpI have tried <a href="https://stackoverflow.com/a/9921725/1465910">this link</a> but with no success. Thanks in Advance. UPDATE 1: I downloaded php 5.3.1 and followed <a href="http://forum.ragezone.com/f723/setup-wampserver-mssql-841598/" rel="nofollow noreferrer">this tutorial</a> and scripts works like a charm.
Tags
<php><sql-server><sql-server-2008><wamp>
Title
sqlsrv_connect: Data source name not found and no default driver specified
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USName is Nilay
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POsqlsrv_connect: Data source name not found and no default driver specified
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.