Locked Table Issue..

2006-08-28 Thread Thomas Trutt
Hello all... And thanks ahead of time for the help... I'm having an issue with a locked table... I have about 27 tables in MySQL Db that i am working with with multiple MS Access front ends.. The problem is one of my tables is locked, but only the first 400 records, the rest is fine... Any id

Re: Date Type Probelm

2004-10-06 Thread Thomas Trutt
Yep.. I tried a simpler query and it worked as well as working fine in MySQL Control Center as it is written here. The problem arose when I moved the DB from 4.1?? to 3.23.37, and that is when this showed up. I was wondering it is has to do with the way MySQL 3.23 is formating the date field, a

Date Type Probelm

2004-10-06 Thread Thomas Trutt
Hello all.. I'm running into a little bit of a problem.. I'm writing a program in VB.NET and every time i try to load query results into my dataset i keep getting: /An Unhandled Exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: Inconvertab

Re: Secure logon from VB.net

2004-09-22 Thread Thomas Trutt
27;t be of more help. Best Regards, Joe Thomas Trutt <[EMAIL PROTECTED]> wrote: Hi Joe, My understanding is, and please don't quite me on this one, is that it is a shared server.. If i'm right the server that my db will be running on also houses some large db's for our web ser

Re: Secure logon from VB.net

2004-09-21 Thread Thomas Trutt
then how do the other apps connect to it securely? Or is your app the only one that needs this level of security and other app can transmit to the db in clear text? Joe Audette Thomas Trutt <[EMAIL PROTECTED]> wrote: Thanks, Actually it is the transmission connection string he is worried

Re: Secure logon from VB.net

2004-09-21 Thread Thomas Trutt
ecrypt it before you connect. You'd have to use an encryption that can be decrypted with a key. Checkout the System.Security.Cryptography.DESCryptoServiceProvider class Hope that helps, Joe Audette Thomas Trutt <[EMAIL PROTECTED]> wrote: Hello all, Ok i know this may be a simple question

Secure logon from VB.net

2004-09-21 Thread Thomas Trutt
Hello all, Ok i know this may be a simple question but i need a little help. I am writing a program in VB.net that uses MySQL as a backend. My net admin wants the log on to be encrypted?? This is currently how i am connecting: Public LocalSYS As New OdbcConnection("DRIVER={MySQL ODBC

Encrypting Data???

2004-05-18 Thread Thomas Trutt
Hello everyone, Is there a way to have the data in a table encrypted so that the MYD file can't be opened with a text editor and read??? I need to encrypt or some how make illegible numeric, date, text, and vchar fields.. Any idea??? Thanks for the help, Tom T -- MySQL General Mailing List For

Re: AW: Convert MS Access to MySql

2003-12-22 Thread Thomas Trutt
question... does anyone know how it sets up the indexes, security preferences , relationships..??? I mean does it do this or does it just create the tables and upload the data??? Thanks Tom T At 06:01 PM 12/22/2003 +0100, you wrote: Arthur Get DBManager Professional (for free) here : http://w