MSSQL/PHP
Posted on
16th Feb 2014 07:03 pm by
admin
I am tryint to setup a webapplication developed in PHP, Apache2.0 and SQLServer2000 as backend which is running smoothly on a system in UK. I got the code and database backup from the Production Server.
Restored the DB backup and table names are like sf.tablename and dbo.tablename. Same structure i got in my local system. When i try to run the application, i am getting error DBConnect Failed. I analysed the problem and made changes to a very first query like prefixed the schema name to the tablename in the code. for example select user from sf.Users. Then login and validation done succesfully. But i cant change it everywhere. and its not required as in the production its running without the schema name. So i am not sure if any change is required on SQLServer side. So pls let me know if any configuration/setting is required from SQLServer side?
In simple words, from the PHP code if i run query like
Did you know?Explore Trending and Topic pages for more stories like this.
" select * from users " is not running . if i modify query in the code like
" select * from sf.users ". its working fine. but my query is i wont change it in the code. if i required i will change any configuration on SQLServer.
Thanks,
No comments posted yet
Your Answer:
Login to answer
189 
36 
Other forums
GMail like Chat in ASP.NET
Hi,Can anyone suggest me, how to incorporate GMail like chat in my existing ASP.Net application.I wa
natcasesort works on one server but not on another
Hi
I have a problem that I was hoping that someone can help me with.
I'm trying to use
BB_Code error
I'm having a problem with a custom built function and keep getting this error:
Warning: M
Batch Related Pricing
Hi, I need some clarity on the batch related pricing
For example the following are the b
Place specific image in html page when specific name is typed.
Hello,
Fairly new to PHP and was curious if someone might know how to solve a fairly simple r
C++ Http request?
Code:
string Response = "LOGIN_UNSUCCESSFUL";
System.Net.WebRequest request = Sy
Empty text file when there is over XXXX lines of text.
define("RANDOM_FILE","/public_html/random.txt");
$randomEntry = "
PayPal Redirect Issue
When I have my paypal button set so that is redirects to http://empiremarketing.ca/order.php,it work
delete comma
HI,
How to delete "," at the end of the string.
Code: $match = 2009/02/03/a2corr
dynamic table with forms
I have a table that is populated with mysql data and in teh first column there is a raido button tha
