Access does not like Mysql - Microsoft Access / VBA

Stuart McGraw

I am having a problem creating Access tables linked to a
Mysql database. I get the widow to select a Data Source,
click on the (system) DSN I created (and tested ok), and
click ok. The Database Source selection window disappears,
but no window showing the Mysql tables ever appears nor
does any kind of error message (typical Microsoft.)
I can read the Mysql table using ODBC from a Python
program, so Mysql and ODBC seem to be working, looks
like Access is the one refusing to cooperate. Also, Access
seems screwed up after this, often dieing with an access
violation later on.

Any sugesstion about how to trouble shoot this? I generated
a odbc trace file, but I don't recognise anything in there as
being a blatant error.

Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
mysql-connector-odbc-3.51.12

Dec 2 '05 #1

Subscribe Reply

2654

Ron Hinds

I've connected to MySQL from Access 97 successfully. Usually what happens
after selecting the DSN is you are prompted for login information. I would
suggest upgrading your Windows 2000 to SP4 - I seem to recall there was an
issue with the MyODBC connector that required SP4.

"Stuart McGraw" <sm********@fri izz.RimoovAllZZ s.com> wrote in message
news:11******** *****@corp.supe rnews.com...

I am having a problem creating Access tables linked to a
Mysql database. I get the widow to select a Data Source,
click on the (system) DSN I created (and tested ok), and
click ok. The Database Source selection window disappears,
but no window showing the Mysql tables ever appears nor
does any kind of error message (typical Microsoft.)
I can read the Mysql table using ODBC from a Python
program, so Mysql and ODBC seem to be working, looks
like Access is the one refusing to cooperate. Also, Access
seems screwed up after this, often dieing with an access
violation later on.

Any sugesstion about how to trouble shoot this? I generated
a odbc trace file, but I don't recognise anything in there as
being a blatant error.

Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
mysql-connector-odbc-3.51.12

Dec 2 '05 #2

Stuart McGraw

Sorry, the "sp2" was a brain-fart. I am at sp4.

I looked again more carefully at the ODBC trace log. Just before
it checks for MSysConf, there is a BADMEM error. Is this significant?
I doubt it because the log continues with a lot more normal
looking stuff before it finally ends. But I have no idea what it
is saying, so maybe someone can interpret this?

--snip--
db1 270-5a4 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 096B15E8
UWORD 1 <SQL_ACTIVE_STA TEMENTS>
PTR 0x0012C738 (0)
SWORD 2
SWORD * 0x0012C71E (2)

db1 270-5a4 ENTER SQLAllocStmt
HDBC 096B15E8
HSTMT * 0012C2FC

db1 270-5a4 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 096B15E8
HSTMT * 0x0012C2FC ( 0x096b18c0)

db1 270-5a4 ENTER SQLGetStmtOptio n
HSTMT 096B18C0
UWORD 0
PTR 0x0012C2A8

db1 270-5a4 EXIT SQLGetStmtOptio n with return code 0 (SQL_SUCCESS)
HSTMT 096B18C0
UWORD 0
PTR 0x0012C2A8

db1 270-5a4 ENTER SQLSetStmtOptio n
HSTMT 096B18C0
UWORD 0 <SQL_QUERY_TIME OUT>
SQLPOINTER 0x0000003C

db1 270-5a4 EXIT SQLSetStmtOptio n with return code 0 (SQL_SUCCESS)
HSTMT 096B18C0
UWORD 0 <SQL_QUERY_TIME OUT>
SQLPOINTER 0x0000003C (BADMEM)

db1 270-5a4 ENTER SQLExecDirectW
HSTMT 096B18C0
WCHAR * 0x1B074AA0 [ -3] "SELECT Config, nValue FROM MSysConf\ 0"
SDWORD -3

db1 270-5a4 EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 096B18C0
WCHAR * 0x1B074AA0 [ -3] "SELECT Config, nValue FROM MSysConf\ 0"
SDWORD -3

DIAG [S0002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.16-nt]Table 'jdb.msysconf' doesn't exist (1146)
--snip--

~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~ ~~~~~~~

The log ends with:

--snip--
db1 270-5a4 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 096B15E8
UWORD 24 <SQL_CURSOR_ROL LBACK_BEHAVIOR>
PTR 0x0012C842 (2)
SWORD 2
SWORD * 0x0012C814 (2)

db1 270-5a4 ENTER SQLGetInfoW
HDBC 096B15E8
UWORD 29 <SQL_IDENTIFIER _QUOTE_CHAR>
PTR 0x0012C82C
SWORD 20
SWORD * 0x0012C854

db1 270-5a4 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 096B15E8
UWORD 29 <SQL_IDENTIFIER _QUOTE_CHAR>
PTR 0x0012C82C [ 2] "`"
SWORD 20
SWORD * 0x0012C854 (2)

Is this a normal ending?
Does any of this give any information about what Access is up to?

"Ron Hinds" <__ron__dontspa mme@wedontlikes pam_garageiq.co m> wrote in message news:uV******** ******@TK2MSFTN GP09.phx.gbl...

I've connected to MySQL from Access 97 successfully. Usually what happens
after selecting the DSN is you are prompted for login information. I would
suggest upgrading your Windows 2000 to SP4 - I seem to recall there was an
issue with the MyODBC connector that required SP4.

"Stuart McGraw" <sm********@fri izz.RimoovAllZZ s.com> wrote in message
news:11******** *****@corp.supe rnews.com...
I am having a problem creating Access tables linked to a
Mysql database. I get the widow to select a Data Source,
click on the (system) DSN I created (and tested ok), and
click ok. The Database Source selection window disappears,
but no window showing the Mysql tables ever appears nor
does any kind of error message (typical Microsoft.)
I can read the Mysql table using ODBC from a Python
program, so Mysql and ODBC seem to be working, looks
like Access is the one refusing to cooperate. Also, Access
seems screwed up after this, often dieing with an access
violation later on.

Any sugesstion about how to trouble shoot this? I generated
a odbc trace file, but I don't recognise anything in there as
being a blatant error.

Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
mysql-connector-odbc-3.51.12

Dec 2 '05 #3

Terry Kreft

Ahh, that's where you're going wrong; the spouse has to be live for this to
work.

--
Terry Kreft

"Stuart McGraw" <sm********@fri izz.RimoovAllZZ s.com> wrote in message
news:11******** *****@corp.supe rnews.com...

I am having a problem creating Access tables linked to a
Mysql database. I get the widow to select a Data Source,

<SNIP>

Dec 3 '05 #4

Similar topics

2199

mysqld cannot access innodb

by: Maciej Wiznerowicz | last post by:

Dear Sirs, I can not start MySQL server. More specifically, MySQL was running fine all the time since installation. It stopped working after I used FmPro Migrator to convert some File Maker databases to MySQL It looks like mysqld has no access permissions to InnoDB and I do not know how to fix it.

MySQL Database

1978

Using MS Access as a front end and trying to run a script

by: Paradigm | last post by:

Does anyone know how I can use vba in access to run a script that is stored as a file. I can make a connection to mysql database and run sql statements but this sql statement is very long (creates many tables with hundreds of fields). I can run the script in the mysql interface but I want to do this from my access front end to make it easy for the user to set up the tables. I need something like myconnection.execute...

MySQL Database

1703

MS Access Equivalent

by: Murphy | last post by:

I am new to Linux and am migrating a SQL Server DB with an Access front end to MySQL and ? What options are available under Linux for development of a client front end without copious amounts of programming. Without knowledge of PHP can a front end be developed using plugin components with minimal fuss ?

MySQL Database

4152

ERROR 1045: Access denied for user

by: dstewart | last post by:

Situation: One common MySQL database server on SuSE 9.1 with all updates. Uses 'rinetd'. Has entries for the appropriate IP addresses of all servers. NOTE: If the appropirate entries are NOT in rinetd, the error message is: ERROR 2013: Lost connection to MySQL server during query Using the exact same query from prompt on several clients (some are SuSE 9.1, some are older Redhat systems, but none are configured

MySQL Database

3615

Workdate calculation Access 2000

by: Pres | last post by:

I am not an experienced programmer. I do have a question regarding workday calculations. I have 3 fields. CURDATE, NUMDAYS, CALCDATE After entering the first two fields, normally the current date and for example 10 (10 day period) I need the CALCDATE to pass me the calculated date taking into account workdays and holidays. In other words, the 10th business day. How is this done? Thanks for any help...

Microsoft Access / VBA

4647

Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP

by: Cheryl Langdon | last post by:

Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never before needed to do this HTTP/XML/MySQL type functions.

Microsoft Access / VBA

2917

Is There a Client/Server Version of Access ?

by: B1ackwater | last post by:

We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a front end to SQL server if we ever needed to go that route. But - is there a client/server version of Access ? Looking on the CDW site there is a bewildering variety of packages and licences and such, but we can't figure out just which do...

Microsoft Access / VBA

2911

Access and MYSQL

by: Vanessa | last post by:

Hi there I am an Access developer, and I have written applications for a 30 telephone call center, using the standard multiuser jet engine, it all works fine, but I want to move our systems onto MySQL, as we get the odd #DELETED# (that old chestnut) so that it is more stable, I have installed mysql and myodbc and configured it in data sources (ODBC) and it works fine (done the TEST). But when I try to export a table from the mdb

MySQL Database

9691

Is firewall preventing MySQL access?

by: Kevin Killion | last post by:

I've recently features to a system by making use of some simple MySQL access routines. It works fine at most test locations, correctkly accessing a MySQL database on an internet server. However, at certain test sites, I cannot access the database. We're online, and I can access web files, for example. But when trying to say hello to that MySQL database, the program fails at the "mysql_real_connect" call. The message is "Can't connect...

MySQL Database

9695

What is ONU?

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

General

9555

Changing the language in Windows 10

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

Windows Server

10514

Problem With Comparison Operator <=> in G++

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

C / C++

10287

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

9099

AI Job Threat for Devs

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

Career Advice

7588

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

6826

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5479

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

4156

transfer the data from one system to another through ip address

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

C# / C Sharp