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 SQL 2005 doesn't enable the TCP/IP protocol, if your app'
is running on the same machine use either the machine name or a
period (.) and it will use the Shared Memory protocol.
You will also need the server instance name(*), so it would be:
"Provider=SQLNCLI;Server=.\SQLEXPRESS;Datab..."
*) IIRC you can't install express as the "Default" instance so
this will be required.
If you need to enable TCP/IP use the "SQL Server Configuration Manager"
about 4 levels deep from the "Start" menu. Remember to enable it for
the server and SQLNCLI.
Rob.
--
http://www.victim-prime.dsl.pipex.com/
--
http://mail.python.org/mailman/listinfo/python-list
