How to get XML from a SQL XML query to use with an XMLAd

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to get XML from a SQL XML query to use with an XMLAd

Message

From

12/11/2004 13:55:53

Randy Hersom
Habilitation Software Inc.
Morganton, North Carolina, United States

16/02/2004 12:22:26

Robert Baker
Zxytek
Coto de Caza, California, United States

General information

Forum:

Visual FoxPro

Category:

Other

Title:

Re: How to get XML from a SQL XML query to use with an XMLAd

Miscellaneous

Thread ID:

00877690

Message ID:

00960954

Views:

I had the same problem, working through ADO.

googling led me to this URL

http://sqlxml.org/faqs.aspx?faq=104

I changed my connection string from PROVIDER=SQLOLEDB to Driver={SQL Server} and the XML started coming out as valid XML text instead of binary garbage.

Randy Hersom
President, Habilitation Software Inc.

Map

View

Click here to load this message in the networking platform