I am using the next two solution for connecting to our mssql server
when the odbc connection is set for all the PCs, I use this:
import dbi, odbc
cn = odbc.odbc('DSN=scalaDB;UID=query;PWD=query;DATABASE=DB')
When there is no connection set and distributed, I usually choose this
import win32co
| Does anyone know how to make pymssql use windows authentication?
|
| Also, can anyone point me to a simple ODBC guide for SQL?
OK, bit of a summary. If it's not answering your questions,
hopefully it'll answer someone else's!
1) mxODBC [http://www.egenix.com/files/python/mxODBC.html]
NB: Ne
[Chris Hengge]
| Does anyone know how to make pymssql use windows authentication?
I'm fairly sure, from previous experience and a brief
perusal of the source, that pymssql doesn't offer the
possibility of pass-through authentication. When I use
it, I have to ask my DBA to set up a specific user.
The originally posted code I was refering to also said *SQL* for the
driver... which I'm not sure about..
On Fri, 2006-09-15 at 02:24 -0500, Luke Paireepinart wrote:
> Chris Hengge wrote:
> > looking at your link, is your con wrong? for example...
> > the one on the link you provided is written:
Chris Hengge wrote:
> looking at your link, is your con wrong? for example...
> the one on the link you provided is written:
> con = ("Driver={SQL Server};", "Server=whatever", etc...
>
It looks to me like these are all separate commands (I.E. They're
separated by a semicolon)
So the way you s
looking at your link, is your con wrong? for example...
the one on the link you provided is written:
con = ("Driver={SQL Server};", "Server=whatever", etc...
I am not at work so I dont have the server to run this code against, but
it looks like you are doing what I've been trying to accomplish :]
OK, so ODBC wont work.. thats not what I thought it was apparently...
So... the question remains... how do I use Windows built in
authorization in my connection string for an MS SQL2000 server?
On Thu, 2006-09-14 at 22:53 -0500, Luke Paireepinart wrote:
> Chris Hengge wrote:
> > 4.5 hours... all
Now that I've looked, its just a wrapper for _mssql, but this still
isn't a solution.
On Thu, 2006-09-14 at 22:53 -0500, Luke Paireepinart wrote:
> Chris Hengge wrote:
> > 4.5 hours... all I'm seeing are a few other libraries, none of which
> > mention having windows authentication :/
> >
> > On
I'm not sure how it works... all the modules I've seen just seem to be
wrappers for odbc... but I can't find any information on connection
strings.. I guess I could just try the same connection string I use for
c#.
On Thu, 2006-09-14 at 22:53 -0500, Luke Paireepinart wrote:
> Chris Hengge wrote:
>
Chris Hengge wrote:
> 4.5 hours... all I'm seeing are a few other libraries, none of which
> mention having windows authentication :/
>
> On Thu, 2006-09-14 at 16:12 -0700, Chris Hengge wrote:
>
>> Does anyone know how to make pymssql use windows authentication?
>>
>>
No, but if you know
4.5 hours... all I'm seeing are a few other libraries, none of which
mention having windows authentication :/
On Thu, 2006-09-14 at 16:12 -0700, Chris Hengge wrote:
> Does anyone know how to make pymssql use windows authentication?
>
> Also, can anyone point me to a simple ODBC guide for SQL?
Does anyone know how to make pymssql use windows authentication?
Also, can anyone point me to a simple ODBC guide for SQL?
I'd like to use ODBC if I can so that users of my software dont have to install extra libraries to use my utilities.
Thanks.
__
12 matches
Mail list logo
