[Zope] Re: How to connect ZODBC with login instead of user

Calvo, Luis Luis.Calvo@epson-electronics.de
Tue, 11 Mar 2003 15:30:01 +0100


It is a progress DB. But if my ODBC conexion works with access and VBasic it
must be ok, isn't it? What should I put in ZOpe in the connection string?

-----Original Message-----
From: jwsacksteder@ramprecision.com
[mailto:jwsacksteder@ramprecision.com]
Sent: 11 March 2003 05:12
To: Calvo, Luis; zope@zope.org
Subject: RE: [Zope] Re: How to connect ZODBC with login instead of user


OK- I'll guess your DSN isn't formatted right. Remember that the DSN string
gets passed to the server as-is and is processed there. Depending on what
sort of database you are connecting to I have seen DSN's that look like
this:

	DSN=foo;USR=bar;PWD=baz
or
	foo/bar/baz
or 
	foo;bar;baz
etc.

What database are you using?



-----Original Message-----
From: Calvo, Luis [mailto:Luis.Calvo@epson-electronics.de]
Sent: Tuesday, March 11, 2003 7:24 AM
To: 'Maik Jablonski'; zope@zope.org
Subject: RE: [Zope] Re: How to connect ZODBC with login instead of user


I have a DB in a Unix server and my Zope server in a W2000. I try to connect
them. I have created  the ODBC connection in my W2000 server with my DB and
it works with access and so on. But I can't use it in the Zope server. I
install in Zope the ZODBC but when I create a ZODBC connection it does not
work.

-----Original Message-----
From: Maik Jablonski [mailto:maik.jablonski@uni-bielefeld.de]
Sent: 11 March 2003 04:22
To: zope@zope.org
Subject: [Zope] Re: How to connect ZODBC with login instead of user


I don't understand what you want to do...

Calvo, Luis wrote:
> I'm new in the list. I am trying to connect Zope with an ODBC connection
> with my W2000.

Do you want to connect to the ZODB (Zope Object Database) via ODBC? I 
don't think that a ZODB-ODBC-Driver exists... Or do you want to connect 
to an external database via ODBC from Zope?

> The windows Connection works, but not in Zope. We don't use
> users to connect, only logins. Is that the problem? How can I solve it?

What does that mean? What's the difference between users and logins in 
your case?

-mj



_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )

_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )