DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = Can we connect a MYSQL db which is located in Win Server 2003 MS-IIS/6.0 - iTechForums
Login
Search
Welcome to the iTechForums.
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
To register now click here.
Latest Threads
Advertisements
Forum Statistics
Threads:
Posts: 5
Members:
Number of Users Online:
Welcome to our newest member,
iTechForums » System Administration » MS IIS »

Can we connect a MYSQL db which is located in Win Server 2003 MS-IIS/6.0

Reply
 
Thread Tools Display Modes
  #1  
Old 05-06-2008, 09:32 AM
Phantom Phantom is offline
Junior Member
  
Join Date: May 2008
Posts: 1
Default
make sure the mysql server is configured to allow connections from other computers, and that any firewals on windows (including the basic windows firewall) are set up to allow mysql to act as a server.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 05-06-2008, 09:32 AM
Mahesh Mahesh is offline
Junior Member
  
Join Date: May 2008
Posts: 1
Default

Can we connect a MYSQL db which is located in Win Server 2003 MS-IIS/6.0
from a Linux Apache server? Please let me know whether is it possible to connect a MYSQL db which is located in Windows Server 2003 Microsoft-IIS/6.0 from a Linux Apache/1.3.37 (Unix) server.

FYI, the mysql db connection file is in LINUX Apache server and the mysql database is in windows 2003 server.

i have just replaced the necessary variables and tried to connect but it showed the below error.

=======================================
<?
mysql_connect("host name", "admin", "1admin") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("test") or die(mysql_error()); echo "Connected to
Database";
?>
=======================================

================================================
Can't connect to MySQL server on 'host name' (4)
================================================
FYI, It does not work even after adding the linux server ip address in trusted websites in windows server to enable access. Let me know is it possible to connect or not?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 06-09-2008, 07:36 PM
080526jk 080526jk is offline
Member
  
Join Date: May 2008
Posts: 69
Post

京客网科技有限公司；
互联网发展到今天，网上购物已不是什么新鲜事，翻译公司因为网络是一种特殊的传播媒介，翻译公司它将全世界的人与人之间，商家与商家之间的距离拉到了0，翻译公司您可以通过网络店铺买卖自己喜欢的商品翻译公司，足不出户轻点鼠标就可以成为商家，翻译公司不受刮风下雨的影响，不用每日为打理自己的店面而东奔西走，这就是网上店铺的好处，如果您有想要出售的东西 ，还不赶快来加盟京客网，做一个名符其实的网商！
__________________
网站推广
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 06-17-2008, 07:32 PM
hijk869 hijk869 is offline
Senior Member
  
Join Date: May 2008
Posts: 260
Talking

lqkj
Agree with your view, to support you酒店管理软件 手持点菜 指纹考勤 澳洲留学
__________________
网站优化
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Your Ad Here

All times are GMT. The time now is 12:57 PM.
Contact Us - Archive - Top