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
Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the
PHP Upload issue
Hi guys,
I have stumble across an interesting issue with my script and is doing my head in.
ok i need to join all this pages to make 1 neat code
i have 5 pages that make up my tv guide it works 100% but i want to make it 1 page if i can or 2, i
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
First root of a number
Hi,
I can't find any function in php to give me the first root of a number.
Is there any
SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built
unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.
How to change www in url with a specified name
Hi
I'm trying to change the url http://www.sitename.com/apparels to something like below
http:
How do I create a 2D game "camera" to follow player?
In J2ME programming I'm targeting MIDP 2.0 devices.
I'm using gamecanvas and I was thinking t
Grouping and sorting results
Please help with this query.
I have 2 tables in a database, countires and cities. states look