Hi,
I have MyODBC 3.51.10 connecting to 4.1.8 server. When connecting to the =
server I am setting up connection's time zone using STMT in the connectio=
n string. For some reasons it is not working when put at the end of a con=
nection string, but works fine if put in the middle. Is it a bug or expec=
ted behavior?
Here is the example (server is set to GMT time):
Sub test()
Dim con As New ADODB.Connection, rs As ADODB.Recordset
con.Open "DRIVER=3D{MySQL ODBC 3.51 Driver};DESC=3D;DB=3Ddb;SERVER=3D=
10.1.1.1;STMT=3DSET TIME_ZONE=3D'-5:00';UID=3Duser;PASSWORD=3Dpassword;PO=
RT=3D3306;SOCKET=3D;OPTION=3D2050;"
Set rs =3D con.Execute("SELECT now()")
Debug.Print "STMT in the middle: "; rs.Fields(0).Value
rs.Close
con.Close
con.Open "DRIVER=3D{MySQL ODBC 3.51 Driver};DESC=3D;DB=3Ddb;SERVER=3D=
10.1.1.1;UID=3Duser;PASSWORD=3Dpassword;PORT=3D3306;SOCKET=3 D;OPTION=3D20=
50;STMT=3DSET TIME_ZONE=3D'-5:00';"
Set rs =3D con.Execute("SELECT now()")
Debug.Print "STMT at the end: "; rs.Fields(0).Value
rs.Close
con.Close
Set rs =3D Nothing
End Sub
Output:
STMT in the middle: 1/21/2005 7:58:59 PM
STMT at the end: 1/22/2005 12:58:59 AM
Thanks,
Artem Koltsov
Resource Management
Wireless Facilities, Inc.
=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
