March 4, 2014 at 4:02 am
From a PHP set of scripts I am doing a basic query: "select * from Table1". I am linking to the database, but it retrieves no data. I know there is data. Could this be a authorization error of the User ID I am utilizing to link with? I tested datawriter and datareader when developing the base user ID in SQL Server 2008. What am I missing?
Thanks!
Livetecs
Time Tracking Software
March 4, 2014 at 4:14 am
to be sure try to try this
1. execute that query on the sql server, get the Server Name and database from the connection string you are using in the PHP application.
2. check if there is any where clause is present in the query.
3. if you think your connection is right, try this query
Select getdate() AS curr_date
. this will bring some data
try this and share the results.
March 19, 2014 at 2:52 am
This link might be helpful:
http://webcheatsheet.com/php/connect_mssql_database.php
___________________________________
Computer Enterprise Masoud Keshavarz
I don't care about hell.
If I go there I've played enough Diablo to know how to fight my way out.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply