Connecting to a MSSQL database view with php

Question

I've never worked with Views on MSSQL so I hope I'm note asking a dumb question.

I have a MSSQL database and I can easiliy retrieve information from it like:

mssql_query(SELECT tbDocs FROM tbServices);

But I can't get data from a view. For example there is a view named View_Technical_Service it gets fields from tbServices and tbCustomer. Whenever I execute a query from php like

mssql_query(SELECT tbDocs FROM View_Technical_Service);

I get a time out error msg from chrome:

Error 324 (net::ERR_EMPTY_RESPONSE):

So what's wrong? Is it not possible to get from a MSSQL View with php?

GDP · Accepted Answer · 2012-04-28 13:21:53Z

1

To answer the question, yes you can use views in the same way as tables - I do it frequently. But, you should use your DB Tool such as phpMyAdmin or SQLYog to determine if the view is working properly and that you can actually see the "view" as you expect - you should be able to look at the data exactly the same way as you would a table.

If you're using Chrome, there is apparently a rampant problem world wide with how it handles empty results, which also seems to verify that the View doesn't have, or is unable to show, any data to show you

answered Apr 28, 2012 at 13:21

GDP

8,1636 gold badges48 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Webbie · Accepted Answer · 2016-03-23 00:44:46Z

0

Yes, it works. I have tested DSN less ODBC from PHP on a Windows Apache server. BUT When I used [Table Name] in the query string it DID NOT work. I had to remove the space (TableName). So I recommend removing spaces from table names and do not rely on [ ].

answered Mar 23, 2016 at 0:44

Webbie

11 bronze badge

Collectives™ on Stack Overflow

Connecting to a MSSQL database view with php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related