ODBC requirig login for each record read

ODBC requirig login for each record read

Post by John David Adams » Sat, 12 Jul 2003 00:16:18



A user has an Access DB running on a XP box that is experiencing the
following problem when using ODBC drive 3.34 or 3.82 to connect to IDS
7.31 UC4:  The user get the login prompt ever records or ever couple
of records it retrieves from the Informix DB.     With over a 1000
records per query the user is not a happy camper.

It seems to work with ODBC drive 3.30 & 3.33 when they where loaded,
but when we upgraded them to 3.34 the problem started.  We uninstalled
and reinstalled the drivers.  Downloaded the latest sdk from IBM and
still get prompted for login ever record retrieved.

Anyone have any ideas what to do or where to look, besides going back
to 3.33?

John David Adamski
Information Systems Specialist
Graceland University

641-784-5267

 
 
 

ODBC requirig login for each record read

Post by William Field » Sat, 12 Jul 2003 00:43:34


I haven't used Access in about 6 years, but in Visual FoxPro, there is an
ODBC connection property that drops inactive connections after a specified
period of time (but the default is to keep the connection open
indefinitely).

--
William Fields
MCSD - Microsoft Visual FoxPro
MCP - Win2k Pro
US Bankruptcy Court
Phoenix, AZ

The secret to creativity is knowing how to hide your sources.

        - Albert Einstein



> A user has an Access DB running on a XP box that is experiencing the
> following problem when using ODBC drive 3.34 or 3.82 to connect to IDS
> 7.31 UC4:  The user get the login prompt ever records or ever couple
> of records it retrieves from the Informix DB.     With over a 1000
> records per query the user is not a happy camper.

> It seems to work with ODBC drive 3.30 & 3.33 when they where loaded,
> but when we upgraded them to 3.34 the problem started.  We uninstalled
> and reinstalled the drivers.  Downloaded the latest sdk from IBM and
> still get prompted for login ever record retrieved.

> Anyone have any ideas what to do or where to look, besides going back
> to 3.33?

> John David Adamski
> Information Systems Specialist
> Graceland University

> 641-784-5267


 
 
 

1. Unable to read in login record.

Has anyone seen the following error in the errorlog:
server: Unable to read in login record.

This was an isolated error, i.e no other errors in the log at the same
time.

Does anyone know what causes it, and is it anything to be worried about?

BTW :
 SQL Server/4.9.2/EBF 2417/Sun4/OS 4.1.2/1/OPT/Tue Jan 11 07:06:49 PST 1994

---

 Goldman Sachs International Limited   | Phone : +44 71 774 5420
 Peterborough Court, 133 Fleet Street, |
 London. EC4B 2AA                      | ... and the Reds go marching on, on, on ...

2. ORA-12500 on AIX 4, Oracle 7.1.6.2.0- Please HELP

3. ODBC login uses default database for login

4. memory problem on 7.31 UC4

5. Unattended Login ODBC-Login from VB4.0

6. Dirty reads

7. Program freezes after reading 1284 records via ADO and ODBC

8. Status Bar Update

9. how to read the records in Access database through ODBC

10. Record Locking with reading records

11. Anyone recognize this ODBC error {.jpeg attached} ODBC login failed (0/1)

12. unable to read login packet!

13. Error: 17832 Unable to read login packet(s)