Hi,
I use the following to connect my application to the MySQL server:
Public ConnectionString As String = "driver={MySQL ODBC 3.51
Driver};server=localhost;uid=root;database=mydatabase"
As you can see the version of the Connector is 3.51. I use MySQL version
4.1.11.
Martin
>From: Gleb Paharenko <gleb.paharenko@stripped>
>To: mysql@stripped
>Subject: Re: AES_DECRYPT output
>Date: Fri, 26 Aug 2005 17:14:28 +0300
>
>Hello.
>
>How does your application connect to MySQL server (MyODBC or
>Connector/Net)? What versions of MySQL Server and Connector do you
>use?
>
>
>"M DR" <dhmderuitersql@stripped> wrote:
> > Hi,
> >
> > I'm currently using AES Encryption to encrypt some of my data (using it
>in a
> > ASP.NET application). As this is all text strings, I was wondering if
>there
> > is a possibility to automatically have the output in the ASP.NET String
> > format instead of the system.byte[] format, so I won't have to format
>every
> > item out of the database.
> >
> > For example a query like:
> >
> > SELECT AES_DECRYPT(Fieldname, '123') FROM Tablename ORDER BY Field_ID
> >
> > returns the system.byte[] format, while I'd like to see the String
>format as
> > output. Is this possible?
> >
> > Btw, the strange thing is, when I don't include a ORDER BY (or GROUP BY)
> > function, it already returns a String format. Any idea how this is
>possible?
> >
> > Thanks,
> >
> > Martin
> >
> > _________________________________________________________________
> > MSN Webmessenger doet het altijd en overal http://webmessenger.msn.com/
> >
> >
>
>
>--
>For technical support contracts, goto https://order.mysql.com/?ref=ensita
>This email is sponsored by Ensita.NET http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
>/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> <___/ www.mysql.com
>
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/mysql?unsub=1
>
_________________________________________________________________
Gebruik MSN Webmessenger op je werk en op school
http://webmessenger.msn.com/
