Re: Connecting to SQL database

2007-12-20 Thread Rob Williscroft
bill ramsay wrote in news:[EMAIL PROTECTED] in comp.lang.python: > Hi > > I have successfully connected to SQL2000 and MSDEE databases in the > > Conn = Dispatch('ADODB.Connection') > Conn.ConnectionString = "Provider=SQLNCLI;Server=10.1.1.2; > Database=csrctest;Uid=bill;Pwd=bill" By

Re: Connecting to SQL database

2007-12-20 Thread thebjorn
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

Re: Connecting to SQL database

2007-12-20 Thread kyosohma
On Dec 14, 8:24 pm, bill ramsay <[EMAIL PROTECTED]> wrote: > Hi > > I have successfully connected to SQL2000 and MSDEE databases in the > past, however I have to move to SQL2005 and SQLEXPRESS databases now. > > I've tried the following but with no luck [this is what i used in the > earlier incarn

Re: Connecting to SQL database

2007-12-20 Thread kyosohma
On Dec 14, 8:24 pm, bill ramsay <[EMAIL PROTECTED]> wrote: > Hi > > I have successfully connected to SQL2000 and MSDEE databases in the > past, however I have to move to SQL2005 and SQLEXPRESS databases now. > > I've tried the following but with no luck [this is what i used in the > earlier incarn

Re: Connecting to SQL database

2007-12-20 Thread bill ramsay
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 datab

Re: Connecting to SQL database

2007-12-14 Thread Gabriel Genellina
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=cs

Connecting to SQL database

2007-12-14 Thread bill ramsay
Hi I have successfully connected to SQL2000 and MSDEE databases in the past, however I have to move to SQL2005 and SQLEXPRESS databases now. I've tried the following but with no luck [this is what i used in the earlier incarnation except the Provider resource was SQLOLEDB.1] Conn = Dispatch