Results for the ODBC â call failed. (Error 3146) -ODBC – call failed. (Error 3146) -Hi Guys, I have an application and in particular an append query that inserts rows into a linked table. I keep on getting this error, (although the code works fine in enterprise manager, and code-imports ok). I did not cancel the query but it seems to think it has. The insert/append Runtime Error 3146; - I got this runtime error trying to execute an OpenRecordset statement using SQL. The error message is: "Runtime Error 3146; ODBC-Call Failed" I've included the SQL script. Hope someone can help! Thanks RUNTIME ERROR '3146'..ODBC-Call Failed - Hi.. Im using SQL server as my backend and MS Access as F.E.. Im using to update around 10 to 20 records one by one by upto 2 to 3 records it was updating, later for 4th record it was saying "RUNTIME ERROR '3146'..ODBC-Call Failed"(at "rst.update" it was showi anyone ever use Kofax's.. - Ascent Capture? we're using it now and in the process of releasing scripts error 3146 - ODBC call failed appears. anybody know what that means? just throwing a wild punch here.. What the h*ll is "Error 3146: ODBC Call Failed" - i'm connected to a valid system DSN, i have the correct username and password, and yet i still get that error. halp, anybody. i beg of you good samaritans. ASP, IIS4 and VB6, Project works on IIS in VB but not in DLL - Somebody please help. I'm about to hit the roof, I have an VB project that is accessed from an asp page on iis4 on nt4 sp6. In dll form an odbc error occurs, I have tried using DAO, ADO and about to try RDO. All of these form in VB running on the iis box, but the moment that the sql server 2000 run-time error - Hello, I need help with error mesage in Access 2000 and SQL Server 2000. Microsoft Visual Basic Run-time error 3146: ODBC - call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. (#8152) [Microsoft][ODBC SQL Server Drive][S ODBC runtime err 3146 - Set Names = CreateWorkspace("ODBCWorkspace", "", "", dbUseODBC) Set ODBC = Names.OpenDatabase("DG", dbDriverNoPrompt, , "ODBC;DSN=DG") Set NamesRecords = ODBC.OpenRecordset("Select * From ContactTable", dbOpenDynaset, Open excel file with Dao 3.51 ,runtime error - Hi all When i try to open excel file with The DSN ,with Dao i have run time error 3146 ODBC--call failed and everything ok the file in my machine. So any help? Efrat cannot execute in ODBCDIRECT - I am using VB 6.0 and SQL Server 7.0 I am connected using ODBC Direct . I want to execute a delete query on my table db.execute "DELETE * FROM MASTER" But i receive the following message Run Time error 3146. ODBC call failed. But I am connected to the database VBA and SQL - I have a VBA application interacting with SQL tables. I am trying to do a simple lookup: strNumLookup = DLookup("[tblPosting_RefNumber]", strTable, "[tblPosting_RefNumber] = '" & strNewNo & "'") and it keeps screaming with this error: ODB ODBC not connecting!!! - Hi, Since having to re-install Oracle I get the following error when trying to link tables in Access: - ODBC --call failed [Microsoft][ODBC drviver for Oracle][Oracle] (#0) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manag Recordset update method failed - I'm using VB5 SP3, connecting to database via ODBC. Code: Set WS = DBEngine.CreateWorkspace("MainWS", "admin", vbNullString, dbUseODBC) Set CN = WS.OpenConnection("", dbDriverNoPrompt, False, strConnect) Set RS = CN.OpenRecordset("select * f ODBC Call Failed - Hello there! I need to add a new field to a table I have! I'm using DAO so I thought that using the "Execute" methond of the connection object should do it! But all I get is an "ODBC Call Failed" error. My query that works PERFECT in access 2000 query sql view. ODBC Call Failed.. - I am have a VB6 program connecting to an access database via ADO. In the acces table I have a couple of linked tables to a SQL Server. These tables are linked to VIA a data source with the password saved in the linking. Anyway my problem is when I try run the program I am getting an Problem connecting to access using NT - I am using Dao to connect to access. The program works on Win9x (2000, but thats the machine I have Vb installed on) It won't work on NT machines. When I try to connect, I get a window called "Select Data Source" I click on MSAccess, and then I get a run-time error ' ODBC CONNECTION TO " " FAILED . ERROR 3151 - Hi everyone, My question is related to ODBC. When my client connects to small business server having SQL7 the form immediately after showing data in the trudbgrid shows "error 3151 connection to odbc failed." I have reinstalled sql7 completly but still the same error I am getting an error while connecting to SQL Server Database. Pls Help. - I am getting an error while connecting to SQL Server Database. I have configured everything PWS and ODBC. I am having Win98 and have installed PWS and I also configured ODBC for SQL Server. And also the connectivity is succeeded. And I am trying to update it And as soon I click on ODBC/SQL Server 2000: Connection failed - In all the sudden, my machine could not connect to the SQLServer 2000 while all the others are still be able to connect. I've used ODBC to set up a DSN, and here is the error message: Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver] I am getting an error while connecting ASP page to SQL Server. Pls help - I am getting an error while connecting to ASP page SQL Server Database. I have configured everything PWS and ODBC. I am having Win98 and have installed PWS and I also configured ODBC for SQL Server. And also the connectivity is succeeded. And I am trying to update it And as soon I |