RE: Access2k, Win98, NT4 and ODBC probs - Matthew Halliday - com.mysql.lists.win32

7 messages in com.mysql.lists.win32RE: Access2k, Win98, NT4 and ODBC probs

From	Sent On	Attachments
Matthew Halliday	25 Jul 2001 06:18
Joel Hughes	25 Jul 2001 06:24
Matthew Halliday	25 Jul 2001 07:09
Dennis Salguero	25 Jul 2001 07:25
Matthew Halliday	25 Jul 2001 07:33
Joel Hughes	25 Jul 2001 07:36
Dennis Salguero	25 Jul 2001 07:46

Subject:	RE: Access2k, Win98, NT4 and ODBC probs
From:	Matthew Halliday (matt...@johnstonpress.co.uk)
Date:	07/25/2001 07:33:53 AM
List:	com.mysql.lists.win32

without meaning to soung completely thick - how do I insert the path so the image shows in a database window along with details relevent to said image?

Regards

-----Original Message----- From: Dennis Salguero [mailto:den...@beridney.com] Sent: 25 July 2001 15:26 To: Matthew Halliday; MYSQL 32 Mailing List Subject: Re: Access2k, Win98, NT4 and ODBC probs

Matthew,

I have to agree with one of the earlier responses; I never store images in a database unless I absolutely have to. Not only will you encounter problems like yours, it also affects the performance of the database.

You are much better off simply storing a reference to the image (whether thats a network path or URL depends on your application).

If you do want to make a web interface to this (and it sounds like you should) you should begin to investigate either PHP or ASP. If you're already running Apache, you might be better off with PHP.

Good Luck,

Dennis ********************************************** Beridney Computer Services http://www.beridney.com

Hi - new to the list today.

I have a problem. MySQL runs on an NT4 PC and the clients are accessing it through linked tables in an Access 2000 front end. I'd like to use html but I'm no programmer, and don't have much time for this project anyway. It's my first project with MySQL (or any SQL come to that!).

I've converted a 2-table Access 2000 database to MySQL, and everything works ok except that one of the fields contains jpg images of about 20k. If I try to insert jpg's by right-clicking on the field and going to 'Insert Objct', then selecting the file - even if I just link it - I get an error message

Update on link failed [TCX][MyODBC]MySQL (#2006)

I have the latst versions of everything. If I insert a gif into the field, it updates ok. I also have a script that's from the MS web site that will add new images in - that works ok for new images, but I've lost 40 odd that were already there and need to put them back individually.

Can anyone help?

Many Thanks