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
Undefined offset
The following script checks to see if the user answer matches the correct answer.
Form Fiel
Mastering Regular Expressions, Third Edition, is available.
The Third Edition of Mastering Regular Expressions is available.
QuoteThis third edition is 5
Inserting a variable in a link
I have this code that I want to insert for my own variable but I have no idea how. This is what I wa
Create a form of 2 numbers input and find the greatest.
Hi, everybody.
I have a homework in my training of php, which ask you to make a form that ask
SQL Query/echo not working
Hey all,
I'm trying to run (what I thought) was a simple operation and it isn't working. I h
Working with popups and such in a class
I've recently started building my applications completely enclosed in classes. I like the fact that
PHP header help!
Hi all I am trying to get this php page to refresh every 5 seconds on my phone which is an aastra 48
How do i use vars in an array
Hiya peeps!
How do I use a var in an array. You will see $id but it isnt working.
mysql select with $_get ?
Hi, i have this code:
Code: // If char id is 0 and character dont exist do:
if ($_GET["id
Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si
