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 databases now.

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 incarnation

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 incarnation

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 the past,

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 default

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 =

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;