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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

communication between VB6 and SQLserver2000 with XML

Status
Not open for further replies.
BlackBox

BlackBox

Programmer
Feb 21, 2001
10
0
0
BE
Can anyone email me some code or give me a hint on how to communicate in a C/S appl between SQLserver2000 Database and a VB6.0 application using XML.
 
Sort by date Sort by votes
ADO 2.5 offers the feature to save a recordset to a XML file format. I believe it is the SAVE method of the recordset object.
 
Upvote 0 Downvote
When u communicate with the sql 2000 from vb,

select stmts in sql 2000 can end with FOR XML raw mode , exclusive mode and so on ...so that the output of the sql 2000 will be a well formed xml and this later can be loaded into a msxml document in vb to traverse the nodes.

Srikanth
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
195
strongm
strongm
sal21
  • Locked
  • Question
read xml file 1
Replies
9
Views
127
Andrzejek
Andrzejek
Ken01
  • Locked
  • Question
I have a program, developed in VB6
Replies
6
Views
163
Ken01
Ken01
gmmastros
  • Locked
  • Question
VB6 Post to webservice with MSXML2 error
Replies
4
Views
277
dilettante
dilettante
BigTG
  • Locked
  • Question
Legacy VB6 program
Replies
4
Views
120
xwb
xwb

Part and Inventory Search

Sponsor

Back
Top