Carl
|
| Posted: 09/01/2002, 4:06 PM |
|
I tried the bookstore sample with both CCS & CC.
When I try to add a credit card type on CCS I get:
Source: Record card_types / Insert Operation
Command Text: INSERT INTO [card_types]([name]) VALUES ('Master Card')
Error description: [Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query. (Microsoft OLE DB Provider for ODBC Drivers)
INSERT INTO [card_types]([name]) VALUES ('Master Card')
On CC it's a shorter error message but the bottom line is that while I can
view all that pages, nothing that involves adding a record works. Is this by
design in the examples?
I also created a new test bookstore using the Wizard in CCS. Had the same
result.
I'm trying to decide if I should buy either of these products but It's
difficult to do so if an insert does not work.
Does anyone know what I'm missing here???
TIA.
Carl
--
Web Hosting by Infotech Internet Services
Itis.net, Inc. - http://itis.net
|
|
|
 |
Kelvin Chua
|
| Posted: 09/01/2002, 5:15 PM |
|
You have to change the security permissions at your database to enable you
to add. Currently, you had only set it to Read-Only.
Thanks.
Kelvin Chua
SINGAPORE
"Carl" <herrecm@itis.net> wrote in message
news:aku6hc$je$1@news.codecharge.com...
> I tried the bookstore sample with both CCS & CC.
>
> When I try to add a credit card type on CCS I get:
> Source: Record card_types / Insert Operation
> Command Text: INSERT INTO [card_types]([name]) VALUES ('Master Card')
> Error description: [Microsoft][ODBC Microsoft Access Driver] Operation
must
> use an updateable query. (Microsoft OLE DB Provider for ODBC Drivers)
> INSERT INTO [card_types]([name]) VALUES ('Master Card')
>
>
>
> On CC it's a shorter error message but the bottom line is that while I can
> view all that pages, nothing that involves adding a record works. Is this
by
> design in the examples?
>
> I also created a new test bookstore using the Wizard in CCS. Had the same
> result.
>
> I'm trying to decide if I should buy either of these products but It's
> difficult to do so if an insert does not work.
>
> Does anyone know what I'm missing here???
>
> TIA.
> Carl
>
> --
> Web Hosting by Infotech Internet Services
> Itis.net, Inc. - http://itis.net
>
>
|
|
|
|
Carl
|
| Posted: 09/02/2002, 12:47 PM |
|
Nope. It's not set to read only. First thing I checked. That's what
troubled me.
Carl
"Kelvin Chua" <NOkelvinSPAM@accpro.com.sg> wrote in message
news:akuaj1$78d$1@news.codecharge.com...
> You have to change the security permissions at your database to enable you
> to add. Currently, you had only set it to Read-Only.
>
> Thanks.
>
> Kelvin Chua
> SINGAPORE
|
|
|
|
DonB
|
| Posted: 09/02/2002, 1:04 PM |
|
Access wants a primary key to be defined or it won't allow a table to be
updated. At least it used to - been awhile since I've used it. I expect
that is still true, though. Check your table(s).
Also, I like to pull "bad" queries out and execute them directly, to compare
the results. Sometimes I get more (detailed) info that way.
DonB
"Carl" <herrecm@itis.net> wrote in message
news:al0f8t$4d1$1@news.codecharge.com...
> Nope. It's not set to read only. First thing I checked. That's what
> troubled me.
>
> Carl
>
> "Kelvin Chua" <NOkelvinSPAM@accpro.com.sg> wrote in message
>news:akuaj1$78d$1@news.codecharge.com...
> > You have to change the security permissions at your database to enable
you
> > to add. Currently, you had only set it to Read-Only.
> >
> > Thanks.
> >
> > Kelvin Chua
> > SINGAPORE
>
>
>
|
|
|
|
DonB
|
| Posted: 09/02/2002, 1:09 PM |
|
Editorial Comment: Don't make Access your database for apps. Just about
anything is more robust and reliable. Access is very good for the
single-user, desktop database model for which it was designed. Just a pain
in the rear for anything else.
DonB
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:al0g7l$646$1@news.codecharge.com...
> Access wants a primary key to be defined or it won't allow a table to be
> updated. At least it used to - been awhile since I've used it. I expect
> that is still true, though. Check your table(s).
>
> Also, I like to pull "bad" queries out and execute them directly, to
compare
> the results. Sometimes I get more (detailed) info that way.
>
> DonB
>
>
> "Carl" <herrecm@itis.net> wrote in message
>news:al0f8t$4d1$1@news.codecharge.com...
> > Nope. It's not set to read only. First thing I checked. That's what
> > troubled me.
> >
> > Carl
> >
> > "Kelvin Chua" <NOkelvinSPAM@accpro.com.sg> wrote in message
> >news:akuaj1$78d$1@news.codecharge.com...
> > > You have to change the security permissions at your database to enable
> you
> > > to add. Currently, you had only set it to Read-Only.
> > >
> > > Thanks.
> > >
> > > Kelvin Chua
> > > SINGAPORE
> >
> >
> >
>
>
|
|
|
|
Carl
|
| Posted: 09/02/2002, 4:23 PM |
|
I run a 1.8 Million record db on the web with access.. Have never had a
problem. I don't believe that to be the issue. Regardless, I'm testing
this on my XP Pro PC with IIS. I'm the only user, so it should not hiccup.
I thought that since the BookStore is an example, that it would be a working
example. So if CCS needs a Primary Key, the DB should have it. Anyway,
the tables do have primary keys.
No problem. I'll keep checking the newsgroup, but I won't buy unless these
types of issues can be resolved. My trial days are expiring though... so
it's going to be a tough sell.
Hard to think that I'll write a better app than the developers. So if their
examples don't work, I'm sunk.
Thanks to all once again.
Carl
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:al0gi8$6i9$1@news.codecharge.com...
> Editorial Comment: Don't make Access your database for apps. Just about
> anything is more robust and reliable. Access is very good for the
> single-user, desktop database model for which it was designed. Just a
pain
> in the rear for anything else.
>
> DonB
>
>
> "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
>news:al0g7l$646$1@news.codecharge.com...
> > Access wants a primary key to be defined or it won't allow a table to be
> > updated. At least it used to - been awhile since I've used it. I
expect
> > that is still true, though. Check your table(s).
> >
> > Also, I like to pull "bad" queries out and execute them directly, to
> compare
> > the results. Sometimes I get more (detailed) info that way.
> >
> > DonB
> >
> >
> > "Carl" <herrecm@itis.net> wrote in message
> >news:al0f8t$4d1$1@news.codecharge.com...
> > > Nope. It's not set to read only. First thing I checked. That's what
> > > troubled me.
> > >
> > > Carl
> > >
> > > "Kelvin Chua" <NOkelvinSPAM@accpro.com.sg> wrote in message
> > >news:akuaj1$78d$1@news.codecharge.com...
> > > > You have to change the security permissions at your database to
enable
> > you
> > > > to add. Currently, you had only set it to Read-Only.
> > > >
> > > > Thanks.
> > > >
> > > > Kelvin Chua
> > > > SINGAPORE
> > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Shawn Mason
|
| Posted: 09/02/2002, 6:52 PM |
|
Actually, Carl, the error is saying that the query is a view and the ODBC
driver being used to update Access doesn't support inserts or adds to a view
(heck, Sql Server has problems with that...but it has workarounds).
Basically, you shouldn't be using a view on an update form. But, since I
don't know which ones you are referring to I'm not sure. Have you tried the
example using Sql Server? Plus, do a trace on the query being created to
confirm I am correct in my "error reading". (In Sql Server use
Profiler...in Access..not sure).
--
Kindest Regards,
Shawn Mason,CCD,MCP
I.S. Software Design Associates
"Carl" <herrecm@itis.net> wrote in message
news:aku6hc$je$1@news.codecharge.com...
> I tried the bookstore sample with both CCS & CC.
>
> When I try to add a credit card type on CCS I get:
> Source: Record card_types / Insert Operation
> Command Text: INSERT INTO [card_types]([name]) VALUES ('Master Card')
> Error description: [Microsoft][ODBC Microsoft Access Driver] Operation
must
> use an updateable query. (Microsoft OLE DB Provider for ODBC Drivers)
> INSERT INTO [card_types]([name]) VALUES ('Master Card')
>
>
>
> On CC it's a shorter error message but the bottom line is that while I can
> view all that pages, nothing that involves adding a record works. Is this
by
> design in the examples?
>
> I also created a new test bookstore using the Wizard in CCS. Had the same
> result.
>
> I'm trying to decide if I should buy either of these products but It's
> difficult to do so if an insert does not work.
>
> Does anyone know what I'm missing here???
>
> TIA.
> Carl
>
> --
> Web Hosting by Infotech Internet Services
> Itis.net, Inc. - http://itis.net
>
>
|
|
|
|
DonB
|
| Posted: 09/02/2002, 7:10 PM |
|
Equally hard to believe that there is any CCS-specific issue. You can blame
CCS for the problem if you like, but that is simply absurd. I avoid Access,
and XP, for similar reasons. Access is a plague, XP is an epidemic.
Back to the problem, though. Did you attempt to execute the same query IN
Access? If it works, then I'd point my finger at MDAC. Since you said
"XP", that presents a number of issues that need to be looked at, namely the
version of MDAC, the version of Access, the configuration of the datasource,
where the database file is, what permission you have given the IIS anonymous
account, whether you are even USING the anonymous ("IUSR_xxxx") account, how
you configured the website or virtual directory in IIS, and so on.
For what it's worth, I just loaded the example for the first time ever. It
did not work. I moved the database from the examples folder to the IIS
folder where I deployed the application (and altered the connection
properties accordingly, then redeployed). Now it works just fine. (BTW: I
also went back into IIS manager and altered the folder to have the "globe"
icon, by clicking "Create Application". You don't get that by default and
this affects the security context in which the application executes). With
so many configuration variables, it is 99.999% certain you've got something
configured differently than Yes had when they created the example.
Carl, there is little if any magic in these application generators. They
rarely do things that you or I have not done ourselves while coding an
application from scratch. It baffles me why it is always the app
generator's fault when things don't work correctly. In the case of CCS, the
source code it builds is readily available for inspection and is simple and
pretty easy to understand. The cod ethat inserts new card types is
straight ADO code like you'd probably write yourself:
'Insert Method @5-D4A2B444
Sub Insert(Cmd)
CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeBuildInsert", Me)
Set Cmd.Connection = Connection
Cmd.CommandOperation = cmdExec
Cmd.SQL = "INSERT INTO [card_types](" & _
"[name]" & _
") VALUES (" & _
Connection.ToSQL(name.SQLText, name.DataType) & _
")"
CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeExecuteInsert", Me)
Cmd.Exec(Errors)
CCSEventResult = CCRaiseEvent(CCSEvents, "AfterExecuteInsert", Me)
End Sub
'End Insert Method
CCS does a lot of things (like this) that otherwise require tons of
hand-coding. CCS does have a number of warts - none that have proven to be
show stoppers and I've just finished my first major app with 40 or so pages
and lots of customization beyond what CCS produces directly. For something
branded "1.0" it does a damn good job. I've been at least 10x more
productive than if I'd started with Visual Studio or .NET.
CCS does a far better job when a good database engine is used for the
foundation. I'd never deploy a production application with Access - MySQL,
SQL Server, Oracle,etc. - but Access is, always has been, and always will be
a royal pain-in-the-ass. It will work, lots of people use it, but your
playing with dynamite and the fuse is lit.
I bet the example would work just fine if you made one small change - put
the database in the IIS folder (or at least one that is a virtual directory
know to your IIS.
don
"Carl" <herrecm@itis.net> wrote in message
news:al0rtm$qhr$1@news.codecharge.com...
> I run a 1.8 Million record db on the web with access.. Have never had a
> problem. I don't believe that to be the issue. Regardless, I'm testing
> this on my XP Pro PC with IIS. I'm the only user, so it should not hiccup.
>
> I thought that since the BookStore is an example, that it would be a
working
> example. So if CCS needs a Primary Key, the DB should have it. Anyway,
> the tables do have primary keys.
>
> No problem. I'll keep checking the newsgroup, but I won't buy unless
these
> types of issues can be resolved. My trial days are expiring though... so
> it's going to be a tough sell.
>
> Hard to think that I'll write a better app than the developers. So if
their
> examples don't work, I'm sunk.
>
> Thanks to all once again.
> Carl
>
> "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
>news:al0gi8$6i9$1@news.codecharge.com...
> > Editorial Comment: Don't make Access your database for apps. Just
about
> > anything is more robust and reliable. Access is very good for the
> > single-user, desktop database model for which it was designed. Just a
> pain
> > in the rear for anything else.
> >
> > DonB
> >
> >
> > "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
> >news:al0g7l$646$1@news.codecharge.com...
> > > Access wants a primary key to be defined or it won't allow a table to
be
> > > updated. At least it used to - been awhile since I've used it. I
> expect
> > > that is still true, though. Check your table(s).
> > >
> > > Also, I like to pull "bad" queries out and execute them directly, to
> > compare
> > > the results. Sometimes I get more (detailed) info that way.
> > >
> > > DonB
> > >
> > >
> > > "Carl" <herrecm@itis.net> wrote in message
> > >news:al0f8t$4d1$1@news.codecharge.com...
> > > > Nope. It's not set to read only. First thing I checked. That's
what
> > > > troubled me.
> > > >
> > > > Carl
> > > >
> > > > "Kelvin Chua" <NOkelvinSPAM@accpro.com.sg> wrote in message
> > > >news:akuaj1$78d$1@news.codecharge.com...
> > > > > You have to change the security permissions at your database to
> enable
> > > you
> > > > > to add. Currently, you had only set it to Read-Only.
> > > > >
> > > > > Thanks.
> > > > >
> > > > > Kelvin Chua
> > > > > SINGAPORE
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
DonB
|
| Posted: 09/02/2002, 7:13 PM |
|
Access is kind dumb about this particular situation. It refers to "view"
even when there is none. I don't know why. I"m still pondering an error I
used to get in Windows 1.0 that said "Error -- Success". Since then, I
don't take error messages too literally.
don
"Shawn Mason" <shawn@issda.com> wrote in message
news:al14lj$99o$1@news.codecharge.com...
> Actually, Carl, the error is saying that the query is a view and the ODBC
> driver being used to update Access doesn't support inserts or adds to a
view
> (heck, Sql Server has problems with that...but it has workarounds).
> Basically, you shouldn't be using a view on an update form. But, since I
> don't know which ones you are referring to I'm not sure. Have you tried
the
> example using Sql Server? Plus, do a trace on the query being created to
> confirm I am correct in my "error reading". (In Sql Server use
> Profiler...in Access..not sure).
>
> --
> Kindest Regards,
>
> Shawn Mason,CCD,MCP
> I.S. Software Design Associates
>
> "Carl" <herrecm@itis.net> wrote in message
>news:aku6hc$je$1@news.codecharge.com...
> > I tried the bookstore sample with both CCS & CC.
> >
> > When I try to add a credit card type on CCS I get:
> > Source: Record card_types / Insert Operation
> > Command Text: INSERT INTO [card_types]([name]) VALUES ('Master Card')
> > Error description: [Microsoft][ODBC Microsoft Access Driver] Operation
> must
> > use an updateable query. (Microsoft OLE DB Provider for ODBC Drivers)
> > INSERT INTO [card_types]([name]) VALUES ('Master Card')
> >
> >
> >
> > On CC it's a shorter error message but the bottom line is that while I
can
> > view all that pages, nothing that involves adding a record works. Is
this
> by
> > design in the examples?
> >
> > I also created a new test bookstore using the Wizard in CCS. Had the
same
> > result.
> >
> > I'm trying to decide if I should buy either of these products but It's
> > difficult to do so if an insert does not work.
> >
> > Does anyone know what I'm missing here???
> >
> > TIA.
> > Carl
> >
> > --
> > Web Hosting by Infotech Internet Services
> > Itis.net, Inc. - http://itis.net
> >
> >
>
>
|
|
|
|
Kelvin Chua
|
| Posted: 09/02/2002, 7:28 PM |
|
Hi Don,
I like your answer. <G>
Thanks.
Kelvin Chua
SINGAPORE
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:al15n6$ars$1@news.codecharge.com...
> Equally hard to believe that there is any CCS-specific issue. You can
blame
> CCS for the problem if you like, but that is simply absurd. I avoid
Access,
> and XP, for similar reasons. Access is a plague, XP is an epidemic.
>
> Back to the problem, though. Did you attempt to execute the same query IN
> Access? If it works, then I'd point my finger at MDAC. Since you said
> "XP", that presents a number of issues that need to be looked at, namely
the
> version of MDAC, the version of Access, the configuration of the
datasource,
> where the database file is, what permission you have given the IIS
anonymous
> account, whether you are even USING the anonymous ("IUSR_xxxx") account,
how
> you configured the website or virtual directory in IIS, and so on.
>
> For what it's worth, I just loaded the example for the first time ever.
It
> did not work. I moved the database from the examples folder to the IIS
> folder where I deployed the application (and altered the connection
> properties accordingly, then redeployed). Now it works just fine. (BTW: I
> also went back into IIS manager and altered the folder to have the "globe"
> icon, by clicking "Create Application". You don't get that by default and
> this affects the security context in which the application executes).
With
> so many configuration variables, it is 99.999% certain you've got
something
> configured differently than Yes had when they created the example.
>
> Carl, there is little if any magic in these application generators. They
> rarely do things that you or I have not done ourselves while coding an
> application from scratch. It baffles me why it is always the app
> generator's fault when things don't work correctly. In the case of CCS,
the
> source code it builds is readily available for inspection and is simple
and
> pretty easy to understand. The cod ethat inserts new card types is
> straight ADO code like you'd probably write yourself:
>
> 'Insert Method @5-D4A2B444
> Sub Insert(Cmd)
> CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeBuildInsert", Me)
> Set Cmd.Connection = Connection
> Cmd.CommandOperation = cmdExec
> Cmd.SQL = "INSERT INTO [card_types](" & _
> "[name]" & _
> ") VALUES (" & _
> Connection.ToSQL(name.SQLText, name.DataType) & _
> ")"
> CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeExecuteInsert",
Me)
> Cmd.Exec(Errors)
> CCSEventResult = CCRaiseEvent(CCSEvents, "AfterExecuteInsert", Me)
> End Sub
> 'End Insert Method
>
> CCS does a lot of things (like this) that otherwise require tons of
> hand-coding. CCS does have a number of warts - none that have proven to
be
> show stoppers and I've just finished my first major app with 40 or so
pages
> and lots of customization beyond what CCS produces directly. For
something
> branded "1.0" it does a damn good job. I've been at least 10x more
> productive than if I'd started with Visual Studio or .NET.
>
> CCS does a far better job when a good database engine is used for the
> foundation. I'd never deploy a production application with Access -
MySQL,
> SQL Server, Oracle,etc. - but Access is, always has been, and always will
be
> a royal pain-in-the-ass. It will work, lots of people use it, but your
> playing with dynamite and the fuse is lit.
>
> I bet the example would work just fine if you made one small change - put
> the database in the IIS folder (or at least one that is a virtual
directory
> know to your IIS.
>
> don
>
>
> "Carl" <herrecm@itis.net> wrote in message
>news:al0rtm$qhr$1@news.codecharge.com...
> > I run a 1.8 Million record db on the web with access.. Have never had a
> > problem. I don't believe that to be the issue. Regardless, I'm testing
> > this on my XP Pro PC with IIS. I'm the only user, so it should not
hiccup.
> >
> > I thought that since the BookStore is an example, that it would be a
> working
> > example. So if CCS needs a Primary Key, the DB should have it. Anyway,
> > the tables do have primary keys.
> >
> > No problem. I'll keep checking the newsgroup, but I won't buy unless
> these
> > types of issues can be resolved. My trial days are expiring though...
so
> > it's going to be a tough sell.
> >
> > Hard to think that I'll write a better app than the developers. So if
> their
> > examples don't work, I'm sunk.
> >
> > Thanks to all once again.
> > Carl
> >
> > "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
> >news:al0gi8$6i9$1@news.codecharge.com...
> > > Editorial Comment: Don't make Access your database for apps. Just
> about
> > > anything is more robust and reliable. Access is very good for the
> > > single-user, desktop database model for which it was designed. Just a
> > pain
> > > in the rear for anything else.
> > >
> > > DonB
> > >
> > >
> > > "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
> > >news:al0g7l$646$1@news.codecharge.com...
> > > > Access wants a primary key to be defined or it won't allow a table
to
> be
> > > > updated. At least it used to - been awhile since I've used it. I
> > expect
> > > > that is still true, though. Check your table(s).
> > > >
> > > > Also, I like to pull "bad" queries out and execute them directly, to
> > > compare
> > > > the results. Sometimes I get more (detailed) info that way.
> > > >
> > > > DonB
> > > >
> > > >
> > > > "Carl" <herrecm@itis.net> wrote in message
> > > >news:al0f8t$4d1$1@news.codecharge.com...
> > > > > Nope. It's not set to read only. First thing I checked. That's
> what
> > > > > troubled me.
> > > > >
> > > > > Carl
> > > > >
> > > > > "Kelvin Chua" <NOkelvinSPAM@accpro.com.sg> wrote in message
> > > > >news:akuaj1$78d$1@news.codecharge.com...
> > > > > > You have to change the security permissions at your database to
> > enable
> > > > you
> > > > > > to add. Currently, you had only set it to Read-Only.
> > > > > >
> > > > > > Thanks.
> > > > > >
> > > > > > Kelvin Chua
> > > > > > SINGAPORE
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Shawn Mason
|
| Posted: 09/02/2002, 8:01 PM |
|
I like that one "Error --- Success". <g>
--
Kindest Regards,
Shawn Mason,CCD,MCP
I.S. Software Design Associates
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:al15s9$b5k$1@news.codecharge.com...
> Access is kind dumb about this particular situation. It refers to "view"
> even when there is none. I don't know why. I"m still pondering an error
I
> used to get in Windows 1.0 that said "Error -- Success". Since then, I
> don't take error messages too literally.
>
> don
>
> "Shawn Mason" <shawn@issda.com> wrote in message
>news:al14lj$99o$1@news.codecharge.com...
> > Actually, Carl, the error is saying that the query is a view and the
ODBC
> > driver being used to update Access doesn't support inserts or adds to a
> view
> > (heck, Sql Server has problems with that...but it has workarounds).
> > Basically, you shouldn't be using a view on an update form. But, since
I
> > don't know which ones you are referring to I'm not sure. Have you tried
> the
> > example using Sql Server? Plus, do a trace on the query being created
to
> > confirm I am correct in my "error reading". (In Sql Server use
> > Profiler...in Access..not sure).
> >
> > --
> > Kindest Regards,
> >
> > Shawn Mason,CCD,MCP
> > I.S. Software Design Associates
> >
> > "Carl" <herrecm@itis.net> wrote in message
> >news:aku6hc$je$1@news.codecharge.com...
> > > I tried the bookstore sample with both CCS & CC.
> > >
> > > When I try to add a credit card type on CCS I get:
> > > Source: Record card_types / Insert Operation
> > > Command Text: INSERT INTO [card_types]([name]) VALUES ('Master Card')
> > > Error description: [Microsoft][ODBC Microsoft Access Driver] Operation
> > must
> > > use an updateable query. (Microsoft OLE DB Provider for ODBC Drivers)
> > > INSERT INTO [card_types]([name]) VALUES ('Master Card')
> > >
> > >
> > >
> > > On CC it's a shorter error message but the bottom line is that while I
> can
> > > view all that pages, nothing that involves adding a record works. Is
> this
> > by
> > > design in the examples?
> > >
> > > I also created a new test bookstore using the Wizard in CCS. Had the
> same
> > > result.
> > >
> > > I'm trying to decide if I should buy either of these products but It's
> > > difficult to do so if an insert does not work.
> > >
> > > Does anyone know what I'm missing here???
> > >
> > > TIA.
> > > Carl
> > >
> > > --
> > > Web Hosting by Infotech Internet Services
> > > Itis.net, Inc. - http://itis.net
> > >
> > >
> >
> >
>
>
|
|
|
|
Carl
|
| Posted: 09/03/2002, 10:06 AM |
|
Don,
Actually, I'm not blaming the application nor CCS. I agree that it is
probably a setting somewhere. My point is that if I can't find it, the
result is the same. I posted the item in the NG hoping to get some
suggestions (as you have made) to try.
I'm *not* an ASP programmer, that is why I'm checking out CCS. I have been
using ColdFusion, but I like the fact that ASP runs on IIS without more
purchases. Those ColdFusion updates are co$tly.
Yes, I have set the web for anonymous access with the "IUSR_xxxx".
I'll try placing the DB in an IIS directory as you suggest, but normally,
the DB should be placed in a directory not accessible via the web site. But
that will be a start to see if I get it to work.
What puzzles me is that if I create a page using CCS myself (using another
database), then I can create, update and delete my database.
I quite disagree with you about XP in some respects. It has been able to
run everything I have thrown at it and it is quite stable. No blue screens
of death, no reboots because it dies, etc. There are other issues with it,
but not, as far as "does it work and can it run the apps"; more along the
lines of "how much can Billy boy look at on my PC?"
As for MySQL, I'm not crazy about it (I know, *blasphemy* in this NG). The
last time I looked at it was not simple to use and I was turned off by it.
Perhaps I should take another peak. But this should be irrelevant since the
ODBC driver should handle either. I don't agree at all that Access is a
pain. I have several access DB's on the web with no problems and no pains.
The ODBC driver I'm using is the MS Access *.mdb driver which I use for the
other DB's that do work. I tried ADO with the same results.
Well, I'll keep trying and try your suggestions.
Many Thanks
Carl
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:al15n6$ars$1@news.codecharge.com...
> Equally hard to believe that there is any CCS-specific issue. You can
blame
> CCS for the problem if you like, but that is simply absurd. I avoid
Access,
> and XP, for similar reasons. Access is a plague, XP is an epidemic.
>
> Back to the problem, though. Did you attempt to execute the same query IN
> Access? If it works, then I'd point my finger at MDAC. Since you said
> "XP", that presents a number of issues that need to be looked at, namely
the
> version of MDAC, the version of Access, the configuration of the
datasource,
> where the database file is, what permission you have given the IIS
anonymous
> account, whether you are even USING the anonymous ("IUSR_xxxx") account,
how
> you configured the website or virtual directory in IIS, and so on.
>
> For what it's worth, I just loaded the example for the first time ever.
It
> did not work. I moved the database from the examples folder to the IIS
> folder where I deployed the application (and altered the connection
> properties accordingly, then redeployed). Now it works just fine. (BTW: I
> also went back into IIS manager and altered the folder to have the "globe"
> icon, by clicking "Create Application". You don't get that by default and
> this affects the security context in which the application executes).
With
> so many configuration variables, it is 99.999% certain you've got
something
> configured differently than Yes had when they created the example.
>
> Carl, there is little if any magic in these application generators. They
> rarely do things that you or I have not done ourselves while coding an
> application from scratch. It baffles me why it is always the app
> generator's fault when things don't work correctly. In the case of CCS,
the
> source code it builds is readily available for inspection and is simple
and
> pretty easy to understand. The cod ethat inserts new card types is
> straight ADO code like you'd probably write yourself:
>
> 'Insert Method @5-D4A2B444
> Sub Insert(Cmd)
> CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeBuildInsert", Me)
> Set Cmd.Connection = Connection
> Cmd.CommandOperation = cmdExec
> Cmd.SQL = "INSERT INTO [card_types](" & _
> "[name]" & _
> ") VALUES (" & _
> Connection.ToSQL(name.SQLText, name.DataType) & _
> ")"
> CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeExecuteInsert",
Me)
> Cmd.Exec(Errors)
> CCSEventResult = CCRaiseEvent(CCSEvents, "AfterExecuteInsert", Me)
> End Sub
> 'End Insert Method
>
> CCS does a lot of things (like this) that otherwise require tons of
> hand-coding. CCS does have a number of warts - none that have proven to
be
> show stoppers and I've just finished my first major app with 40 or so
pages
> and lots of customization beyond what CCS produces directly. For
something
> branded "1.0" it does a damn good job. I've been at least 10x more
> productive than if I'd started with Visual Studio or .NET.
>
> CCS does a far better job when a good database engine is used for the
> foundation. I'd never deploy a production application with Access -
MySQL,
> SQL Server, Oracle,etc. - but Access is, always has been, and always will
be
> a royal pain-in-the-ass. It will work, lots of people use it, but your
> playing with dynamite and the fuse is lit.
>
> I bet the example would work just fine if you made one small change - put
> the database in the IIS folder (or at least one that is a virtual
directory
> know to your IIS.
>
> don
|
|
|
|
Carl
|
| Posted: 09/04/2002, 5:21 AM |
|
Don,
FTP'd this up to the server, specified "Admin" as the DB user and it all
works on the server. Still not working on XP (with apparently the same
settings), but as long as it's working on the server it's real good news
from my veiwpoint.
BTW, I love the FTP feature. Is there a way to have it create sub
directories that do not exist? I noticed that if the sub directory is not
created it stops uploading. Not a big deal just curious.
Thanks again for your help.
Carl
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:al15n6$ars$1@news.codecharge.com...
> Equally hard to believe that there is any CCS-specific issue. You can
blame
> CCS for the problem if you like, but that is simply absurd. I avoid
Access,
> and XP, for similar reasons. Access is a plague, XP is an epidemic.
>
> Back to the problem, though. Did you attempt to execute the same query IN
> Access? If it works, then I'd point my finger at MDAC. Since you said
> "XP", that presents a number of issues that need to be looked at, namely
the
> version of MDAC, the version of Access, the configuration of the
datasource,
> where the database file is, what permission you have given the IIS
anonymous
> account, whether you are even USING the anonymous ("IUSR_xxxx") account,
how
> you configured the website or virtual directory in IIS, and so on.
>
> For what it's worth, I just loaded the example for the first time ever.
It
> did not work. I moved the database from the examples folder to the IIS
> folder where I deployed the application (and altered the connection
> properties accordingly, then redeployed). Now it works just fine. (BTW: I
> also went back into IIS manager and altered the folder to have the "globe"
> icon, by clicking "Create Application". You don't get that by default and
> this affects the security context in which the application executes).
With
> so many configuration variables, it is 99.999% certain you've got
something
> configured differently than Yes had when they created the example.
>
> Carl, there is little if any magic in these application generators. They
> rarely do things that you or I have not done ourselves while coding an
> application from scratch. It baffles me why it is always the app
> generator's fault when things don't work correctly. In the case of CCS,
the
> source code it builds is readily available for inspection and is simple
and
> pretty easy to understand. The cod ethat inserts new card types is
> straight ADO code like you'd probably write yourself:
>
> 'Insert Method @5-D4A2B444
> Sub Insert(Cmd)
> CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeBuildInsert", Me)
> Set Cmd.Connection = Connection
> Cmd.CommandOperation = cmdExec
> Cmd.SQL = "INSERT INTO [card_types](" & _
> "[name]" & _
> ") VALUES (" & _
> Connection.ToSQL(name.SQLText, name.DataType) & _
> ")"
> CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeExecuteInsert",
Me)
> Cmd.Exec(Errors)
> CCSEventResult = CCRaiseEvent(CCSEvents, "AfterExecuteInsert", Me)
> End Sub
> 'End Insert Method
>
> CCS does a lot of things (like this) that otherwise require tons of
> hand-coding. CCS does have a number of warts - none that have proven to
be
> show stoppers and I've just finished my first major app with 40 or so
pages
> and lots of customization beyond what CCS produces directly. For
something
> branded "1.0" it does a damn good job. I've been at least 10x more
> productive than if I'd started with Visual Studio or .NET.
>
> CCS does a far better job when a good database engine is used for the
> foundation. I'd never deploy a production application with Access -
MySQL,
> SQL Server, Oracle,etc. - but Access is, always has been, and always will
be
> a royal pain-in-the-ass. It will work, lots of people use it, but your
> playing with dynamite and the fuse is lit.
>
> I bet the example would work just fine if you made one small change - put
> the database in the IIS folder (or at least one that is a virtual
directory
> know to your IIS.
>
> don
|
|
|
|
DonB
|
| Posted: 09/04/2002, 3:56 PM |
|
Well you got me there. I don't use the FTP feature (at least so far).
Still the best guess is the version of MDAC and/or the database. To
complicate things further there's "Access" and "MSDE" (which you no doubt
know). There's such a swirling vortex of different versions of things on
XP, that I've been happy to stick with Win2K for now (at least until the
dust settles or some "must have" XP-only feature comes around).
But I do highly recommend a database server be it mySQL or SQL Server (since
you are FTPing to deploy then I suspect you are using an ISP and most only
support mySQL - perhaps yours isn't even providing that).
At least you are up and running. That's the main thing.
don
"Carl" <herrecm@itis.net> wrote in message
news:al4tsq$1i4$1@news.codecharge.com...
> Don,
>
> FTP'd this up to the server, specified "Admin" as the DB user and it all
> works on the server. Still not working on XP (with apparently the same
> settings), but as long as it's working on the server it's real good news
> from my veiwpoint.
>
> BTW, I love the FTP feature. Is there a way to have it create sub
> directories that do not exist? I noticed that if the sub directory is not
> created it stops uploading. Not a big deal just curious.
>
> Thanks again for your help.
> Carl
>
> "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
>news:al15n6$ars$1@news.codecharge.com...
> > Equally hard to believe that there is any CCS-specific issue. You can
> blame
> > CCS for the problem if you like, but that is simply absurd. I avoid
> Access,
> > and XP, for similar reasons. Access is a plague, XP is an epidemic.
> >
> > Back to the problem, though. Did you attempt to execute the same query
IN
> > Access? If it works, then I'd point my finger at MDAC. Since you said
> > "XP", that presents a number of issues that need to be looked at, namely
> the
> > version of MDAC, the version of Access, the configuration of the
> datasource,
> > where the database file is, what permission you have given the IIS
> anonymous
> > account, whether you are even USING the anonymous ("IUSR_xxxx") account,
> how
> > you configured the website or virtual directory in IIS, and so on.
> >
> > For what it's worth, I just loaded the example for the first time ever.
> It
> > did not work. I moved the database from the examples folder to the IIS
> > folder where I deployed the application (and altered the connection
> > properties accordingly, then redeployed). Now it works just fine. (BTW:
I
> > also went back into IIS manager and altered the folder to have the
"globe"
> > icon, by clicking "Create Application". You don't get that by default
and
> > this affects the security context in which the application executes).
> With
> > so many configuration variables, it is 99.999% certain you've got
> something
> > configured differently than Yes had when they created the example.
> >
> > Carl, there is little if any magic in these application generators.
They
> > rarely do things that you or I have not done ourselves while coding an
> > application from scratch. It baffles me why it is always the app
> > generator's fault when things don't work correctly. In the case of CCS,
> the
> > source code it builds is readily available for inspection and is simple
> and
> > pretty easy to understand. The cod ethat inserts new card types is
> > straight ADO code like you'd probably write yourself:
> >
> > 'Insert Method @5-D4A2B444
> > Sub Insert(Cmd)
> > CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeBuildInsert",
Me)
> > Set Cmd.Connection = Connection
> > Cmd.CommandOperation = cmdExec
> > Cmd.SQL = "INSERT INTO [card_types](" & _
> > "[name]" & _
> > ") VALUES (" & _
> > Connection.ToSQL(name.SQLText, name.DataType) & _
> > ")"
> > CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeExecuteInsert",
> Me)
> > Cmd.Exec(Errors)
> > CCSEventResult = CCRaiseEvent(CCSEvents, "AfterExecuteInsert",
Me)
> > End Sub
> > 'End Insert Method
> >
> > CCS does a lot of things (like this) that otherwise require tons of
> > hand-coding. CCS does have a number of warts - none that have proven
to
> be
> > show stoppers and I've just finished my first major app with 40 or so
> pages
> > and lots of customization beyond what CCS produces directly. For
> something
> > branded "1.0" it does a damn good job. I've been at least 10x more
> > productive than if I'd started with Visual Studio or .NET.
> >
> > CCS does a far better job when a good database engine is used for the
> > foundation. I'd never deploy a production application with Access -
> MySQL,
> > SQL Server, Oracle,etc. - but Access is, always has been, and always
will
> be
> > a royal pain-in-the-ass. It will work, lots of people use it, but your
> > playing with dynamite and the fuse is lit.
> >
> > I bet the example would work just fine if you made one small change -
put
> > the database in the IIS folder (or at least one that is a virtual
> directory
> > know to your IIS.
> >
> > don
>
>
>
|
|
|
|
Robert Davis
|
| Posted: 09/12/2002, 4:25 PM |
|
I don't use XP Pro, but does IUSR_<yourmachinename> have full permissions to
the .mdb on your development machine???
Regards,
radbase@cox-internet.com
__________________________________________________________________________
Let me do you a dotFavor! >>> http://radbase.ehostingbiz.com/webcenter
The VERY BEST dotNet hosting available anywhere!!!
If you can beat the features/price/performance and support, I'd sure like to
KNOW ABOUT IT!!!
__________________________________________________________________________
.
.
.
"Carl" <herrecm@itis.net> wrote in message
news:aku6hc$je$1@news.codecharge.com...
> I tried the bookstore sample with both CCS & CC.
>
> When I try to add a credit card type on CCS I get:
> Source: Record card_types / Insert Operation
> Command Text: INSERT INTO [card_types]([name]) VALUES ('Master Card')
> Error description: [Microsoft][ODBC Microsoft Access Driver] Operation
must
> use an updateable query. (Microsoft OLE DB Provider for ODBC Drivers)
> INSERT INTO [card_types]([name]) VALUES ('Master Card')
>
>
>
> On CC it's a shorter error message but the bottom line is that while I can
> view all that pages, nothing that involves adding a record works. Is this
by
> design in the examples?
>
> I also created a new test bookstore using the Wizard in CCS. Had the same
> result.
>
> I'm trying to decide if I should buy either of these products but It's
> difficult to do so if an insert does not work.
>
> Does anyone know what I'm missing here???
>
> TIA.
> Carl
>
> --
> Web Hosting by Infotech Internet Services
> Itis.net, Inc. - http://itis.net
>
>
|
|
|
|
|
