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 derfloh 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
Joined
Feb 21, 2001
Messages
10
Location
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

Swi
  • Question Question
VB6 Successor
Replies
7
Views
121
Swi
Swi
wires
  • Locked
  • Question Question
Install VB6 IDE and Access97 on W11 ARM version
Replies
3
Views
1K
Gabor526
G
S
  • Locked
  • Question Question
Replace the chart in the array and substitute the name in textboxt multiline(Vb6)
Replies
0
Views
276
satriano
S
Andrzejek
  • Locked
  • Question Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
590
Andrzejek
Andrzejek
Ken01
  • Locked
  • Question Question
Areas under graphs and overlap areas between circles.
Replies
3
Views
1K
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top