MyODBC v.5: Reserved error -7711

Hello,

I have been trying to use MyODBC v.5. I really need this version because my
MySQL database is mulitilingual and UTF-8.

When I try to link tables using the driver, I get the following MS Access
error: "Reserved error (-7711); there is no message for this error."

Has anyone else seen this error, or have an idea what to do?

(Windows xp, MS Access 2003)

thanks, Paolo



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC v.5: Reserved error -7711

Paolo wrote:

>Hello,
>
>I have been trying to use MyODBC v.5. I really need this version because my
>MySQL database is mulitilingual and UTF-8.
>
>When I try to link tables using the driver, I get the following MS Access
>error: "Reserved error (-7711); there is no message for this error."
>
>Has anyone else seen this error, or have an idea what to do?
>
>(Windows xp, MS Access 2003)
>
>thanks, Paolo
>
>
>
>
>
You can find the error information here;

http://msdn.microsoft.com/archive/default.asp?url=/archive/e n-us/dnaraccess/html/msdn_odk.asp

Unfortunately; it is not very much information in this case. We know
that some of these errors occur just because of differences in the MDAC
version.

Please consider visiting here;

http://msdn.microsoft.com/data/learning/MDAC/

Please ensure that you have the latest MDAC installed (there is a
version checker there).

--
Peter Harvey, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MyODBC v.5: Reserved error -7711

> Please ensure that you have the latest MDAC installed

Thanks, Peter.

I have checked. And the checker says: MDAC 2.8 SP1 on WIndows XP SP2

- which I think is the latest release?

So I guess I just have to wait until this bug gets ironed out some way!

Paolo



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC v.5: Reserved error -7711

Paolo wrote:

>>Please ensure that you have the latest MDAC installed
>>
>>
>
>Thanks, Peter.
>
>I have checked. And the checker says: MDAC 2.8 SP1 on WIndows XP SP2
>
>- which I think is the latest release?
>
>So I guess I just have to wait until this bug gets ironed out some way!
>
>Paolo
>
>
>
>
>
Paolo,

There would seem to be more to it. I will take a look at it sometime in
the coming days.

Thanks for reporting this.

--
Peter Harvey, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MyODBC v.5: Reserved error -7711

I have tried uninstalling and reinstalling the ODBC Data Source.

When I close the ODBC Data Source Administrator (in Control Panel) I receive
this message:

Data Excution Prevention - To help protect your computer, Windows has closed
this program: Run a DLL as an App (Microsoft Corporation).

- could this be something to do with it?

Paolo



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MyODBC v.5: Reserved error -7711

Well, I've made a little progress: following the instructions in Windows
Help I turned OFF Data Excution Prevention for "Run a Dll as an App".

When this is done, I can link all the tables in my MySQL database to MS
Access using the MyODBC v.5 connector.

However, when I open the tables it is disappointing: MS Access does not show
the UTF-8 character set correctly. Russian text is just a line of ??????,
etc. (This is the improvement over 3.51 that I specifically need.)

Paolo



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MyODBC v.5: Reserved error -7711

One other thing:

For the MyODBC 3.51.12 driver I have 3 tabs: Login / Connect Options /
Advanced

But for the v. 5 driver I only have the one Tab: Login

Is this normal, or does it mean that the driver is not correctly installed?

Paolo



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MyODBC v.5: Reserved error -7711

Paolo writes:
> When I try to link tables using the driver, I get the following
> MS Access error: "Reserved error (-7711); there is no message for
> this error."
>
> Has anyone else seen this error, or have an idea

Yes, I reported this issue on Nov 21st:
http://lists.mysql.com/myodbc/11029

Al McNicoll reported it using an older Connector/ODBC, Nov 3rd:
http://lists.mysql.com/myodbc/10980

(There's a nice list archive search interface here, btw:
http://lists.mysql.com/search.php?list=3Dmyodbc)


Peter Harvey writes:
> We know that some of these errors occur just
> because of differences in the MDAC version.

I don't think it's an MDAC issue. I've installed PostgreSQL/ODBC for
the purpose of testing for differences with MySQL's Connector/ODBC, and
the PostgreSQL ODBC driver doesn't have this issue (or any of the other
I reported tuesday ;-)).


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg