MSSQL Linked Server Problems

oconnk

Hi All,

I am trying to access data on a linked server and not having any luck. When running the query on our main MSSQL box it accesses the linked server without any issue. In php it is returning no data.

I have been using this format for my queries : select * from linkedserver.database.dbo.table

I have also tried creating a view on the main box that looks at the tables I need on the linked server and had the same results.

Any help would be great.

tapos

have u made a connection with that server before executing SQLs???

oconnk

The link is established on the server side and I am able to run queries against the linked database via SQL Server Mgmt Studio (MSSQL2005). I am also using PHP v5.2.5.

I am attempting to compare values in two tables in different databases on different servers. When running the query in PHP nothing is being returned. I am connecting to the the main database that contains the link in my code.

scrombie

I have the same problem getting data from a linked server. I was using a view to combine data from databases on different servers. The view works fine in SQL Server Management Studio and with the sqlcmd utility. I connected from a remote machine using the same username and password in sqlcmd that I do with php. Php also fails to return data for a view referencing data in another database on the same server.

Php will provide data for a view referencing tables in the same database.

This was tested using the same code page only changing the query and returned field names. I am using SQL Server 2005, php 5.2.5, and mssql library version 7.0.