Received: from brianp.demon.co.uk (IDENT:root@brianp.demon.co.uk [158.152.38.192]) by hub.org (8.10.1/8.10.1) with ESMTP id e6KDt1h04602 for ; Thu, 20 Jul 2000 09:55:01 -0400 (EDT) Received: from localhost (localhost [[UNIX: localhost]]) by brianp.demon.co.uk (8.9.3/8.8.7) id OAA01187 for pgsql-interfaces@postgresql.org; Thu, 20 Jul 2000 14:54:57 +0100 From: Brian Piatkus To: pgsql-interfaces@postgresql.org Subject: Can I change ODBC Parameters on thr fly ? Date: Thu, 20 Jul 2000 14:48:27 +0100 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00072014545700.00935@brianp> Content-Transfer-Encoding: 8bit X-Archive-Number: 200007/166 Hi I am using a VB client which on ODBC v 6.5.... If I check the 'Use Declare/Fetch' box, I find that a simple query gets broken down by the driver to multiple queries, each with a single row cursor. I can live with this bu not using declare fetch. However I would also like to be able to use access on the same db. 1) can I change the characteristics of the driver programmatically for this session only ? 2) Can I set up a different DSN for this driver (I've not been able to set one up differently so far)