tag:blogger.com,1999:blog-10338754.post427538671582342414..comments2023-03-23T21:13:29.617+11:00Comments on Hex dump: IronPython and ADO.NET Part 2hexdump42http://www.blogger.com/profile/13884562284992556003noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-10338754.post-31640980753348135792007-02-07T06:35:00.000+11:002007-02-07T06:35:00.000+11:00You made my day.
dbconn=odbc.connect('dsn=mydsn;u...You made my day.<br /><br />dbconn=odbc.connect('dsn=mydsn;uid=monty;pwd=python')<br /><br />Your example and the link you sent on the connection string was extremely helpful. <br /><br />I'm using server auth and therefore the string was my hold up in getting any further. <br /><br />Many thanks Mark.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-10338754.post-23759365239850694622007-02-06T13:11:00.000+11:002007-02-06T13:11:00.000+11:00The Microsoft knowledgebase gives some reasons why...The Microsoft knowledgebase gives some reasons why you may be getting this:<br /><br />http://support.microsoft.com/kb/889615<br /><br />By default when you set up an ODBC connection to SQL Server it relies on Windows authentication so when IronPython is trying to connect it will be using the token of the user currently logged on the PC running it. Dependant on how the MS SQL Server instance is hexdump42https://www.blogger.com/profile/13884562284992556003noreply@blogger.comtag:blogger.com,1999:blog-10338754.post-73623265417811324152007-02-06T12:27:00.000+11:002007-02-06T12:27:00.000+11:00Hi Mark. This is great info. However, I can't figu...Hi Mark. This is great info. However, I can't figure out how to pass the username/pw properly. I'm trying to connect to a MSSQL database. On my windows machine I've configured the DSN.<br /><br /><b>import odbc<br />dbconn=odbc.connect('dsn=mydsn')</b><br /><br />odbc.connect takes only one argument. I've read thru the DB-API doc which shows the connect constructor should have more arguments for Barryhttps://www.blogger.com/profile/16680589828254467115noreply@blogger.com