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

Hi,

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

http://www.vb-tips.com/default.aspx?ID=68cb337e-bf53-4d41-a768-a3518a49b7a6

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

Cor


<pbpol***@gmail.com> schreef in bericht
Show quoteHide quote

Cor Ligthert [MVP] wrote:
We have many tips on our website...
Howdy Cor :-)

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

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. :-))

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/download.php?file=Downloads/Win32/MyOLEDB3.exe&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


pbpol***@gmail.com ha scritto:

Show quoteHide quote

Hi,

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

Ken
--------------------
<pbpol***@gmail.com> wrote in message
Show quoteHide quote

need to adjust some vb6 code - Scancode to Ascii - Please HELP!!
VB utilities??
*@#%! Graphics
Case Sensitive Comparison
make a CSV from a file name
Referenced object versus copy of object
Cause Checkbox to lose focus
user control dll missing DllRegisterServer
Accessing a Share Using Windows Credentials
Any way to disable a column in a DataGrid?