[Zope] ZDataQueryKit dsn connection string

[Paul Browning]

--On 03 January 2003 22:47 +0000 Mike Bunyan <mrbun@bigfoot.com> wrote:

> Hi,
> I am having trouble getting ZDataQueryKit to work properly and the
> problem seems to be my use of the dsn connection string in the Z
> Visual ODBC Client.
>
> I have tried many variations of the following without success, perhaps
> some kind person can put me right. I have set up a ODBC dsn connection
> in Win32 Control Panel, and this works with the more common 'Z ODBC
> Database Connection'

My working Z Visual ODBC Client properties screen (on
a Linux box) has the value "dsn" set to

dsn=socket;UID=;PWD=;

where "socket" is the ODBC source name on the remote NT box
(with null username and password) which is running ODBC Socket
Server.

HTH

Paul

>
> DSN="Driver={SQL
> Server};Server=local;Database=DataSets;UID=nobody;PWD=here"
> or simply
> DataSets nobody here
>
> TIA
> Mike B
>
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> 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 )
>



--
 The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK
   E-mail: paul.browning@bristol.ac.uk  URL: http://www.bris.ac.uk/