ODBC driver crashing my program

This is a discussion on ODBC driver crashing my program within the MySQL Database forums, part of the Database Forums category; Hallo, I am new to any database stuff. I work under Win2k SP4. I downloaded the latest stable release of ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 6 Days Ago
Uwe Kotyczka
 
Posts: n/a
Default ODBC driver crashing my program

Hallo, I am new to any database stuff. I work under
Win2k SP4.

I downloaded the latest stable release of MySQL 5.0
(mysql-5.0.51a-win32.zip) and installed it on my local
machine. I configured it without changing any of the
default options. The MySQL service starts fine.

Reading the Manual (sections 3.3 and 3.4) I created my
first small database "menagerie".

Next I wanted to install the ODBC drivers. I downloaded
mysql-connector-odbc-3.51.25-win32.msi
mysql-connector-odbc-5.1.4-win32.msi
mysql-connector-odbc-noinstall-5.1.4-win32.zip
Starting the .msi versions the setup ends with an error
message: "Error 1305. Error reading from file <path to .msi>
Verify that the file exists and that you can access it."

Any idea what to do against that? I have full admin rights.

Next I tried the zipped file. Extracted it and ran the
batch file. Seams fine so far.

Starting the ODBC control panel i can add a User DSN
for the "MySQL ODBC 5.1 Driver". After giving some rights
to my "meangerie" database using the "GRANT" command at
the MySQL console (as described in the manual)
I can connect to "meangerie" by pressing the "Test"
button.
I also can load "meangerie" into MS Excel and into
MS Access as described in the manual.

BTW, if I try to add a new File DSN for the MySQL ODBC
driver, I cannot connect to "meangerie". The file
created contains only one line "DRIVER={MySQL ODBC 5.1 Driver}".
What would I have to add to make it work?

Now I thought I could start the thing I am really
interested in. That is to code a program which can access
"menagerie" via ODBC. I'm using MS Visual C++ 6.0.
Because database stuff is new to me I just started
with the "Connect" sample from the MSDN that ships
with VC++6. The sample compiles fine (as expected).
However when running the program, if I select the
User DSN entry, which connects fine in all the other cases
I tried before, I get an access violation in MyODBC5.dll
(0xC0000005). Doesn't matter if I try it in release
or debug mode.
What the hell is going wrong now? It cannot be my
fault. And what to do against it? Is it a known
bug in the MySQL ODBC driver? Should I install
another ODBC driver? But where to get another - the
..msi setups refuse to work?
I am really frustrated at this point. Can anyone give me
some advice please?
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:23 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0