Re: [python-win32] mysqldb python

2007-10-25 Thread Tim Roberts
kNish wrote: > > Hi, > > After trouble shooting error 10061, 1130, 1045 and 1044. > Finally, the following code works in a python shell. > > import MySQLdb > import MySQLdb.cursors > conn = MySQLdb.connect(host="ENG-3", user = "Any", passwd = "", db = > "daily", cursorclass=MySQLdb

Re: [python-win32] mysqldb python

2007-10-25 Thread Simon Dahlbacka
Yes it should work from a script just as well from the shell, but with this info we cannot say whats wrong .. If you follow the suggestion: what does the server error log say? One possible cause for such an error is that you haven't sent the http headers correctly On 10/25/07, kNish <[EMAIL PR

[python-win32] mysqldb python

2007-10-25 Thread kNish
Hi, After trouble shooting error 10061, 1130, 1045 and 1044. Finally, the following code works in a python shell. import MySQLdb import MySQLdb.cursors conn = MySQLdb.connect(host="ENG-3", user = "Any", passwd = "", db = "daily", cursorclass=MySQLdb.cursors.DictCursor) user='root' also

Re: [python-win32] Mysqldb

2007-10-24 Thread Tim Roberts
kNish wrote: > > I must admit I know more of python than SQL. When you say > not with localhost as hostname. You are saying that given a computer A > which is acting as a server, has a user name created as root and > passwd "", When another computer B on the same network, > domain (wi

Re: [python-win32] Mysqldb

2007-10-24 Thread Simon Dahlbacka
What I was trying to say has actually nothing to do with python nor sql but networking in general. The host name 'localhost' (and IP address 127.0.0.1 for that matter) always refers to the current machine, and if the server is running on computer a and the client on computer b the client will alwa

Re: [python-win32] Mysqldb

2007-10-24 Thread kNish
Hi, Does anybody think it may be an issue with odbc and wamp5. BRgds, kNish On 10/24/07, kNish <[EMAIL PROTECTED]> wrote: > > Hi, > > Command in use : > > conn = MySQLdb.connect(host = "localhost",port = 3306, user = > "root",passwd = "",db = "dailies",cursorclass=MySQLdb.cu

Re: [python-win32] Mysqldb

2007-10-24 Thread kNish
Hi, I must admit I know more of python than SQL. When you say not with localhost as hostname. You are saying that given a computer A which is acting as a server, has a user name created as root and passwd "", When another computer B on the same network, domain (without a firewall) tries

Re: [python-win32] Mysqldb

2007-10-24 Thread Simon Dahlbacka
the obvious? answer here is at least not with 'localhost' as hostname On 10/24/07, kNish <[EMAIL PROTECTED]> wrote: > > Hi, > > Command in use : > > conn = MySQLdb.connect(host = "localhost",port = 3306, user = > "root",passwd = "",db = "dailies",cursorclass=MySQLdb.cursors.DictCursor) > >

[python-win32] Mysqldb

2007-10-24 Thread kNish
Hi, Command in use : conn = MySQLdb.connect(host = "localhost",port = 3306, user = "root",passwd = "",db = "dailies",cursorclass=MySQLdb.cursors.DictCursor) Error : OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)") Is it possible to h