|
 |
aspx thread: Re: problem with "A Preview of ASP+" Database sample
Message #1 by Imar Spaanjaars <Imar@S...> on Sat, 07 Oct 2000 14:42:00 +0200
|
|
Hi there,
Does anybody still have a copy of the files "AdvWorks_InsertData.sql" and
"AdvWorks_CreateTables.sql"??
I downloaded them from the Wrox ASP+ website, but the tables that these
scripts create don't match with the sourcecode and the book. The book for
instance references a table called Shipping_Methods, but this table is not
created by the SQL scripts.
Or am I overlooking something completely??
Thanks,
Imar
At 01:05 PM 8/24/2000 +0100, you wrote:
>Arrgghhh! My fault again. I knew Rich had updated the database, but I
>obviously forgot to overwrite my existing copy before scripting the stuff
>out. Attached are the scripts from the new db.
>
>Dave
>
>"Chris Loris" <cloris@c...> wrote in message news:9828@a...
> >
> > In the SQL Scripts, it looks like they were produced form an older
> > database. There is a discrpenacy with field names in the Accounts Table
> > and the case is different for the column names in the orders table. This
> > causes a problem in some of the code that is case sensitive to column
> > names.
> >
> > Also, some of the product header graphics are named plurally (ie,
> > bootsigif) when they are referred to singularly in the code... boot.gif.
> >
> > Chris Loris
> > http://loris.dyndns.org
> >
> >
>
>
>
>
>
>
>
>---
Message #2 by "Kukreja, Puneet" <kukrejap@a...> on Mon, 9 Oct 2000 09:15:17 +1100
|
|
Well I am facing the same problem if you get a hang of it please could you
forward the same to me..
Hey another question how do I set these files up, well do I put them all on
the server or is there any other intelligent way of doing it. ??
Thanks
Puneet
-----Original Message-----
From: Imar Spaanjaars [mailto:Imar@S...]
Sent: Saturday, 7 October 2000 10:42 PM
To: ASP+
Subject: [aspx] Re: problem with "A Preview of ASP+" Database sample
Hi there,
Does anybody still have a copy of the files "AdvWorks_InsertData.sql" and
"AdvWorks_CreateTables.sql"??
I downloaded them from the Wrox ASP+ website, but the tables that these
scripts create don't match with the sourcecode and the book. The book for
instance references a table called Shipping_Methods, but this table is not
created by the SQL scripts.
Or am I overlooking something completely??
Thanks,
Imar
At 01:05 PM 8/24/2000 +0100, you wrote:
>Arrgghhh! My fault again. I knew Rich had updated the database, but I
>obviously forgot to overwrite my existing copy before scripting the stuff
>out. Attached are the scripts from the new db.
>
>Dave
>
>"Chris Loris" <cloris@c...> wrote in message news:9828@a...
> >
> > In the SQL Scripts, it looks like they were produced form an older
> > database. There is a discrpenacy with field names in the Accounts Table
> > and the case is different for the column names in the orders table.
This
> > causes a problem in some of the code that is case sensitive to column
> > names.
> >
> > Also, some of the product header graphics are named plurally (ie,
> > bootsigif) when they are referred to singularly in the code... boot.gif.
> >
> > Chris Loris
> > http://loris.dyndns.org
> >
> >
>
>
>
>
>
>
>
>---
---
Message #3 by Imar Spaanjaars <Imar@S...> on Mon, 09 Oct 2000 09:34:45 +0200
|
|
Well, you could copy them all to the server into their own directory /
application, or in another existing application.
I prefer to copy them one by one, as I proceed through the book. This way,
you'll only get what you need.
Imar
At 09:15 AM 10/9/2000 +1100, you wrote:
>Well I am facing the same problem if you get a hang of it please could you
>forward the same to me..
>
>Hey another question how do I set these files up, well do I put them all on
>the server or is there any other intelligent way of doing it. ??
>
>Thanks
>
>Puneet
Message #4 by Imar Spaanjaars <Imar@S...> on Tue, 10 Oct 2000 08:40:21 +0200
|
|
Hi there,
I got a tip from Steve Persighetti who said that the tables and content for
the AdvWorks database, can also be created from AdvWorks.mdb. This file is
installed when you install the Microsoft Platform SDK. The AdvWorks.mdb is
part of the sample section on RDS and get installed in C:\Program
Files\Microsoft Platform SDK\Samples\DataAccess\rds\RDSTest by default.
Let me know if you need the database, so I can mail it to you. Please state
your Access version in that case.
Imar
At 09:15 AM 10/9/2000 +1100, you wrote:
>Well I am facing the same problem if you get a hang of it please could you
>forward the same to me..
>
>Hey another question how do I set these files up, well do I put them all on
>the server or is there any other intelligent way of doing it. ??
>
>Thanks
>
>Puneet
>-----Original Message-----
>From: Imar Spaanjaars [mailto:Imar@S...]
>Sent: Saturday, 7 October 2000 10:42 PM
>To: ASP+
>Subject: [aspx] Re: problem with "A Preview of ASP+" Database sample
>
>
>Hi there,
>
>Does anybody still have a copy of the files "AdvWorks_InsertData.sql" and
>"AdvWorks_CreateTables.sql"??
>I downloaded them from the Wrox ASP+ website, but the tables that these
>scripts create don't match with the sourcecode and the book. The book for
>instance references a table called Shipping_Methods, but this table is not
>created by the SQL scripts.
>
>Or am I overlooking something completely??
>
>
>Thanks,
>
>Imar
>
>
>
>At 01:05 PM 8/24/2000 +0100, you wrote:
> >Arrgghhh! My fault again. I knew Rich had updated the database, but I
> >obviously forgot to overwrite my existing copy before scripting the stuff
> >out. Attached are the scripts from the new db.
> >
> >Dave
> >
> >"Chris Loris" <cloris@c...> wrote in message news:9828@a...
> > >
> > > In the SQL Scripts, it looks like they were produced form an older
> > > database. There is a discrpenacy with field names in the Accounts Table
> > > and the case is different for the column names in the orders table.
>This
> > > causes a problem in some of the code that is case sensitive to column
> > > names.
> > >
> > > Also, some of the product header graphics are named plurally (ie,
> > > bootsigif) when they are referred to singularly in the code... boot.gif.
> > >
> > > Chris Loris
> > > http://loris.dyndns.org
> > >
Message #5 by Imar Spaanjaars <Imar@S...> on Tue, 10 Oct 2000 08:46:37 +0200
|
|
After some more searching, the file also seems to appear inside another
file: RDS.cab, located somewhere in the Windows NT Option Pack directory
structure.
HtH.
Imar
At 09:15 AM 10/9/2000 +1100, you wrote:
>Well I am facing the same problem if you get a hang of it please could you
>forward the same to me..
>
>Hey another question how do I set these files up, well do I put them all on
>the server or is there any other intelligent way of doing it. ??
>
>Thanks
Message #6 by "Kukreja, Puneet" <kukrejap@a...> on Fri, 13 Oct 2000 10:07:55 +1100
|
|
Hi Imar,
Please do the needful as it will be of great help and there is another
question that I have for you, do we need to use the ToString() function to
convert the struing types to make the application work properly...because it
gives casting errors if I do not do it that way.
Hey another question, If you have a working version of the ADVWOERKS
application with mdb database can you forward it to me.
Regards Puneet.
-----Original Message-----
From: Imar Spaanjaars [mailto:Imar@S...]
Sent: Tuesday, 10 October 2000 4:40 PM
To: ASP+
Subject: [aspx] Re: problem with "A Preview of ASP+" Database sample
Hi there,
I got a tip from Steve Persighetti who said that the tables and content for
the AdvWorks database, can also be created from AdvWorks.mdb. This file is
installed when you install the Microsoft Platform SDK. The AdvWorks.mdb is
part of the sample section on RDS and get installed in C:\Program
Files\Microsoft Platform SDK\Samples\DataAccess\rds\RDSTest by default.
Let me know if you need the database, so I can mail it to you. Please state
your Access version in that case.
Imar
At 09:15 AM 10/9/2000 +1100, you wrote:
>Well I am facing the same problem if you get a hang of it please could you
>forward the same to me..
>
>Hey another question how do I set these files up, well do I put them all on
>the server or is there any other intelligent way of doing it. ??
>
>Thanks
>
>Puneet
>-----Original Message-----
>From: Imar Spaanjaars [mailto:Imar@S...]
>Sent: Saturday, 7 October 2000 10:42 PM
>To: ASP+
>Subject: [aspx] Re: problem with "A Preview of ASP+" Database sample
>
>
>Hi there,
>
>Does anybody still have a copy of the files "AdvWorks_InsertData.sql" and
>"AdvWorks_CreateTables.sql"??
>I downloaded them from the Wrox ASP+ website, but the tables that these
>scripts create don't match with the sourcecode and the book. The book for
>instance references a table called Shipping_Methods, but this table is not
>created by the SQL scripts.
>
>Or am I overlooking something completely??
>
>
>Thanks,
>
>Imar
>
>
>
>At 01:05 PM 8/24/2000 +0100, you wrote:
> >Arrgghhh! My fault again. I knew Rich had updated the database, but I
> >obviously forgot to overwrite my existing copy before scripting the stuff
> >out. Attached are the scripts from the new db.
> >
> >Dave
> >
> >"Chris Loris" <cloris@c...> wrote in message news:9828@a...
> > >
> > > In the SQL Scripts, it looks like they were produced form an older
> > > database. There is a discrpenacy with field names in the Accounts
Table
> > > and the case is different for the column names in the orders table.
>This
> > > causes a problem in some of the code that is case sensitive to column
> > > names.
> > >
> > > Also, some of the product header graphics are named plurally (ie,
> > > bootsigif) when they are referred to singularly in the code...
boot.gif.
> > >
> > > Chris Loris
> > > http://loris.dyndns.org
> > >
---
Message #7 by Imar Spaanjaars <Imar@S...> on Fri, 13 Oct 2000 09:32:40 +0200
|
|
Hi there,
If everything works out OK, the new SQL scripts will be available at the
Wrox site shortly. (So I was told).
In the mean time, I'll mail you the Access MDB file.
Imar
At 10:07 AM 10/13/2000 +1100, you wrote:
>Hi Imar,
>Please do the needful as it will be of great help and there is another
>question that I have for you, do we need to use the ToString() function to
>convert the struing types to make the application work properly...because it
>gives casting errors if I do not do it that way.
>
>Hey another question, If you have a working version of the ADVWOERKS
>application with mdb database can you forward it to me.
>
>Regards Puneet.
>
>-----Original Message-----
>From: Imar Spaanjaars [mailto:Imar@S...]
>Sent: Tuesday, 10 October 2000 4:40 PM
>To: ASP+
>Subject: [aspx] Re: problem with "A Preview of ASP+" Database sample
>
>
>Hi there,
>
>I got a tip from Steve Persighetti who said that the tables and content for
>the AdvWorks database, can also be created from AdvWorks.mdb. This file is
>installed when you install the Microsoft Platform SDK. The AdvWorks.mdb is
>part of the sample section on RDS and get installed in C:\Program
>Files\Microsoft Platform SDK\Samples\DataAccess\rds\RDSTest by default.
>
>Let me know if you need the database, so I can mail it to you. Please state
>your Access version in that case.
>
>Imar
>
>
>At 09:15 AM 10/9/2000 +1100, you wrote:
> >Well I am facing the same problem if you get a hang of it please could you
> >forward the same to me..
> >
> >Hey another question how do I set these files up, well do I put them all on
> >the server or is there any other intelligent way of doing it. ??
> >
> >Thanks
> >
> >Puneet
> >-----Original Message-----
> >From: Imar Spaanjaars [mailto:Imar@S...]
> >Sent: Saturday, 7 October 2000 10:42 PM
> >To: ASP+
> >Subject: [aspx] Re: problem with "A Preview of ASP+" Database sample
> >
> >
> >Hi there,
> >
> >Does anybody still have a copy of the files "AdvWorks_InsertData.sql" and
> >"AdvWorks_CreateTables.sql"??
> >I downloaded them from the Wrox ASP+ website, but the tables that these
> >scripts create don't match with the sourcecode and the book. The book for
> >instance references a table called Shipping_Methods, but this table is not
> >created by the SQL scripts.
> >
> >Or am I overlooking something completely??
> >
> >
> >Thanks,
> >
> >Imar
> >
> >
> >
> >At 01:05 PM 8/24/2000 +0100, you wrote:
> > >Arrgghhh! My fault again. I knew Rich had updated the database, but I
> > >obviously forgot to overwrite my existing copy before scripting the stuff
> > >out. Attached are the scripts from the new db.
> > >
> > >Dave
> > >
> > >"Chris Loris" <cloris@c...> wrote in message news:9828@a...
> > > >
> > > > In the SQL Scripts, it looks like they were produced form an older
> > > > database. There is a discrpenacy with field names in the Accounts
>Table
> > > > and the case is different for the column names in the orders table.
> >This
> > > > causes a problem in some of the code that is case sensitive to column
> > > > names.
> > > >
> > > > Also, some of the product header graphics are named plurally (ie,
> > > > bootsigif) when they are referred to singularly in the code...
>boot.gif.
> > > >
> > > > Chris Loris
> > > > http://loris.dyndns.org
> > > >
>
>
>
>---
>
|
|
|
View Cart
