We are looking for people to try a patch for MyODBC 3.51.10-2 on XP.
This should resolve;

- connect issues (particularly with SQLDriverConnect)
- DSN attributes not being used

http://www.peterharvey.org/Downloads/MySQL/MyODBC/MyODBC-3.5 1.10-2-patch3.zip

We are interested in feedback before we decide to use the fix in a new
distro release.

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 [at] m.gmane.org

------------=_1106887831-30490-4
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Peter Harvey wrote:

> We are looking for people to try a patch for MyODBC 3.51.10-2 on XP.
> This should resolve;
>
> - connect issues (particularly with SQLDriverConnect)
> - DSN attributes not being used
>
> http://www.peterharvey.org/Downloads/MySQL/MyODBC/MyODBC-3.5 1.10-2-patch3.zip
>
>
> We are interested in feedback before we decide to use the fix in a new
> distro release.
>
> Thanks

I'm getting CRC errors when I try to unzip the above download.
I downloaded twice: once from thunderbird, and once with wget.
I tried WinRar and Linux's 'unzip' command, and every time got CRC errors:

dkasak mysql # unzip MyODBC-3.51.10-2-patch3.zip
Archive: MyODBC-3.51.10-2-patch3.zip
error [MyODBC-3.51.10-2-patch3.zip]: missing 1 bytes in zipfile
(attempting to process anyway)
error [MyODBC-3.51.10-2-patch3.zip]: attempt to seek before beginning
of zipfile
(please check that you have transferred or created the zipfile in the
appropriate BINARY mode and that you have compiled UnZip properly)
(attempting to re-compensate)
inflating: MyODBC-3.51.10-2-patch3/myodbc3.dll
inflating: MyODBC-3.51.10-2-patch3/myodbc3.lib
inflating: MyODBC-3.51.10-2-patch3/myodbc3S.dll bad CRC 1bbf1de0
(should be 5d9713f9)
file #4: bad zipfile offset (local header sig): 1714316
(attempting to re-compensate)
inflating: MyODBC-3.51.10-2-patch3/myodbc3S.lib
inflating: MyODBC-3.51.10-2-patch3/README.txt
dkasak mysql #

I will continue with testing ( ie try the dlls despite the above CRC
errors ) on my PC when I get a spare couple of minutes ( probably not
today ).

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


------------=_1106887831-30490-4
Content-Type: text/plain; charset=us-ascii

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
------------=_1106887831-30490-4--

Those having problems unzipping file please try again.

>
>WinZip gives error on this file: missing 1 bytes in Zip file ...
>
>
>
>
>>http://www.peterharvey.org/Downloads/MySQL/MyODBC/MyODBC-3 .51.10-2-patch3.zip
>>
>>
>>


--
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 [at] m.gmane.org

------------=_1106888616-30490-49
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Peter Harvey wrote:

> Those having problems unzipping file please try again.

Sorry man. Same problem. I downloaded again with wget ( direct connection ).
You're not running a reverse proxy or something?

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


------------=_1106888616-30490-49
Content-Type: text/plain; charset=us-ascii

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
------------=_1106888616-30490-49--

Looks fine now. Thanks!

> -----Original Message-----
> From: Peter Harvey [mailto:pharvey [at] mysql.com]
> Sent: Thursday, January 27, 2005 11:57 PM
> To: myodbc [at] lists.mysql.com
> Subject: Re: MyODBC 3.51.10-2-patch3
>
>
> Those having problems unzipping file please try again.
>
> >
> >WinZip gives error on this file: missing 1 bytes in Zip file ...
> >
> >
> >
> >
> >>http://www.peterharvey.org/Downloads/MySQL/MyODBC/MyODBC-3 .5
1.10-2-patch3.zip
>>
>>
>>


--
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=3Dartem.koltsov [at] wf=
inet.com

=A0
Attention:
Any views expressed in this message are those of the individual sender, e=
xcept where the message states otherwise and the sender is authorized to =
state them to be the views of any such entity. The information contained =
in this message and or attachments is intended only for the person or ent=
ity to which it is addressed and may contain confidential and/or privileg=
ed material. If you received this in error, please contact the sender an=
d delete the material from any system and destroy any copies.

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

Hello Peter,

I applied patch and run a test. It generates error 'No database selected'=
for linked tables and vb connections:

---------- Test ran:

Private Sub test()
Dim con As New ADODB.Connection, rs As ADODB.Recordset
con.Open "DRIVER=3D{MySQL ODBC 3.51 Driver};DESC=3D;DB=3Dtest;SERVE=
R=3Dxx.xx.xx.xx;UID=3Dtest;PASSWORD=3D;PORT=3D3306;SOCKET=3D ;OPTION=3D205=
0;STMT=3Dset time_zone=3D'-5:00';"
Set rs =3D con.Execute("SELECT count(*) from test")
Debug.Print "Test records: "; rs.Fields(0).Value
rs.Close
con.Close
Set rs =3D Nothing
End Sub

----------- Error produced:
Run-time error '-2147467259 (80004005)': No database selected

------------ Server info:
mysql> \s
--------------
mysql Ver 14.7 Distrib 4.1.8, for Win95/Win98 (i32)

Connection id: 11009
Current database: test
Current user: root [at] xx.xx.xx.xx
SSL: Not in use
Using delimiter: ;
Server version: 4.1.8-standard-log
Protocol version: 10
Connection: xxxxxx via TCP/IP
Server characterset: latin1
Db characterset: utf8
Client characterset: utf8
Conn. characterset: latin1
TCP port: 3306
Uptime: 18 days 12 hours 46 min 9 sec

Threads: 4 Questions: 217501 Slow queries: 26 Opens: 113 Flush tables=
: 3 Open tables: 62 Queries per second avg: 0.136


------------------ Table:

mysql> select * from test;
+----+------+---------------------+
| id | test | time_stamp |
+----+------+---------------------+
| 4 | A | 2005-01-10 18:48:21 |
| 5 | B | 2005-01-10 18:48:21 |
| 6 | A | 2005-01-10 18:48:49 |
| 7 | B | 2005-01-10 18:48:49 |
| 8 | 1 | 2005-01-11 17:26:46 |
| 9 | 2 | 2005-01-11 17:26:46 |
+----+------+---------------------+
6 rows in set (0.09 sec)

------------------- OS:
OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 2 Build 2600

Thanks!
Artem
=A0
Attention:
Any views expressed in this message are those of the individual sender, e=
xcept where the message states otherwise and the sender is authorized to =
state them to be the views of any such entity. The information contained =
in this message and or attachments is intended only for the person or ent=
ity to which it is addressed and may contain confidential and/or privileg=
ed material. If you received this in error, please contact the sender an=
d delete the material from any system and destroy any copies.

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

I ran this via DSNless connection with 10-2 patch3 installed and its
working. No catastrophic failure.

Thanks!

Shane

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