hello there

I am having dificulty understanding how I set up my database using SQL 
Server. - Where do I put the databases that I downloaded for this book and 
can anybody please explain how to activate them with my server I have 
managed with other databases from other programmes but this one has me 
stumped

Jacqui

> hello there

> I am having dificulty understanding how I set up my database using SQL 
S> erver. - Where do I put the databases that I downloaded for this book 
and 
c> an anybody please explain how to activate them with my server I have 
m> anaged with other databases from other programmes but this one has me 
s> tumped

> Jacqui

I have decided to go with the Access Database but I am having trouble with 
the first Try It Out on page 87.

my code is:

set oRSi=Server.CreateObject("ADODB.recordset")
oRS.open "items", "dsn=clothier"
oRSI.MoveFirst

error message is

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/asp_ado/SimpleRS.asp, line 11

What am I doing wrong?

On the first line you have

<%set oRSi=Server.CreateObject("ADODB.recordset")%>

and on the second line you have

<%oRS.open "items", "dsn=clothier"%>

Can you see that one object is called oRSi and the second is called oRS?
Hence the "object required" error. oRS doesn't refer to an object. oRSi on
the other hand refers to an ADODB.Recordset object.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Jacqui Bourne" <jacquibourne7@a...>
Subject: [asp_databases] Re: Beginning ASP Databases


: > hello there
:
: > I am having dificulty understanding how I set up my database using SQL
: S> erver. - Where do I put the databases that I downloaded for this book
: and
: c> an anybody please explain how to activate them with my server I have
: m> anaged with other databases from other programmes but this one has me
: s> tumped
:
: > Jacqui
:
: I have decided to go with the Access Database but I am having trouble with
: the first Try It Out on page 87.
:
: my code is:
:
: set oRSi=Server.CreateObject("ADODB.recordset")
: oRS.open "items", "dsn=clothier"
: oRSI.MoveFirst
:
: error message is
:
: Error Type:
: Microsoft VBScript runtime (0x800A01A8)
: Object required: ''
: /asp_ado/SimpleRS.asp, line 11
:
: What am I doing wrong?