duanche5149 2018-11-16 00:06
浏览 51

MS SQL Server Azure - PHP msssql_connect()连接到不同于master的数据库

I am restricted to use only PHP mssql module to use with MS Azure SQL Server.

I am able to maintain connection by adding: ~/.freetds.conf:

[aftermath]
    database = mydatabase
    host = myhostname.database.windows.net
    port = 1433
    tds version = 8.0

My code in PHP

$myServer = "aftermath"
$myUser = username@hostname
$myPass = obviously_my_pass

$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer");

But when I check which database is selected it returns:

 master

instead of my desired database which is specified in my freetds.conf file

Module sqlsrv is not installed on my hosting and I do not have rights to install it.

Can you tell me how can I resolve this issue?

  • 写回答

0条回答

    报告相同问题?

    悬赏问题

    • ¥15 求差集那个函数有问题,有无佬可以解决
    • ¥15 【提问】基于Invest的水源涵养
    • ¥20 微信网友居然可以通过vx号找到我绑的手机号
    • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
    • ¥15 解riccati方程组
    • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
    • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
    • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
    • ¥50 树莓派安卓APK系统签名
    • ¥65 汇编语言除法溢出问题