Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL SERVER ODBC DRIVER SUPPORT XML FOR DATA TRANSFER?

Status
Not open for further replies.

pao13

Programmer
Sep 22, 2003
6
GR
I have an application in vb.net that it was migrated from vb6.I have change all the ActiveX controls to vb.net controls except ado.To connect to the sql server database i use this statement:DBConn.Open("driver={SQL Server};" & "server=" strServer "; uid=userid;pwd=password;database=databasename").
I want the data that transfered from user to server and back, to be in xml.I don't know in what format data is now.
 
Use the SQL Server BooksOnLine, and search for "FOR XML AUTO".

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top