Re: MySQL OLE DB

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 =
"Provider=MySQLProv;SERVER=localhost;DB=ips;UID=buddy;PWD=buddy;PORT=3306"

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=server_name;DB=database_name;UID=user_name;PWD=password;PORT=port_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 password.
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

[email protected] wrote:
> 
> 
> Michael Louie Loria <[email protected]> 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
>>
> 
> <groan!!!>
> 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

-----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/7XExGJ0CKV4YP0
ICnMoG3hKuwz4hmRdT2ceSaH6Lf4pzihC1Sa9Wk2a1EmQN7fLyC7hBneW4U42pRv
MjyYPJuEeTz+M0N+V5mtwJctDrjrKHoARVEFJJcOh4D9TzzYaZOCLEJp/9OvM7HT
ytpKDayX2QAssIcSKv48kN3pvmuWicHE/MaxU2gH0tWPit9gouiNDIvyPsfialsU
nZPnUjrzy2jXGtsbppauWfuRiTqUhy/KTHS7OJNBLLJQhAvUzH05qiw1nnYKOsVL
gMxasvOR49HNvRVBXJe1N4HoObaXGhBbjIGcy9hUSICayf4uuLicUQ==
=+FFi
-----END PGP SIGNATURE-----