Very good, so easy.

MSSQL 7 doesn't support the openxml thing. :-(. There's probably a workaround but I've got the string thing happening now where I just pass a string...

Thanks again.

How do I save a recordset or a list of numbers into XML in VB, the number field is an int. I can't find any documentation on it. This...

Thanks for the replies. I'll look into the XML thing, I don't know any XML.

The process is:

In VB I create an ADO recordset of a list of numbers from a...

Thanks but it didn't work. I see the problem though.

It's OK if I cast the individual fields; but that doesn't work for other queries. I have something to work...

Thank you very much, very helpful.

Bruce

Thanks Steve, you've given me plenty to work with I'm starting testing tomorrow. One more query though; would replication be more secure i.e. a copy of the data is kept...

Is it as simple as this:

the private network gives access to the webserver IP through port 1433. The webserver connects to '192.168.?.???:1433'

or am I missing something?

The asp page accesses a...