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
PEAR Email Attachment w/ $gpg
I have no issues with this code if I take out the attachement section and include the info in the em
Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does an
unoconv doc convert to pdf code prob
PHP/5.3.1
Hi. I am trying to use this code to convert docs to .pdf utilizing unoconv. Howe
Not showing whole name with mail () script
I sent up a simple mail form with the PHP mail() script. One problem is when it sends an email with
Strange PHP/mySQL error ... am I just tired?
Code: <?
## CONNECT TO DB FUNCTION!
function ConnectTo($db2con)
{
$hostNam
Scrolling news bar and MySQL
I am not sure if this is the correct forum to post this on. If not, I apologize. I am still pretty
Problem assigning value to variable in "IF" function
Does this script makes sense? I am trying to take the value that is set to "authenticat" a
Question about GD library
I am trying to make an image that shows a random quote from my database.
However I want t
session variables not working anymore
hello,
i use sessions to handle authentication within my site. my host has been changing a lot of
mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???
this is the code i got