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, dbExecDirect, dbOptimisticValue)
can anyone tell me why this would result in a runtime error 3146 on a computer with the same ODBC driver and the DSN's path is 100% accurate?
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; -
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
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
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
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
Selecting List of ODBC Drivers through coding -
I want to get the ODBC drivers like Microsoft ODBC for ORACLE etc., so that I can able to select a driver during
runtime, and also i want to create a datasource name
at the runtime according to the user choice.
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
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..
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
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.
Creating New Datasource -
I want to create a New datasoruce (ODBC) through VB.
How to bring a ODBC driver at runtime in vb.
Waiting for the reply....
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
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 '
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
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
Help ! How to use ODBC -
Hi,
I need to develop an VB application that will retrieve data from a OS-2 server with DB2 as dbms. I know that ODBC will properly solve this problem, but i have no experince on ODBC. I have some qestion on ODBC,
1) Do i need to install ODBC driver into the OS-2 server ?
2) The VB
performance problem wihh odbc -
Im in trouble... We are using an ODBC connection to access IDMS.
I have some serious performance problems. I have traced my asp.net app and got the following results:
ODBC Open() 10 seconds
ODBC Command() 5 seconds
ODBC Close() 9 seconds
These are .net odbc objects.
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
HELPPPP !!! About ODBC -
Dear All members and gurus,
I'd like to ask about ODBC.
Some of my old program still using ODBC as the connection.
And, now, I've got to implement my program using 2 database with one DSN name at ODBC administrator.
I know, maybe your suggestions will be ===> Change the conn
Updating Through ODBC Help -
I am trying to update a record through ODBC on a AS400. I am using a Rumba optimized ODBC. I am able to get info from from the 400 just fine but I just can't get it to go the other way around and update. I am also trying to do it using a DataEnvironment right now. Does anyone have any
ODBC with Oracle -
I could not get odbc connection with oracle. How can i get the connection using ODBC. When i created Datasource it is not showing Oracle Odbc Driver. It is giving sql server only.
How to set ODBC with Oracle in Visual Basic 6. When i tried with coding it is not displaying oracle.
ODBC Access Question -
Hello All...
Just a quick question to see if anyone has any ideas... I would like to be able to get information from an ODBC DSN (ie FileName and type). I know that I can get DSN information from the registry key \HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI, but I was wondering how g
HOWTO: Remote ODBC Installs -
I just had to write this so thought i'd share:
Sometimes you still have to use ODBC for legacy work, and all the users still have to have the ODBC installed locally, this can be done in many ways, a .reg file, an NT login script, or using VB....
Here's the project to remotely i
Query with ODBC connection -
Anyone know if it's possible to use Case statement and Substring for queries within a ODBC Connection? I had always use OleDB in the past and was able to do it, but for some odd reason when I use ODBC I can't seem to use that. Keeps giving me that an operator is missing even though i
Crystal Reports 7.0 (ODBC connection) -
I am using Crystal Reports and VB with Access as my database. I create a ODBC connection in the control panel and point to the ODBC connection when I created the report in the design mode. everything works fine until I go to another machine with the same ODBC connection but everything
Need a challenge Try This !!! :p~ -
Dear All members and gurus,
I'd like to ask about ODBC.
Some of my old program still using ODBC as the connection.
And, now, I've got to implement my program using 2 database with one DSN name at ODBC administrator.
I know, maybe your suggestions will be ===> Change the
ODBC API or ADO -
Hi,
I am having one VB application that is using ODBC API to access a remote AS/400 database. It is hard to understand and difficult to maintain the application, since it is using API. I want to change it to ADO/OLE_DB. Which one will be faster, accessing data through ODBC (note no
Killing odbc -
Hi chaps!!
Does anybody have some code to delete/kill a odbc data source, I have code to create one but it doesn't work if I have the odbc name setup lready. Another solution is the ability to change the underlining (Access97) database that the odbc is setup for.
Setting ODBC from VB ! -
hi all,
is it possible to set an ODBC database, from VB (by codes)?
Suppose that the program should use an ODBC database named "gmt". And also suppose that this database exits in a folder, but not set in ODBC in the users computer.
Now, is it possible to set the nec
ODBC Why and How -
Dear Friends,
I would like to see your precious opions on whether I should use ODBC or not?
I am building a stock charting program using Access 2000 and an active control called TeeChart Pro v4.0 which allow me to specify an ODBC data source for charting. I have nearly 25
ODBC Update Problem -
Hi
I'm working with ODBC and Workspace and try to insert Data from an Access mdb file into an Oracle Database.
I have to insert about 23000 rows containing of 30 items per row of type number or char(20).
Thus I have to insert a lot of data I'm working with
dbUseClientBatchCur
Odbc... -
Hi!!
i'd like to know if it's possible to build an App that allow me to
view the data of different types of databases (i believe that'd be throug
ODBC) but how? i mean, if it's possible using ODBC how do i use it
with VB?
CrystalReport With ODBC -
Does anyone have used crystalreport using odbc?
The q is because i have set an odbc call x1, i attached the report to the x1 odbc (the x1 have the path, the database name,etc). What happen if i want to change the path via code?
odbc conn in ctrl panel ! -
@ runtime
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.
ODBC & Remote data control -
I'm using VB5 SP3.
When I tried to place the MS Remote Data control on a form, I get the following error:
The ODBC resource DLL (..../odbcint.dll) is a different version then the ODBC driver manager (.../odbc32.dll). You need to reinstall the ODBC components to ensure propoer operati
ADO/ODBC return codes -
Does ADO or ODBC return a 'Long' number or handle? I am trying to incorporate a LANDesk control into a helpdesk application and I need to pass it an ODBC connection handle of some kind but have not been able to figure out how to return one from ODBC or ADO. Anyone have any ideas?
Data Control and ODBC -
Does anyone have any convenient code for hooking up a datacontrol to a database through an ODBC connection? I can do it with a file access DB, but I can't seem to find a quick way to connect to an ODBC one.
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