dongshi2141 2015-05-05 13:25
浏览 66

TCP错误:与Azure SQL数据库的ODBC连接

Using an Azure SQL Database for my application with a php exchange. I had a MSSQL express server running locally but when I moved to Azure I am receiving a connection error:

Warning: odbc_connect(): SQL error: [Microsoft][SQL Server Native Client 11.0]TCP Provider: No such host is known. , SQL state 08001 in SQLConnect in C:\wamp\www\UnitySQL\connect.php on line 13

My code is as follows (changed login details but format is the same):

<?php 
    $username = $_REQUEST['username'];
    $password = $_REQUEST['password'];

    $user = 'Login@Azure';
    $pass = 'azure';
    $server = 'azure.database.secure.windows.net,port';
    $database = 'db';


// No changes needed from now on
    $connection_string = "DRIVER={SQL Server Native Client 11.0};;SERVER=$server;DATABASE=$database";
    $conn = odbc_connect($connection_string,$user,$pass);
    $q = "select top 1 u.First, u.UserEmail, u.UserTelephone, u.UserId, MAX
(us.session) as sessionid, us.LastQuestion as LastQuestion from [user] as u LEFT OUTER join usersession as us
On u.UserId = us.userid

where UserEmail='$username' AND UserTelephone='$password'
group by u.[First], u.UserEmail, u.UserTelephone, u.UserId, LastQuestion
Order by sessionid DESC";
    $result = odbc_exec($conn,$q);
    $num_rows = odbc_num_rows($result);

    if($num_rows > 0)
    {
        $row = odbc_fetch_array($result);
        echo "First=". $row['First'] . "/" . "UserId=" . $row['UserId'] . "/" . "SessionId=" . $row['sessionid'] . "/" . "LastQuestion=" . $row['LastQuestion'] . "/" . "UserEmail=" . $row['UserEmail']. "/" . "UserTelephone=" . $row['UserTelephone'];
    }
?>
  • 写回答

1条回答 默认 最新

  • duan010167787 2015-05-05 16:55
    关注

    Your $server setting is incorrect. Instead of

    $server = 'azure.database.secure.windows.net,port';
    

    try

    $server = 'tcp:<YOUR_SRV_NAME>.database.windows.net,1433';
    

    Replace with the name of your SQL Database server. For more information take a look at this tutorial.

    评论

报告相同问题?

悬赏问题

  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥20 Python安装cvxpy库出问题
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题