MySQL OLE DB

--------------enigFD047ED432E49B844B5B3015
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello,

Is there a MySQL OLE DB connector?

Thanks,

Michael Louie Loria
LoRz Technology Solutions
http://www.lorztech.com


--------------enigFD047ED432E49B844B5B3015
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBRCCtWLXBHi2y3jwfAQpeGwf+OhzLXIPCWi4Iqdob9GvHziM7r21g oMhJ
XDBMgKxf4WeHfgvNk1IeC0NfnjiDYRRLT/1UhZf6KfdZgU1l5cE/ud24OXS7 v0+A
dv1Iza/jn7/0/nZTCN7NFHvqKQwE1Cih26AwpHUX8D7wBuL2yYyEhfolbPSQ ArEN
ALZQezirHE4gY7f/YULlVxlFa7BjZPt5RgKRqSxkxP4Fcj0gaTXL4PPa65c2 ZCt9
HC62vHEABl2BHzBq+cY8FV8ZwxXdkrcivNPmCO+nil+TktHvssgTbq+U05Dz i2qT
k0lO+T90nU6l8Y70Xtxfhvqsbj2FgGMa3JR6TuS76NCK8eRKT8tM2w==
=t2zl
-----END PGP SIGNATURE-----

--------------enigFD047ED432E49B844B5B3015--

Re: MySQL OLE DB

--------------enigA07EE327AD190EF0BDE9D91E
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

> yes
>
> search for "myoledb"

Thanks. got it

Michael Louie Loria
LoRz Technology Solutions
http://www.lorztech.com


--------------enigA07EE327AD190EF0BDE9D91E
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBRCESmrXBHi2y3jwfAQpMAgf+MwBDVyGheD8XFZ5fspOctnI4A1Ou +MXZ
zYGHP2Mx3cgYDd9CEwWFqsk30uWArjv3ETayPCT1HUZ45x7PFcVovddPuJAb w0+2
3RIwEC1tdH3n9HGc2CBd1/SqIHDPLFzob+96xtgmAXCUeLgM4tggDL8mhWXD Sgpq
/mjC/DZ97wR4GdI9gUbCB99ce1zLcRhX4WTcdQ17J7K04G672Ixce8BCqvJJ HO+A
R26flm4lukT7KUJKJVlNwVngK2UNKM5cqDSVA3g2g8lD7cGMfeHwrqgDOFQY ZY6j
KgafJFF7040zKZ52wBQ1f2O2H5iOnWRuIRhGI7wXkAGm2ZOWFQzwfQ==
=53pp
-----END PGP SIGNATURE-----

--------------enigA07EE327AD190EF0BDE9D91E--

Re: MySQL OLE DB

--------------enig6F435955D8557E154D1BFC69
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

> yes
>
> search for "myoledb"

Do you have a connection string for myoledb?

I have checked these but it doesn't work
http://www.mayukhbose.com/python/ado/ado-connection.php


Michael Louie Loria
LoRz Technology Solutions
http://www.lorztech.com


--------------enig6F435955D8557E154D1BFC69
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBRCJigrXBHi2y3jwfAQpxHAf/dyuIzVvNlw2z3+YFf0Uayi0YSHKn gNCx
kSfFsEIuf5mm50WC30oLJiTpl0qNoF5mY4Ux2+bBWjuyF2jUwA4qVvozK1wJ 4Vs1
60usw8iqSBzIyXZK7KFz4x4VhQY5BP5JqgEWjOSS80l/YQjNh1LKSLC/i1tR x5WW
c0jx9aAO03CL90HIZsUR7X4VDFqUcfX4KgRnYVdMA75UI1DrczI3EMgnZzVq M4TN
XK5vZG1fxrg0MwaVnHh3QfN6Hu0gCXVN6CzQF/V0ztSbYbQBZlUMWRfuiH3k tC2P
oAdiBCWupURfrt8NZKr2Y6oMaojDLDjq+NfxBdzMR2XoSXP+rBEIgA==
=osVM
-----END PGP SIGNATURE-----

--------------enig6F435955D8557E154D1BFC69--

Re: MySQL OLE DB

--=_alternative 0054FCEF8525713A_=
Content-Type: text/plain; charset="US-ASCII"

Michael Louie Loria wrote on 03/23/2006 03:55:26
AM:

> > yes
> >
> > search for "myoledb"
>
> Do you have a connection string for myoledb?
>
> I have checked these but it doesn't work
> http://www.mayukhbose.com/python/ado/ado-connection.php
>
>
> Michael Louie Loria
> LoRz Technology Solutions
> http://www.lorztech.com
>


Yet another "but it doesn't work" response. This is practically useless to
help us diagnose any problem you may be having. I could stick a key in a
car's ignition and turn it. If the engine doesn't start should I just
email a mechanic and say "it doesn't work" and expect a response with
instructions describing how to get the car working? Those of use on this
list can be compared to mechanics in the DB world. Until we understand the
issue, we have no chance of helping you through it.

We need to know what you have (hardware and OS), what version(s) you are
using (client and server), what you have tried (actual code snippets work
very well), and what error messages (if any) you are getting in response
to your efforts. Help us to help you.

Respectfully,

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 0054FCEF8525713A_=--

Re: MySQL OLE DB

--------------enigC29113F09C7F10E05CD1A4C4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

There's no need to bash

Pentium 3 with 512MB memory with CDROM
OS: Windows 2003 Language: Visual Basic 6 service pack 6 MDAC 2.8

Error Message
Run-time error '-2147467259 (800004005)';
Unspecified error

and clicking the Debug button would point to the connection string

Connection String
strconn =3D
"Provider=3DMySQLProv;SERVER=3Dlocalhost;DB=3Dips;UID=3Dbudd y;PWD=3Dbuddy=
;PORT=3D3306"

Error Message
I copied libmysql.dll and Myprov.dll provided by MyOLEDB to the
application path.

Here's the README.txt of MyOLEDB

------------------------------------------------
3. Getting Started
------------------------------------------------

Step 1. Download installation package, compile and install it on your
WinNT,
W2K or Win95/98/ME WORKSTATION.

Step 2. Find out the MySQL server name and name of database you are
going to
use. OLE DB / ADO connection parameters will be:

Provider: MySQLProv
Data Source:
SERVER=3Dserver_name;DB=3Ddatabase_name;UID=3Duser_name;PWD= 3Dpassword;PO=
RT=3Dport_number

OR

Provider: MySQLProv
Location: server_name
Data Source: database_name
User: user_name
Password: password

Default value 'localhost' (local computer) is used server_name is not
present.
Empty strings are default values for database_name, user_name and passwor=
d.
You may be not able to connect if you didn't specify the value.
Default value (3306) is used if port_number is omitted. Usually it's OK.

You may mix first and second ways to pass connection data, but it is not
recommended; In that case, you have to pass a parameter only once.

Step 3. Now you can use OLEDB provider against this database. E.g. using
Visual Basic ADO etc.

Mekaniko ka yata

SGreen@unimin.com wrote:
>=20
>=20
> Michael Louie Loria wrote on 03/23/2006 03:55:26=
AM:
>=20
>> > yes
>> >
>> > search for "myoledb"
>>
>> Do you have a connection string for myoledb?
>>
>> I have checked these but it doesn't work
>> http://www.mayukhbose.com/python/ado/ado-connection.php
>>
>>
>> Michael Louie Loria
>> LoRz Technology Solutions
>> http://www.lorztech.com
>>
>=20
>
> Yet another "but it doesn't work" response. This is practically useless=

> to help us diagnose any problem you may be having. I could stick a key
> in a car's ignition and turn it. If the engine doesn't start should I
> just email a mechanic and say "it doesn't work" and expect a response
> with instructions describing how to get the car working? Those of use o=
n
> this list can be compared to mechanics in the DB world. Until we
> understand the issue, we have no chance of helping you through it.
>=20
> We need to know what you have (hardware and OS), what version(s) you ar=
e
> using (client and server), what you have tried (actual code snippets
> work very well), and what error messages (if any) you are getting in
> response to your efforts. Help us to help you.
>=20
> Respectfully,
>=20
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine


--------------enigC29113F09C7F10E05CD1A4C4
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBRCM+tbXBHi2y3jwfAQrQaQf/UsbZqReUwAove5KBG/7XExGJ0CKV 4YP0
ICnMoG3hKuwz4hmRdT2ceSaH6Lf4pzihC1Sa9Wk2a1EmQN7fLyC7hBneW4U4 2pRv
MjyYPJuEeTz+M0N+V5mtwJctDrjrKHoARVEFJJcOh4D9TzzYaZOCLEJp/9Ov M7HT
ytpKDayX2QAssIcSKv48kN3pvmuWicHE/MaxU2gH0tWPit9gouiNDIvyPsfi alsU
nZPnUjrzy2jXGtsbppauWfuRiTqUhy/KTHS7OJNBLLJQhAvUzH05qiw1nnYK OsVL
gMxasvOR49HNvRVBXJe1N4HoObaXGhBbjIGcy9hUSICayf4uuLicUQ==
=+FFi
-----END PGP SIGNATURE-----

--------------enigC29113F09C7F10E05CD1A4C4--