VB and MySQL

  • Thread starter Thread starter pbpolius
  • Start date Start date
P

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
 
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


(e-mail address removed) ha scritto:
 
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,

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

Ken
 
Back
Top