MyODBC 5.00.07 feedback

I just finished testing MyODBC 5.00.07 with MS Access 2002 ( sp3 ) on
Windows 2000 ( sp4, MDAC-2.8, all Windows Updates ). I have also tested
with the 'current' msjet40.dll that Windows Update pushed, as well as
msjet40_v_4.0.8618.0.dll as per directions in
http://bugs.mysql.com/bug.php?id=9932.

I can create a System DSN.

In Access, I go to link tables and then select the DSN. I get a blank
DSN setup dialog ( that I just filled in ), so I fill them in again and
then get a list of all the tables in my selected database. I select a
table, hit OK, and it appears as a linked table in Access. Each new
table I link I have to fill in all these details again, however when I
go to the ODBC configuration panel in the Windows control panel and edit
the DSN, all the details are filled in, but Access isn't seeing them
when making new table connections.

I then open the table, and get an error message from Access: "ODBC--call
failed.", and a datasheet full of #NAME? I have tried with simple tables
with just mediumints in it, and also with and without a timestamp(14) field.

Also Access crashed on a relatively large number of occasions while
linking and opening tables, and also would crash when I exited Access
'normally'. Then each time I restarted Access and went to open a table,
I would get the DSN dialog with all the details filled in apart from the
username and password.

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

--
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 5.00.07 feedback

Daniel Kasak wrote:

> In Access, I go to link tables and then select the DSN. I get a blank
> DSN setup dialog ( that I just filled in ), so I fill them in again and
> then get a list of all the tables in my selected database. I select a
> table, hit OK, and it appears as a linked table in Access. Each new
> table I link I have to fill in all these details again, however when I
> go to the ODBC configuration panel in the Windows control panel and edit
> the DSN, all the details are filled in, but Access isn't seeing them
> when making new table connections.

Access saves the output connection string to use for the next link
tables (if you enable the view on system tables you can see it). I'd
guess myodbc is not returning it (see SQLDriverConnect and the
OutConnectionString argument). That sounds like a bug in myodbc driver.

Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

--
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 5.00.07 feedback

Daniel Kasak wrote:

> I just finished testing MyODBC 5.00.07 with MS Access 2002 ( sp3 ) on
> Windows 2000 ( sp4, MDAC-2.8, all Windows Updates ). I have also
> tested with the 'current' msjet40.dll that Windows Update pushed, as
> well as msjet40_v_4.0.8618.0.dll as per directions in
> http://bugs.mysql.com/bug.php?id=9932.
>
> I can create a System DSN.
>
> In Access, I go to link tables and then select the DSN. I get a blank
> DSN setup dialog ( that I just filled in ), so I fill them in again
> and then get a list of all the tables in my selected database. I
> select a table, hit OK, and it appears as a linked table in Access.
> Each new table I link I have to fill in all these details again,
> however when I go to the ODBC configuration panel in the Windows
> control panel and edit the DSN, all the details are filled in, but
> Access isn't seeing them when making new table connections.
>
> I then open the table, and get an error message from Access:
> "ODBC--call failed.", and a datasheet full of #NAME? I have tried with
> simple tables with just mediumints in it, and also with and without a
> timestamp(14) field.
>
> Also Access crashed on a relatively large number of occasions while
> linking and opening tables, and also would crash when I exited Access
> 'normally'. Then each time I restarted Access and went to open a
> table, I would get the DSN dialog with all the details filled in apart
> from the username and password.
>
Daniel,

Thanks for the feedback. We have made some improvements with C/ODBC & MS
Access in the latest Beta (v5.00.08) and already have more in place for
the next Beta.

We know about the crash which can occur when closing MS Access under
certian circumstances and we know where the problem is. We are working
to get a fix together for it.

Thanks again!

--
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 5.00.07 feedback

Martin J. Evans wrote:

> Daniel Kasak wrote:
>
>> In Access, I go to link tables and then select the DSN. I get a blank
>> DSN setup dialog ( that I just filled in ), so I fill them in again
>> and then get a list of all the tables in my selected database. I
>> select a table, hit OK, and it appears as a linked table in Access.
>> Each new table I link I have to fill in all these details again,
>> however when I go to the ODBC configuration panel in the Windows
>> control panel and edit the DSN, all the details are filled in, but
>> Access isn't seeing them when making new table connections.
>
>
> Access saves the output connection string to use for the next link
> tables (if you enable the view on system tables you can see it). I'd
> guess myodbc is not returning it (see SQLDriverConnect and the
> OutConnectionString argument). That sounds like a bug in myodbc driver.
>
> Martin
> --
> Martin J. Evans
> Easysoft Limited
> http://www.easysoft.com
>
Martin,

Sounds like a good thing for us to verify :)

Thanks!

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