Topics Search

Odbc - Call Failed - Sql7967 - Prepare Of Statement Completed. (#-901)

Odbc - Call Failed - Sql7967 - Prepare Of Statement Completed. (#-901)
Views: 60
I have a query which sometimes works, but usually not on the first try. The message that comes up is:

'ODBC--call failed. [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7967 - PREPARE of statement completed. (#-901)'

It's run as part of a macro and when run, it usually errors out on this query. However, if I try running it from the design view, it runs fine. In addition, this query runs without any issues when run from other machines.
Sponsored Links:

More topics

 

ODBC--call failed

Preview
Ive been trying to do a basic pass thought query. But have been receiving these two error messages

1.ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'my tabel name' (#102)
Error message

2. ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'my tabel name' (#208)

Basic Query
SELECT dbo_VC_Admin.app_num
FROM dbo_VC_Admin;
When trying to open the server table
a. ODBC--call failed. [Microsoft][ODBC SQL Server Driver]Timeout expired (#0)

I dont have access to change my regedit:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engi nes\ODBC
 

ODBC--call failed

Preview
Ive been trying to do a basic pass thought query. But have been receiving these two error messages

1.ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'my tabel name' (#102)
Error message

2. ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'my tabel name' (#208)

Basic Query
SELECT dbo_VC_Admin.app_num
FROM dbo_VC_Admin;

When trying to open the server table
a. ODBC--call failed. [Microsoft][ODBC SQL Server Driver]Timeout expired (#0)

I dont have access to change my regedit:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engi nes\ODBC
 

ODBC - Call failed

Preview
I am getting a ODBC -- Call failed error
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect Syntax near 'dbo' (#102)
when running reports.

This is an access 07 application created on a windows 7 64 bit PC. I have 2 linked tables to a Microsft Dynamics views I created, I am linking them through ODBC connection. Everything works fine on my pc, but when another user tried to use it she gets the above error. Shes got a Winxp 32bit PC
 

Error (3146) ODBC --call failed

Preview
Error (3146) ODBC --call failed.

[Oracle][OCBC][Ora]ORA-00600: internal error code, arguments.
 

bypass odbc connection

Preview
I have a MS Access 2007 database that contains a union query that merges 5 different odbc connections. If one connection is down I receive an 'ODBC--call failed' error and the query is unusable.

Is there a way to have the database verify connection and if it cannot connect to one or more odbc, to simply by-pass the odbc(s) and use the others?
 

ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object

Preview
Can someone help me find out why I'm getting this error message?

ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tabel name' (#208)
 

ODBC call failed

Preview
Until recently, I would pull all of my tables off of the AS/400 (IBM System i) through the ODBC external data interface in Access. Now when I try to pull anything over, I get the ODBC call failed error. It was suggested to me that the error was caused by a change to our SQL server. Unfortunately our IT people have no idea how to fix the problem and I am not set up to change anything in SQL; and even if I was, I wouldn't know where to begin.

That being said, I am still able to import the data into Excel. We have an Add-In set up to Transfer data in and out of System i. What I need is the VBA code to automate the transfer process in Excel. Once I can get that piece figured out I can pull it into Access
 

ODBC Call Failed (#208)

Preview
I have created a pass-through query for a very simple query and I'm getting the following error.

ODBC-Call Failed
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo_productMonthlyDetails'. (#208)

I'm not sure as to why. My query is .

SELECT dbo_productMonthlyDetails.MbrNo, dbo_productMonthlyDetails.ProdCode, dbo_productMonthlyDetails.ProdBenefit, dbo_productMonthlyDetails.ProdSub, dbo_productMonthlyDetails.AverageBalance, dbo_productMonthlyDetails.DebitAverageBalance, dbo_productMonthlyDetails.CreditAverageBalance, dbo_productMonthlyDetails.RetailBranch, dbo_productMonthlyDetails.CBCBranch, dbo_productMonthlyDetails.MonthendDate INTO mt_step1_product_details_data
FROM dbo_productMonthlyDetails INNER JOIN Mth ON dbo_productMonthlyDetails.MonthendDate = Mth.Mth
 

ODBC -- Call Failed error

Preview
I have linked a table into Accesss 2003 and the connection works fine. I can open the table and all data is returned. however when I query it in SQL I get the "ODBC--call failed." error pop up. everything in the SQL is refereced fine and if I change the table name to a local one it querys fine, it just wont query the linked one even though all the data is there and working fine
 

ODBC-Connection failed to sublist

Preview
I have an Access database that I upsized with the wizard wishing to continue using Access for the Front End. I want to be able to connect to the SQL database without having each computer setup for the DSN. I added this to the autoexec macro/converted to a module.

[code]

The error I get is ODBC-Connection failed.

For my testing I did create a DSN on this computer with this user that worked fine. Then when I removed the DSN connection and ran the databaseI got this message, ODBC-Connection failed, again.