The url should be of the form: mssql://user:[EMAIL PROTECTED]/database
Where server is the name or IP address of your SQL Server and database is the name of the database on that server. Hope that helps. Cheers, Gary. Scott Jaderholm wrote: > On 9/17/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> see some notes at >> http://www.sqlalchemy.org/trac/wiki/DatabaseNotes > > Thank you svil for the link and helpful reply. > > I'm afraid though that I still don't understand how to correctly setup > the connection. Slow learner I guess. > > DatabaseNotes gives the following example: > db = create_engine('mssql://user:[EMAIL PROTECTED]', module=pymssql) > > but that doesn't help me much since it's not clear what goes in the place of > db. > > Am I supposed to create a system/file DSN under Windows with the ODBC > Data Source Administrator? If username and password are in the DSN do > they need to be in the url? Is hostname going to be host\instance? > > Sorry if the answers to these questions are obvious. > > Thanks, > Scott > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
