Anyone with any experience with MyODBC 3.51 linking MySQL tables to MS
Access 97 please tell me how I can clear the miscellaneous, failed
setup attempts from under the Machine Data Source tab on the Select
Data Source window?
Everytime I clicked "NEW", trying variations of configuration options
in hopes of making it work resulted in a new Machine Data Source being
set up. Now I have to look at all the failed ones along with the one
successful configuration everytime I use it to renew my attachments.
Ideas on how to get rid of 'em?
I'm quite frustrated with looking at them. 2 1342
"Archie Ball" <cr**@northstat e.net> wrote in message
news:js******** *************** *********@4ax.c om... Anyone with any experience with MyODBC 3.51 linking MySQL tables to MS Access 97 please tell me how I can clear the miscellaneous, failed setup attempts from under the Machine Data Source tab on the Select Data Source window?
Everytime I clicked "NEW", trying variations of configuration options in hopes of making it work resulted in a new Machine Data Source being set up. Now I have to look at all the failed ones along with the one successful configuration everytime I use it to renew my attachments. Ideas on how to get rid of 'em?
I'm quite frustrated with looking at them.
Access 97 - wow! You are at least using Windows 98 or higher, aren't you?
Hard to believe you don't have a [Remove] button on your ODBC dialog -
Machine Data Source tab. But if this is truly the case, you are going to
have to root out the entries manually from the registry.
Thomas Bartkus
Archie Ball wrote: Anyone with any experience with MyODBC 3.51 linking MySQL tables to MS Access 97 please tell me how I can clear the miscellaneous, failed setup attempts from under the Machine Data Source tab on the Select Data Source window?
Everytime I clicked "NEW", trying variations of configuration options in hopes of making it work resulted in a new Machine Data Source being set up. Now I have to look at all the failed ones along with the one successful configuration everytime I use it to renew my attachments. Ideas on how to get rid of 'em?
I'm quite frustrated with looking at them.
If a connection is not working properly isn't it easier just to adapt
some parameters in stead of just making a new one? I might be saying
something stupid but I'm not familiar with the MyODBC dialogs and options.
You can probably do so by the All Programs > Administrative Tools >
Datasources (ODBC) option (at least in Windows XP). This Administrative
Tools menu is not visible by default but you can access it by modifying
the apropriate option on the Advanced tab of the Start menu customization.
Jonathan
--
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: dave |
last post by:
hi
I want to install mysql odbc driver 3.51 and downloaded
MyODBC-3.51.06-dll.zip from the mysql.com.
but when i unzipped it, it shows only dll file..
I m very confused how to install odbc driver? would i
need to install whole mysql as well or i can just install
myodbc driver? I just wanted to create DSN to remote
server..
I'm using windows xp
Any help would be appreciated..
|
by: Kenneth Foli Jørgensen |
last post by:
------=_NextPart_000_000D_01C35CF0.20AC1200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
i get this msg:
Microsoft.Data.Odbc.OdbcException: NO_DATA - no error information =
available
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, =
SQL_HANDLE hType, RETCODE retcode)
|
by: Tim Hastings |
last post by:
Hello,
I am using MyODBC from VB and I want to submit a batch of insert statements
in one call from my App. This is more efficient than making multiple calls
from code because of the communication overhead.
If I send a batch multiple statements separated by ; or ; + newline I get
syntax errors pointing at the start of the next statement..
If I fire each statement one at a time with the ; at the end there's no
problem.
|
by: Dominikus Zimmerer |
last post by:
Hello,
i want to install the MyODBC driver for windows.
i donwloaded the newest installer from the mysql website.
-> MyODBC-3.51.06.exe
now i know the command line parameter for a silent installation (/s),
but i wonder if there are more... Logfile....
I didnt find anything in the forum or an mysql website, so maybe
|
by: Dave |
last post by:
Ok I have an interesting problem. I have written a database in Access
to connect to our web shop and update prices etc from a supplier feed.
It works almost perfectly!
The prices are doubles, I am using ADO in access to connect via myodbc
(with options don't optimize column width, Allow big results and
change bigint to int). Everything works ok except if the price is
8351.41 in the code it puts this exact price into the price field of...
| |
by: xixi |
last post by:
hi,
we are using db2 udb v8.1 on win 64 bit with fp3 with type 4
db2jcc.jar driver.
i have this problem happened sometimes when try to execute a query and
failed.
com.ibm.db2.jcc.a.DisconnectException: Execution failed due to a
distribution protocol error that caused deallocation of the
|
by: Archie Ball |
last post by:
It can be replicated by anyone having a windoze box with Access 97 and
the MyODBC 3.51 driver installed. In Access, click File, Get External
Data, Link Tables. For Type of File, choose ODBC Databases. Select
Data Source window opens, choose Machine Data Source and all the Data
Source configurations are listed there. Some (I no longer use) are
useless and I would like to remove them. I've found no way to do 'em
so far.
Thx.
|
by: Michael Maes |
last post by:
Hi,
We have a windows service passing objects to a client application by
remoting.
The windows service is started and running successfully.
* When the client app is running on the same machine as the windows service
(W2K3) every method gets executed successfully.
* When the client app is running on a different machine (XP SP2), some
methods from the remote object the client calls make client hang. Other
|
by: onnodb |
last post by:
Hi all,
While working on an Access UI to a MySQL database (which should be a
reasonable, low-cost, flexible interface to the DB, better than
web-based, much less costly than a full-fledged .NET app or so.... is
it?), I tried measuring the bandwith consumed by the
Access/MyODBC/MySQL link, which came out to be, er, quite high.
I fancied it would be interesting to look at the queries Access throws
at MySQL through the ODBC link, so I...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |