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' DSN="Driver={SQL Server};Server=local;Database=DataSets;UID=nobody;PWD=here" or simply DataSets nobody here TIA Mike B
--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/
participants (2)
-
Mike Bunyan -
Paul Browning