[Zope] ZODBC configuration problems

2000-11-28 Thread paul_s_johnson

Alas, I am but a Zope newbie and need help getting my database connections
to work.  I have previously configured the ODBC Data Source Administrator
to link Access mdbs with the PERL DBI module and it has worked with no
problems.  I have installed the ZODBC product and in the Zope database
connection window all the names of the ODBC data sources that have been
configured show up in the listbox. Upon attempting to add any of the data
sources I receive the error "Invalid connection string" except for one of
the databases that Zope does accept.  Upon testing this database connection
with a test query I get the following error:

Error Type: sql.error
Error Value: ('42000', -1907, "[Microsoft][ODBC Microsoft Access 97 Driver]
Record(s) can't be read; no read permission on 'ProjectSheets'.")

The permissions on this database are such that any anonymous user can
access its data so the error message appears to be inaccurate.  I double
checked the db permissions to make sure this is the case.

I am running Zope on NT 4.0 and using Access 97.  The logged-in user on the
webserver is not a member of any Access-related workgroups so this
eliminates most security-related access issues (I think) and none of the
databases are passworded.

There's some flakiness going on here.  Any recommendations for isolating
and resolving these problems?

Thanks,

P. Johnson


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] ZODBC configuration problems

2000-11-28 Thread Capesius, Alan

Are you running 2.2?  Look at: http://www.egroups.com/message/zope/36392

Is the Access DB on the same server as Zope? If not, you may be running into
problems accessing the network. The Zope service may need to be switched to
run under a user account that has access to the network resource. The NT
System account does not have network authority.
http://msdn.microsoft.com/library/periodic/period98/ewn9824.htm
http://support.microsoft.com/support/kb/articles/Q235/5/36.ASP

Is the ODBC DSN a system DSN? Don't use User DSN.

Alan Capesius, MCSE+21
Sysmex Corp of America


Message: 17
   Date: Tue, 28 Nov 2000 09:59:32 -0600
   From: [EMAIL PROTECTED]
Subject: ZODBC configuration problems

The permissions on this database are such that any anonymous user can
access its data so the error message appears to be 
inaccurate.  I double
checked the db permissions to make sure this is the case.

I am running Zope on NT 4.0 and using Access 97.  The 
logged-in user on the
webserver is not a member of any Access-related workgroups so this
eliminates most security-related access issues (I think) and 
none of the
databases are passworded.

There's some flakiness going on here.  Any recommendations 
for isolating
and resolving these problems?

Thanks,

P. Johnson


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )



_
___
_
___

Message: 18
   Date: Tue, 28 Nov 2000 11:41:50 -0500
   From: "Chris McDonough" [EMAIL PROTECTED]
Subject: Re: Factoids for supporting zope

 Our client thought that the recent VC money was about 
1/2 what would
 be needed to make it fly. My argument is that money 
is leveraged by
 the active Zope community so a crux in my logic is 
how strong this
 community is.

1/2 of what would be needed to make it fly with Zope?  
Or 1/2 of what
would
be needed with any app server?


 Since they come from a non Zope context it would be from 
the general
 position and the onus is on me to bring in the Zope context in the
 construction of my argument.

Ah.  Well, my opinion is that it'd be fairly dangerous to 
make the assertion
that (as great as they both are) Zope and the Zope community 
can "make up
for" the other half of the capital they need to develop the 
software they
want.  So what's the decision they're trying to make?  
Whether to develop at
all?




___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )



_
___
_
___

Message: 19
   Date: Tue, 28 Nov 2000 17:28:11 +0100
   From: "Max M" [EMAIL PROTECTED]
Subject: RE: How do i write or?

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Stoonsdesign

The thing is that I have this page (made by somebody else) 
wich is supposed
to
look up some words in a database by writing:

Hi Stoons

It really is impossible to answer that question without 
knowing how that
page works.

But maybe letter=* will work.

Regards Max M

Max M. W. Rasmussen,Denmark.   New Media Director
private: [EMAIL PROTECTED] work: [EMAIL PROTECTED]
-
Specialization is for insects.  -  Robert A. Heinlein



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )



_
___
_
___

Message: 20
   Date: Tue, 28 Nov 2000 12:34:59 -0400
   From: "Dany Rioux" [EMAIL PROTECTED]
Subject: RE: Possible disaster upgrading to 2.2.4

I was thinking about downloading the ZDiscussions product and install
it but from what I can see, it looks like it needs some fixing.

I intend to upgrade to zope 2.2.4 when it was proven that it 
is stable
but I don't want to run into more troubles that I can chew on.

I will need a Discussion board when the site go live so should I
upgrade Zope and wait for another Discussion Product to come up or
install ZDiscussion and hold on the Zope upgrade?

TIA

Dany

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
 Behalf Of Bill
 Welch
 Sent: 

Re: [Zope] ZODBC configuration problems

2000-11-28 Thread Pavel V. Piankov

sources I receive the error "Invalid connection string" except for one of

If you are using the last ZODBCDA there should be no problems granted that
you have provided the proper connection string. check the connection object,
there sould be
written down smth. like 'datasource login pass' or  'datasource
pass login'
I don`t remember exactly.


regards.
--
pashah



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )