Re: LUCI Meeting Tuesday Agenda

[Danny Sauer <cloudmaster@cloudmaster.com>]

mysql.com gives "myODBC" - http://www.mysql.com/products/myodbc/

google gives this: myaccess - http://www.accessmysql.com/

I've used MyODBC as a backend with an MS Access frontend, and it works 
relatively well.  Access assumes that the backend is Jet/MS-SQL, though, 
so some data types don't convert well.  It's best to jsut write a client 
that interfaces with the database backend (those *are* two seperate things).

--Danny

Todd Davis wrote:

> You're right, there aren't a lot of MS Access-like clients for MySQL. 
> Fluid data-entry is a function for a client, not the database itself. 
> There is a program (pgaccess) that attempts to do an Access-like system
> for PostgreSQL, unfortunately I haven't seen anything similar for MySQL.
> 
> It's been a long time since I've done any type of work with Access, but
> isn't there a way to tell it that a field is a memo or longvarchar (or
> whatever they're calling it).  That may get you past the 255
> characters.  It may be an ODBC problem (again, it's been awhile).
> 
> 
> 
> 
> On Tue, 2003-05-13 at 15:11, John Wolgamot wrote:
> 
>>Erich Schroeder <erich@museum.state.il.us> wrote ..
>> 
>>
>>>  Along with the usual general discussions, I thought I would demonstrate
>>>the new features to phpMyAdmin, a general web-based interface to the 
>>>relational database MySQL.
>>
>>I was fooling around with MySQL and actually got somewhere with it.
>>
>>When I realized that MS Access had a limitation of 255 charactors in any given field. I couldn't figure a way around this limitation and I realized this wouldn't allow for the long descriptions I was going to need space for.
>>
>>So I started looking at MySQL and it didn't take me long to realize that manually setting up a database, tables etc... through the command line is restricted to aliens. (People with advanced minds)
>>
>>I looked at several MySQL GUI clients such as MySQL-Front as well as phpMyAdmin.
>>
>>So... I'm looking forward to this evenings demo and discussion.
>>
>>Ok now I'm just going to babble.
>>
>>phpMyAdmin looked extremely cool but the installation looked like a daunting task for a newbie like me so I set it aside until I could gain the experience to actually install it without screwing up my "working" server. I don't have the expertise to get the server working again in a timely manner if I mess it up too bad so I shy away from the stuff which appears to be too far over my head.
>>
>>In the MySQL quest I found that there doesn't seem to be a good data entry client. The clients seem to be geared towards maintenance of the databases rather than fast and fluid data entry.
>>
>>Most databases allow you to create data entry screens which allow the fluid entry of data and anticipate the users next move etc...
>>
>>In the case of MySQL it appears that the best way to get the data in is to do the data entry offline and then import it into MySQL.
>>
>>These are only my observatios as a newbie so I'm probably short sighted.
>>
>>
>>
>>
>>
>>-
>>To unsubscribe, send email to majordomo@luci.org with
>>"unsubscribe luci-discuss" in the body.


-
To unsubscribe, send email to majordomo@luci.org with
"unsubscribe luci-discuss" in the body.