ODBC connection failed error

ODBC connection failed error

Post by bXl6dGlxdW » Tue, 20 Mar 2007 11:11:00

I have this error message showing up on several of the queries as well as
forms and reports. It is strange that I can run some of the Queries as well
as Reports but then there are others that I can't. I am not the person that
designed or set up the swtichboard and he is no longer with the company. I
am getting desperate to correct the problem as this makes my job harder!

1. ODBC connection failed error 1396

2. ODBC Connection Failed Error 3151 - Using DAO

We have a Windows application written in Visual Studio 2003/MFC/C++ which
uses the MFC Dao Database classes. The application works fine with a
Microsoft Access database. We are now converting the program so that it can
use ODBC, we have done this by creating connections from a local MDB file to
external tables using CDaoQueryDef and an ODBC connection string. This was
suggested as the best way to convert without making many code changes.

Besides writing the code that connects the tables, we had to add
dbSeeChanges as a parameter to most of the CDaoRecordset Open calls. We now
have the application hooked up to an SQL Server 2000 database that was
upsized from the equivalent Access 2000 database file.

When we run the program, the initialization goes well, the program reads
alot of data and shows it to the user. Everything looks good at this point,
no errors at all. But then, when we try to do anything with the program
after that, we keep getting a:

3151 ODBC--Connection to 'SQL Server(local' failed

Error. This error occurs in functions that worked fine on program startup.
The error occurs on any database activity whatsoever.

Can anybody give me an idea about what could be the problem? Could the
program be running out of connections? Are CDaoRecordset objects not being
closed properly? The program keeps several DAO recordsets open during the
duration of the program. The reason is that the main window uses a cached
list view and the program constantly needs provide data in response to
LVN_GETDISPINFO messages. Any suggestions as to what the problem could be
are greatly appreciated.

Paul Dembowski

Liberty Street Software

3. connection failed errors trying to set up a ODBC connection

4. Advanced Server 7 ODBC error - [DataDirect][ODBC SequeLink driver][SequeLink Client]TCP/IP error, connection refused

5. Error 18456 - ODBC connection failed for domain user account

6. DCA Error Failed to get connection string from ODBC.

7. ODBC error 3151 (Connection failed, Access <-> SQL Server)

8. Remote ODBC connections fail to SQL 2005 database (Error: 18456, Severity: 14, State: 8.)

9. Error 3151 ODBC- connection to "sql serverpgsrv2" failed

10. ODBC Help Needed! Connection Failed - Error 53

11. "ODBC - connection to 'SQL Server A.B.C.D' failed" error on many machines

12. how do i fix connection when my ODBC connection has failed in the.

13. Error #: 3151 < > ODBC--connection Error

14. Detect failed ODBC connection when vpn is not up?

15. ODBC connection fail