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: dkasak@stripped
> website: http://www.nusconsulting.com.au