The method you are using to open your recordset is just fine. What's actually happening is that ADO is automatically creating a connection object for you behind the scenes. The reason for explicitly creating the Connection object is to set it's properties to something other than the default values, which is what you get when you pass the connection information to the Recordset's Open method.
An excellent book on ADO is Wrox Press' ADO 2.0 Programmers Reference by Sussman and Homer (ISBN 1-861001-83-5).
HTH
>Here are some questions that have been puzzling me, i would greatly appreciate the help. Thanks!
>
>1. What is ADODB.Connection? How do I use it? All I do to connect to the database is the ff.:
>
>set new_rs = server.CreateObject("ADODB.Recordset")
>new_rs.Open new_qry,"DSN=systemdsn;UID=sa;PWD="
>
>and it works. Would having a server.CreateObject("ADODB.Connection")
>improve my script?
>
>2. Where can I find documentation regarding ADODB so that I can find out more about what objects to create and how to use them?
>
>Again, thanks
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
