On Dec 20, 10:01 pm, bill ramsay <[EMAIL PROTECTED]> wrote: > On Fri, 14 Dec 2007 23:35:00 -0300, "Gabriel Genellina" > > <[EMAIL PROTECTED]> wrote: > >En Fri, 14 Dec 2007 23:24:24 -0300, Unknown <[EMAIL PROTECTED]> > >escribió: > > >> I have successfully connected to SQL2000 and MSDEE databases in the > >> past, however I have to move to SQL2005 and SQLEXPRESS databases now. > > >> Conn.ConnectionString = "Provider=SQLNCLI;Server=10.1.1.2; > >> Database=csrctest;Uid=bill;Pwd=bill" > > >Look for the right spelling athttp://www.connectionstrings.com/ > > looks like my spelling is ok, any other ideas? > > thanks for the suggestion above. > > kind regards > > bill
This is working for me to the internal network (I'm using adodbapi, but the connection string should be the same) 'Provider=sqloledb;Data Source=dbserv;Initial Catalog=ndb;User Id=foo;Password=bar;' I just tested, and this works well too 'Provider=SQLNCLI;Data Source=dbserv;Initial Catalog=ndb;User Id=foo;Password=bar;' and to my local instance (Hermes is my machine) 'Provider=SQLNCLI;Data Source=HERMES\\SQLEXPRESS;Initial Catalog=;User Id=sa;Password=pw666;' Can you connect to the server using SqlServer Management Studio? Can you create an odbc connection to the server? Unlike 2000, SqlServer 2005 has tcp/ip connections turned off by default, so you might want to check that with the SqlServer Surface Area Configuration tool. Externally we're still running 2000, so I don't know how connecting over the interweb differs. When you've figured out how to connect, and if you're open to a suggestion, you might want to try out the adodbapi package (http:// adodbapi.sourceforge.net/). It is a thin wrapper over ADO, and works quite well. Then you'll get to use the Python db-api v.2.0 syntax, which is oodles less typing than straight ADO. -- bjorn -- http://mail.python.org/mailman/listinfo/python-list
