Hi Vernon,
Sorry for my previous post - it slipped out as I was trying to convert
your tests to use a real user, server and password.
The full result of running the test batch job is
D:\work\Moschatel\adodbapi\tests>runtests.bat
D:\work\Moschatel\adodbapi\tests>if "" == "" goto skip_1
D:\work\Moschatel\adodbapi\tests>if not "python" == "" goto skip_python
D:\work\Moschatel\adodbapi\tests>Echo on
D:\work\Moschatel\adodbapi\tests>echo .
.
D:\work\Moschatel\adodbapi\tests>echo .
.
D:\work\Moschatel\adodbapi\tests>del *.pyc
D:\work\Moschatel\adodbapi\tests>echo .
.
D:\work\Moschatel\adodbapi\tests>REM unit test
D:\work\Moschatel\adodbapi\tests>call python adodbapitest.py
2.6.5 (r265:79096, Mar 19 2010, 21:48:26) [MSC v.1500 32 bit (Intel)]
adodbapi v2.3.0
adodbapitestconfig.py v 2.3.0
...Testing MS-SQL login...
(-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider for
SQL Ser
ver', u'Cannot open database "Northwind" requested by the login. The
login faile
d.', None, 0, -2147467259), None)
...Testing MySql login...
(-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider for
ODBC Dr
ivers', u'[Microsoft][ODBC Driver Manager] Data source name not found
and no def
ault driver specified', None, 0, -2147467259), None)
Unit tests for adodbapi version 2.3.0
Default Date Converter is <adodbapi.pythonDateTimeConverter object at
0x02386310
>
....................................................
----------------------------------------------------------------------
Ran 52 tests in 1.895s
OK
Changed dateconverter to
<adodbapi.pythonTimeConverter object at 0x02794F70>
....................................................
----------------------------------------------------------------------
Ran 52 tests in 1.907s
OK
D:\work\Moschatel\adodbapi\tests>echo .
.
D:\work\Moschatel\adodbapi\tests>echo .
.
D:\work\Moschatel\adodbapi\tests>REM generic test
D:\work\Moschatel\adodbapi\tests>call python test_adodbapi_dbapi20.py
This module depends on the dbapi20 compliance tests created by Stuart Bishop
(see db-sig mailing list history for info)
adodbapi v2.3.0
Tested with dbapi20 1.12
...Testing MS-SQL login...
(-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider for
SQL Ser
ver', u'Cannot open database "Northwind" requested by the login. The
login faile
d.', None, 0, -2147467259), None)
D:\work\Moschatel\adodbapi\tests>echo .
.
D:\work\Moschatel\adodbapi\tests>echo .
.
D:\work\Moschatel\adodbapi\tests>pause Testing complete
Press any key to continue . . .
D:\work\Moschatel\adodbapi\tests>
Googling "Data source name not found and no default driver specified"
has not been any help!
Regards
Ian
On 20/07/2010 19:05, Vernon Cole wrote:
I use MySQL as one of the basic tests for adodbapi, so I can say that
it works pretty well for me.
What obstacle do you hit?
--
Vernon Cole
On Tue, Jul 20, 2010 at 11:52 AM, Ian Hobson <i...@ianhobson.co.uk
<mailto:i...@ianhobson.co.uk>> wrote:
Hi all,
How can I (a nube) read a MySQL database using Iron Python?
(windows 7 and 2008 Server).
Any method will do, so long as it works. :)
I've tried adodbapi and mysqldb and mysqlconnector - and always
hit an obstacle I can't get round.
Regards
Ian
_______________________________________________
Users mailing list
Users@lists.ironpython.com <mailto:Users@lists.ironpython.com>
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
_______________________________________________
Users mailing list
Users@lists.ironpython.com
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.839 / Virus Database: 271.1.1/3017 - Release Date: 07/20/10
07:36:00
_______________________________________________
Users mailing list
Users@lists.ironpython.com
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
