VB and MySQL

[pbpolius]

I am using VB with Connector/NET to connect to a MySQL database. All
works fine except when I try to pass the connection string from the
login form to the main form. It appears that after testing the
connection with a quick 'conn.open' and 'conn.close' on the login form,
the password portion of the connection string is lost. Even before it
gets passed to the main form. How do I prevent this from happening?

Thanks

[Cor Ligthert [MVP]]

Hi,

We have 3 tips on our website about MySQL, this is one of those.

http://www.vb-tips.com/default.aspx?...8-a3518a49b7a6

It is not about your question, however it covers it enough in my opinion.

Cor
<pb******@gmail.com> schreef in bericht
news:11*********************@i40g2000cwc.googlegro ups.com...

I am using VB with Connector/NET to connect to a MySQL database. All
works fine except when I try to pass the connection string from the
login form to the main form. It appears that after testing the
connection with a quick 'conn.open' and 'conn.close' on the login form,
the password portion of the connection string is lost. Even before it
gets passed to the main form. How do I prevent this from happening?

Thanks

[tommaso.gastaldi]

Hi pbpolius,

I did the same some time ago and experienced similar problems.
Actually, there are so many problems with the OLE DB provider I used,
that at last it was almost unusable.

May I ask which OleDb provider are you using (a link). The one I used
is:

http://dev.mysql.com/downloads/downl...xe&pick=mirror

at the end, I had to give up with it. In particular, there seems to be
some major problem with the handling of char codes. Especially, if you
explore the OleDbschemaGuid, several strange chars appears within the
name of objects and when imported in VB they cause unexpected
truncation of the strings.

Let me know, I would like to share experiences to possibly solve these
problems... I think it's the OleDb driver fault. Do you know where we
can download alternative clients?

tommaso
pb******@gmail.com ha scritto:

I am using VB with Connector/NET to connect to a MySQL database. All
works fine except when I try to pass the connection string from the
login form to the main form. It appears that after testing the
connection with a quick 'conn.open' and 'conn.close' on the login form,
the password portion of the connection string is lost. Even before it
gets passed to the main form. How do I prevent this from happening?

Thanks

[dotNuttah]

Cor Ligthert [MVP] wrote:

Hi,
We have many tips on our website...
http://www.vb-tips.com

Cor

Howdy Cor :-)

I have ActiveX disabled in my browser and thus cannot access any tips. :-(

[dotNuttah]

ps. I wonder if you might like this version of your function.

function Ajax_GetXMLHttpRequest() {
try { return new XMLHttpRequest(); } catch (e) {}
try { return new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) {}
try { return new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) {}
return null;
}

It doesn't do anything differently, just looks cleaner. :-))

[Ken Tucker [MVP]]

Hi,

Could you please post some code on how you are passing the
connection string.

Ken
--------------------
<pb******@gmail.com> wrote in message
news:11*********************@i40g2000cwc.googlegro ups.com...

I am using VB with Connector/NET to connect to a MySQL database. All
works fine except when I try to pass the connection string from the
login form to the main form. It appears that after testing the
connection with a quick 'conn.open' and 'conn.close' on the login form,
the password portion of the connection string is lost. Even before it
gets passed to the main form. How do I prevent this from happening?

Thanks