o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

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; -
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

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,

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

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

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

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.

ODBC Runtime Error '3146' -
Here is my delema. First I do not get this error on my computer. Second, when my boss runs this application and the VB program tries to access the MSAccess Report she gets: "Runtime Error '3146' Incorrect syntax near #170.." What do you think I should do about this

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..

Runtime Error '713' - What is this -
Hello, I'm getting runtime error 713 in my app when I install it to Win95. Seems to work ok on WinNT. The MSDN help that i have doesnt mention what runtime error 713 is. Does anybody know what it means or anything else about it? Thanks Mark

Runtime Error 126 HELP PLEASE -
My Form is Ok in Debug Mode but after compiling the Programm shutdown with Runtime Error 126! What is this?? Or where can i find a list of all VB Runtime Error codes! Help Please.. cya

SQL 7 database access -
i have gained access to my database using the below code but what i want to do is load my query result of all the interviewers into my combobox named cmbInterviewer now this is where i get stuck thankyou for all yor replys Code: Dim dyna As Recordset Dim theerror A

What is trappable error What is untrapped runtime error -
Quote: A trappable error is a runtime error that has not already been trapped. An untrapped runtime error is any runtime error generated by a statement which does not specify an error variable (this includes statements which can have an optional error variable pa

RUntime Error message box -
I obviously have turned on something I did not mean to...recently, I have been getting a runtime error message box appearing when loading web pages, even when my vb editor is not open. How do I prevent this from happening? The most common msg is: Runtime Error has occured.

Please help...... Sql Server Error -
My Database is SQL Server and using ODBC to connect VB6. When I tried to set the recordset from the database. It shows the following errors: Run-Time Error 3146. Could not allocate space for object '(SYSTEM table id: -269040389)' in database 'TEMPDB' becuase the 'DEFAULT' filegroup

help - please!!!! runtime error 713 -
i'm getting a ----- runtime error 713 - class not registered - looking of obj with clsid: {00000100-0000-0010-8000-001100-6D2EA4} ----- when i try installing my app on a virgin machine (running windows 98). I've read up on this and it says that I am missing msderun.dll. if this is th

Runtime Error '9' and '429' -
hi, just wanna ask why my .exe runs on some computer have an error? sometimes its Runtime Error '9' or Runtime Error '429' anybody can solve my problem? regards, monxxx

HELP RUNTIME ERROR 424 -
I get this runtime error after I have compiled my program into an EXE. I burnt the programs EXE file to a CD. Ran it on a seperate PC that didn't have anything about my program on it. I ran the setup, and installed it, and then went to the location it placed the EXE. I opened the EXE f

runtime error 40006 -
Hi, I wrote a app that sends email using a smtp server. I have been using the app for a couple of days with no problem. Now for some reason I will get this runtime error. Runtime Error 40006 Wrong protocol or connection state for the requested transaction or request. Any one

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

runtime error, please help -
Hello, I ran into a runtime error 430 when I tried to to run an updated version of my program on a windows95 machine. I have not done any big changes since the last version which runs fine, but when I try to run this new version on it, I get a runtime error of 430. It says it doesn't

web browser runtime error -
i have made a form with a webbrowser control on it and it randomly comes up with: runtime error '-9(fffffff7)' when this happens in the vb6 environment, it should highlight the code for me that produces the error but it doesn't i don't knowwhere this error is coming from as i have p

[Excel]How do i trap a VBA runtime error using Error Handler -
Hi Guys, How do i ignore a runtime error (This file has been locked by user name for saving. Please try again later. ) How do i trap a runtime error using error handler to continue without trying to save the file again?

"runtime error 6149 invalid bookmark" -
Software environment : VB6.0 SP6, sql server2000, XP SP3. I have used components like datagrid..,crystal reports "runtime error 6149 invalid bookmark". This is the error i get from the vb application. Does anyhow know the reason or causes for the runtime error .? c

DriveListBox validation -
i have a DriveListBox component in my form. It has D:\,E:\ and F:\ drive in it. but my system has only D and E drive. And my F drive is a DVD drive.If by mistake i click the F drive in the DriveListBox a runtime error is thrown and my program gets abruptly ended. any suggestion to avoi

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

Runtime Error 380 -
If you run the userDisplay form and Click Next and switch to Edit mode. You get an error, Runtime Error 380! Anyone have any ideas? This is driving me crazy

I am getting Runtime Error 16 -
Hi guys I am getting a Runtime Error 16: Overflow. when my EXE that I created in VB 6 is running for few minutes and when I Click ok on the OK Button on error msg, the application shut down. Any idea what could be the cause? Thanks

Run-Time error ::RESOLVED:: -
Im getting runtime error 9 on my program when I run it, is there a way to debug runtime errors? When I run it from the IDE there is no errors at all. What kinds of things cause runtime errors? Thanks! NOMAD

runtime error in vb -
hi i am getting an error while using the following code rsRecordset.Open "query", gcnnOracleDB, adOpenStatic However i get the following error message; Runtime Error '-2147217887' ODBC Driver does not support the requested properties plz help me. its urgent.

Runtime error 3000 Updating a field -
I am trying to update a field using SQL in VB6 and the following error is occuring RUNTIME ERROR 3000 RESERVED ERROR (-1601) There is no message for this error Can someone please help

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

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 '

Annoying Runtime Error -
I am using a data environment to access a sql Table. Everytime I try to move the recordset pointer of the table I get the follwing runtime error: runtime error '-2147214872' operation has been cancelled. The code is as follows db.rsexam.movefirst --- error occurs on this l

reports runtime error cr10 -
i will be thank full and apriciate your reply i am facing the prblems to deploy setup for crystal report10 in vb6 it works fine at developler PC but not at client its give runtime error in different ways when i run after install runtme error '2147206462(80043ac2)' Dos err

Runtime Error -
Hi, I have a project which is converted to .exe. I want to run this in another system which doesn't have Visual Baisc or access. I provided all the OCX files need to run the project but I am getting run time error saying that runtime error 50003 unexpected error like that. Any help wi

Error in UserControl Paint event with Mdi - GPF -
I'm developping an application with Visual Basic 6.0 SP 6, but an strange error occurr when I use MDIForm and UserControl. When a unhandled exception occurr an one instance of a UserControl (internal to project) was instantiated in one MdiChild Form the execution is stopped without

[Problem] 2 WebBrowser On 1 Form -
Hello All, I am having a peculiar problem, whenever I add two WebBrowsers onto one and try to click between them i get a runtime error.. it's random which one I get, sometimes its "Run-Time Error '-1(ffffffff)'" or "Run-Time Error '-2(fffffffe)'" most of th

430 Runtime Error (yes I have done a search) -
I have tried finding a fix for this error to no avail Has anyone have any idea how to fix this god forsaken error? I have tried the following: - removing unneeded references - reinstalling vb runtime files Really I cannot think of anything else to do! Any ideas? Has anyone f

should be an easy one but noone can answer it please help me!!! -
Code: Private Sub Command1_Click() Dim dyna As Recordset Dim TheError As Long Dim theid As Long theid = txtCandidateID SQL= "select historydate,historyconsultant,historyaction,historyquicknotes from candidate where candidateID = " & theid & "'&quo

OnError -
Hello all... Can someone please tell me where to find a complete list of the Visual Basic RunTime Error codes? (ie. RunTime Error 6 = Overflow, or so VB says!) Thanks!