Win32 Com + ADO: How to compare the result of a recordset to 'nothing'

Bob Gailer bgailer at alum.rpi.edu
Mon Sep 15 16:51:31 CEST 2003


At 07:53 AM 9/15/2003, Felix McAllister wrote:
>[snip]
>The code is as follows:
>###########################3
>import win32com.client
>conn = win32com.client.Dispatch("ADODB.Connection")
>conn.ConnectionString = "Driver={SQL 
>Server};Server=(local);Database=Test;Trusted_Connection=yes;"
>conn.Open()
>rs = conn.Execute("TestSPXML")[0]
>xmlString = ""
>while rs != None:
>     rs.MoveFirst()    # FAILS HERE ON THE SECOND ITERATION OF THE LOOP
>     while not rs.EOF:
>         xmlString = xmlString + rs.Fields[0].Value
>         rs.MoveNext()
>     rs = rs.NextRecordSet()
>print xmlString
>conn.Close()

I am learning how to use ADODB with SQL Server, so your example is very 
timely. I know that I have to change the ConnectionString, as I get this 
error when running your example: "'Microsoft OLE DB Provider for ODBC 
Drivers', '[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server 
does not exist or access denied.'"

What do I have to change?

Bob Gailer
bgailer at alum.rpi.edu
303 442 2625
-------------- next part --------------

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003


More information about the Python-list mailing list