|
by: tina |
last post by:
Hello,
Can you hale me to define my mistake please?
I am trying to run a SQL Pass – Through Query from Access 2000 and
inside the record set I am trying to loop for a LoginID. I think
that this function should work.
I get an error at this point Set StoredProcRecordSet =
DB.OpenRecordset(StoredProcQryName, DB_OPEN_SNAPSHOT)
The error is this ODBC--call failed.
|
by: Yannick Turgeon |
last post by:
Hello all,
I'm using:
- A97 (front-end)
- MySQL drivers 3.51
- MySQL 4.0.18 (back-end)
I've got a MySQL table connected to an Access DB throw an ODBC link. When I
connect to this table, no matter the query, a connection is created in
MySQL. Initialy, this connection stayed opened 8 hours (default. controled
|
by: VBSponge |
last post by:
Hi all. Need help here as I cant see whats wrong...
I have a querydef in Access 2k which execs a stored proc in a SQL
Server 2k db.
I keep getting the following error, and cant stop it for the life of
me:
"Error 3146: ODBC Call Failed"
Now, the stored proc uses @RETURN_VALUE to pass back an integer result
|
by: mcbill20 |
last post by:
Hello all. I just installed Oracle 10g developer tools on a machine
running XP Pro and Office XP. Before this I had just the Oracle 9
client installed. I the previous configuration, I was able to access
any of the Oracle tables on another machine but now I am having
problems. Unfortunately, I don't remember the correct syntax for the
ODBC connect string and I am hoping that is my whole problem.
I am trying to connect to an Oracle 9...
|
by: Jimbo |
last post by:
I have a form in access 97 that is populated by a query against some
sql server
tables....when ever the query pulls up only one record im fine..however
if it
pulls up more than one record i have to make sure i click the
the navigation arrows through all the records or else I get an odbc
error and all the fields go to #Name? If I click the arrows and scroll
through all the records Im ok..
What is causing this ?
|
|
by: TheKval |
last post by:
I'm trying to pull records on a Macola table linked to Access. If
enter a value in the criteria field of the query form, the quer
executes okay. If I change the criteria to a parameter, ala, , I get the ODBC... call failed error. The data ite
is a 3 character text field. I've tried to us the parameter AFTE
trimming the table field. no luck
Any helpful hints? :
|
by: Harmony407 |
last post by:
Hello:
Our organization uses MS Access to store all of our members
information.
Our primary database computer is running on Windows 98. This is where
the main database exists. The MS Access version we are running is MS
Access 95, V7. I know it is very old, but the organization is afraid
to update to a newer version for fear of losing data. So, I must work
with what I have.
|
by: mukeshhtrivedi |
last post by:
We have 4 MS Access Databases with few tables on each DB. There are
some reports which uses ODBC. When I try to use the report and input
date range and click ok I get error "ODBC --call failed" it happens on
my computer only. I have just setup Windows XP SP2 with latest updates
and MS Office Prof. 2000 and in ODBC I have same dirvers installed as
other users who are able to access reports without any problem.
Can anybody tell me what...
|
by: alegria4ever |
last post by:
I have an Access 2000 database that links several tables from Oracle 9.
For some reason or another, one of our user repeatedly gets the
following error when accessing queries within this database:
************************************************************************************
ODBC -call failed.
ORA-01017: invalid username/password; logon denied
(#1017) Driver's SQLSetConnectAttr
failed IM006 0 Driver's
SQLSetConnectAttr failed...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|