13 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: Connecting to an MS ...
FromSent OnAttachments
TkNeo15 May 2008 09:03 
Yannick Gingras15 May 2008 10:51 
Rick Morrison15 May 2008 11:29 
TkNeo15 May 2008 13:48 
Rick Morrison15 May 2008 14:00 
Olivier Thiery15 May 2008 14:49 
Lukasz Szybalski15 May 2008 19:34 
TkNeo22 May 2008 08:15 
TkNeo22 May 2008 08:24 
Michael Bayer22 May 2008 08:38 
TkNeo22 May 2008 11:19 
Kipb22 May 2008 17:25 
Lukasz Szybalski22 May 2008 22:08 
Subject:[sqlalchemy] Re: Connecting to an MS SQL server ?
From:Yannick Gingras (ygin@ygingras.net)
Date:05/15/2008 10:51:23 AM
List:com.googlegroups.sqlalchemy

TkNeo <taru@gmail.com> writes:

Hi,

Hello Tarun,

This is my first encounter with sqlalchemy. I am trying to connect to an MS SQL server 2000 that is not on local host. I want to connect using Integrated Security and not use a specific username and password. Can anyone tell me the format of the connection string ?

I don't know about Integrated Security but we use alchemy to connect to a MSSQL from a GNU/Linux box and it works really well. We use Unix ODBC with TDS with the DSN registered with the local ODBC.

Take a look at

http://www.lucasmanual.com/mywiki/TurboGears#head-4a47fe38beac67d9d03e49c4975cfc3dd165fa31

My obdb.ini looks like

[JDED] Driver = TDS Trace = No Server = 192.168.33.53 Port = 1433

and my alchemy connection string is

mssql://user:pass@/?dsn=JDED&scope_identity=1

-- Yannick Gingras

--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups
"sqlalchemy" group. To post to this group, send email to sqla@googlegroups.com To unsubscribe from this group, send email to
sqla@googlegroups.com For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---