Connection to MS-SQL Server (question of which objects to use)...
- From: "Blue Streak" <rdlebreton@xxxxxxxxxxx>
- Date: 21 Dec 2006 14:22:26 -0800
Hello, Folks!
I'm learning VBScript (ASP.Classic, WSH) through the "School of Hard
Knocks". Right now I am confused about the different methods of
connecting to an SQL Server. That is where and when (or not) to use
them. I have been trying to read up on the following methods:
ADO:
e.g. Set objSQLconn = CreateObject("ADODB.Connection")
SQLDMO:
e.g. Set objSQLserver = CreateObject("SQLDMO.SqlServer")
SQLOLE:
e.g. Set objSQLServer = CreateObject("SQLOLE.SqlServer")
When do and don't you use each of these?
Are there any good web sites with tutorials on these methods?
Are there any more way to connect to an SQL server?
I've got so many acronyms swimming inside my head I don't know what
anything stands for anymore.
< sigh! >
Any ideas?
TIA...
.
- Follow-Ups:
- Prev by Date: Verifying if ntfs files/folders rights are inherited or not...
- Next by Date: Looking for a script that will list all groups in DomainB that a user in DomainA is a member of
- Previous by thread: Verifying if ntfs files/folders rights are inherited or not...
- Next by thread: Re: Connection to MS-SQL Server (question of which objects to use)...
- Index(es):
Relevant Pages
|
