Re: MySQL Connector/ODBC 5.0.6 BETA has been released

"Al McNicoll" <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Organization Integritec Ltd
Message-ID <000001c6ff36$188516d0$0202a8c0@integritecal> 
Dear Jess, Mark (and all),

Firstly: thanks for the much improved communication and regular releases of
MyODBC. I think we're all grateful to hear what's going on and get our teeth
into testing releases.

Further to Daniel Kasak's problem with 5.0.5, I have a similar issue with
5.0.6 BETA.

- XP Home SP2
- AMD Athlon XP
- 1GB RAM
- Office Professional 2003
- MDAC 2.8 SP1 (see attached file from Microsoft's MDAC checker)

I can correctly set up a system DSN now (ie the System-DSN-becomes-User-DSN
problem is fixed for me in 5.0.6b) but Access 2003, when asked to link
tables via a 5.0.6 DSN, gives:

Reserved Error (-7711); there is no message for this error.
[OK]

The Linked Table Manager then stops trying to link further tables.

I get the same error if I try to run a pass-through query using the v5.0.6b
DSN.

I knew how to set up logging on 3.51.12 but as there's no flag for it on the
5.0.6b DSN setup form I don't know how to log more information with this
release. If you need to know more, please provide instructions on how I can
find out what you need to know (I'm afraid I can't compile a debug build
from source files if that's what's required - I simply don't have the time
or expertise).

Regards,

Al McNicoll
Integritec Limited


-----Original Message-----
From: Jess Balint [mailto:[email protected]] 
Sent: 23 October 2006 04:51
To: Daniel Kasak
Cc: [email protected]
Subject: Re: MySQL Connector/ODBC 5.0.5 has been released

Daniel -

We are aware of both issues and we're working to get them fixed.

-- 
Jess Balint, Developer
MySQL Inc, www.mysql.com
Office: +1 773 915 3175

On Mon, Oct 23, 2006 at 11:39:36AM +1000, Daniel Kasak wrote:
> Firstly, I set up a new *System* DSN ( because this has traditionally 
> been the only type of connection I could make work ), but it didn't 
> appear in the ODBC manager under 'System DSN' ... it appeared under 
> 'User DSN'. At the moment, I consider this problem to be merely 
> cosmetic, but could be causing other problems down the line.
> 
> Next, I go to MS Access, link tables, select the new DSN, select a 
> table, and get the error:
> 
> >Reserved error (-7749); there is no message for this error. [ OK / Help ]
> 
> If I instead try to link a view, I get:
> 
> >The Microsoft Jet database engine could not find the object 
> >'VIEW_NAME'. Make sure the object exists and that you spell its name 
> >and the path name correctly.
> 
> I haven't bothered making ODBC trace log thingy yet, but can if someone 
> wants them.
> 
> I'm using:
> 
> - Windows 2000 SP4 and all Windows Updates
> - MS Office XP ( Access 2002 ) with SP3
> - MDAC 2.8
> - msjet40.dll 4.0.8618.0
> - MySQL-5.0.22
> 
> -- 
> Daniel Kasak
> IT Developer
> NUS Consulting Group
> Level 5, 77 Pacific Highway
> North Sydney, NSW, Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
> email: [email protected]
> website: http://www.nusconsulting.com.au


-- 
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.431 / Virus Database: 268.13.25/515 - Release Date: 03/11/2006
05:15


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]
MDAC versions.xml (text/xml, 5.7 KB) 
<closestversion ClosestReleaseMatches="
MDAC 2.8 SP1 ON WINDOWS XP SP2"><filedetails><group name="MDAC 2.8 SP1 ON WINDOWS XP SP2" count="13"><file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="MSADCOR.DLL" dir="%COMMONFILES%\system\msadc\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - Remote Data Services Data Control Resources" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="16384" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="msado15.dll" dir="%COMMONFILES%\system\ado\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - ActiveX Data Objects" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="536576" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="MSADOMD.DLL" dir="%COMMONFILES%\system\ado\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - ActiveX Data Objects (Multi-Dimensional)" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="180224" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="msadrh15.dll" dir="%COMMONFILES%\system\ado\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - ActiveX Data Objects Rowset Helper" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="57344" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="MSDASC.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - OLE DB Service Components Stub" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="4096" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="MSDASQL.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - OLE DB Provider for ODBC Drivers" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="315392" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="MSDASQLR.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - OLE DB Provider for ODBC Drivers Resources" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="16384" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="OLEDB32.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - OLE DB Core Services" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="487424" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="SQLOLEDB.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2000.85.1117.0" fileversion="8.0.1117.0"/>
				<found xmlns="" Description="Microsoft OLE DB Provider for SQL Server" date="08/4/2004" fileVersion="2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)" size="528384" version="2000.85.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="SQLSRV32.DLL" dir="%SYSTEMDIR%\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2000.85.1117.0" fileversion="3.85.1117.0"/>
				<found xmlns="" Description="Microsoft SQL Server ODBC Driver" date="08/4/2004" fileVersion="2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)" size="442368" version="2000.85.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="msdart.dll" dir="%SYSTEMDIR%" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - OLE DB Runtime Routines" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="151552" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="msdaorar.dll" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0" fileversion="2.81.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - OLE DB Provider for Oracle Resources" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)" size="16384" version="2.81.1117.0"/></file>
			<file xmlns="http://tempuri.org/CCFilestream_template.xsd" name="msorc32r.dll" dir="%SYSTEMDIR%\" CoreFile="Yes">
				<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.575.1117.0" fileversion="2.575.1117.0"/>
				<found xmlns="" Description="Microsoft Data Access - ODBC Driver for Oracle Resources" date="08/4/2004" fileVersion="2.575.1117.0 (xpsp_sp2_rtm.040803-2158)" size="20480" version="2.575.1117.0"/></file>
		</group></filedetails></closestversion>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.