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
Save cookie to DB
I'm working on a pixel tracking script for an incentive website and I need to use an ASP script to s
preg_replace question
Hello!!
I hope someone can help me with preg_replace.
I load two tables from an extern
Running External Scripts
I am very new to PHP and am not even sure what I'm asking is possible. I have just installed mediaW
TimeZoneOffset
Hello,
Please i need your help. I have a system that users can use to punch in and out. This
PHP Cannot redeclare class
I have 6 files, and two of them do not seem to want to play well. I keep getting a "Cannot rede
Check Digits and extracting digits
I think I can figure out the code for this but I am having a very hard time getting past the first s
issues verifying if user is logged in
I am having issues when a user logs in via asp Login control, the IsAuthenticated still seems to com
registration form
first time posting. did some searches but didnt find exactly what i am looking for. dont flame cause
Count
Getting the same count everytime
Code:
$visitquery = mysql_query("SELECT COUNT(*) FR
Stopping page post back
I have few literal contriols in my page and a repeater too. But inspite of using update panel, postb
