RE: Access, ODBC, Oracle, MySQL

Robert, I have not worked for a while with Crystal Reports and I do not know if CR allows to go across different database type, and are you willing to spend the money on it, but for plain querying Crystal Reports works well using ODBC connections. CR works where MS-Access fails, because MS-Access

RE: database link

Hi Ananda, I am not sure what do you mean by connecting MySQL to Oracle: * Is it a permanent connection * Do you want to transfer data from one to the other * or ? Mikhail Berman -Original Message- From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Thursday, September 15, 2005 10:33

Loading database files fails on UNLOCK TABLES statement

Hi everyone, I am trying to load backup files into a database using a small script where an actual load command is: /usr/local/bin/mysql -ux -p -f secdocs -v -e source $dir2 and it is a part of loop that reads all files fro a directory. The load freezes at the same point, when at

RE: Loading database files fails on UNLOCK TABLES statement

31, 2005 12:44 PM To: Berman, Mikhail Cc: mysql@lists.mysql.com Subject: Re: Loading database files fails on UNLOCK TABLES statement Berman, Mikhail [EMAIL PROTECTED] wrote on 08/31/2005 12:35:19 PM: Hi everyone, I am trying to load backup files into a database using a small script where

RE: Multitable selection

Hi Mihail, We have nightly process that creates a summary table from multiple tables in the similar situation. Best, Mihail Berman -Original Message- From: Михаил Монашёв [mailto:[EMAIL PROTECTED] Sent: Sunday, July 17, 2005 3:41 AM To: mysql@lists.mysql.com Subject: Multitable

RE: MySQL Remote Connection?

Most of MySQL commands have --host option that allows you to address remote MySQL server. One needs: * To have MySQL server be running on all machines you want to reach * Each remote host must allow remote users, from your hosting server, to execute commands on that server. -Original

RE: mysqlshow question

To: Berman, Mikhail; mysql@lists.mysql.com Subject: Re: mysqlshow question Berman, Mikhail wrote: Hi everyone, My /usr/local/mysql/bin/mysqlshow --host=xxx--user=xxx --password= command hangs. I can ping host from local machine I can locally execute mysqlshow command on the host. I

mysqlshow question

Hi everyone, My /usr/local/mysql/bin/mysqlshow --host=xxx--user=xxx --password= command hangs. I can ping host from local machine I can locally execute mysqlshow command on the host. I can locally execute mysqlshow command on remote server My environment is UNIX with MySQL 4.1.xx

RE: simple data GUI editor?

Well, Actually MS-Access through ODBC should work for you -Original Message- From: D_C [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 4:28 PM To: mysql@lists.mysql.com Subject: simple data GUI editor? i was wondering if people can recommend a simple Excel like tool for

RE: How to load a remote db with lots of data?

Brian, How about an FTP service on your remote server? Mikhail Berman -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 10:01 AM To: mysql@lists.mysql.com Subject: How to load a remote db with lots of data? I have to load my remote MySQL

RE: How to load a remote db with lots of data?

Subject: Re: How to load a remote db with lots of data? On Jun 13, 2005, at 7:18 AM, Berman, Mikhail wrote: How about an FTP service on your remote server? No - I actually don't have any remote access directly to the MySQL server. My ISP has separate machines for the database servers

RE: email notification

Jayson, Are you working with Windows or UNIX versions of MySQL? Mikhail Berman -Original Message- From: Jayson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 9:59 AM To: mysql@lists.mysql.com Subject: email notification I'm looking for a feature in mysql where it will email me

Just a test

Mikhail Berman

RE: DB design question

Koon Yue Lam, If you running your MySQL on Windows, you may try to use one of the reporting tools, like Crystal Report, to create your reports. Generally these tools allow to hide repetitive data in its reports Mikhail Berman -Original Message- From: Koon Yue Lam [mailto:[EMAIL

RE: Where is mysql user/password list kept??

Michael, They, passwords, stored in mysql database that comes with every install of MySQL. Mikhail Berman -Original Message- From: Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 3:29 PM To: mysql@lists.mysql.com Subject: Where is mysql user/password list kept??

Is there a way

Hello everyone, I am looking for a way to dump a number of tables from mysql Ver 14.7 Distrib 4.1.9, for sun-solaris2.8 (sparc) into tabulated (csv) files with tables's column names being on the top of each data column, something like: IDColumn Name 1Column Name 2 1

RE: Is there a way

Atle, Thank you for your help Mikhail Berman Ives Inc (508)476-7007 ext.27 [EMAIL PROTECTED] -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 17, 2005 1:16 PM To: Berman, Mikhail Cc: mysql@lists.mysql.com Subject: Re: Is there a way SELECT

Is anyone aware of

Hi everyone, Is anyone aware of any differences on how joins work for: Ver 14.7 Distrib 4.1.10a, for sun-solaris2.9 (sparc) vs. Ver 11.13 Distrib 3.23.36, for sun-solaris2.7 (sparc) Regards, Mikhail Berman

RE: Is anyone aware of

We are having some problems with movement of data from v3.23 to v.4.1. What was working in lower version does not working in higher. Mikhail -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 2:06 PM To: Berman, Mikhail; mysql@lists.mysql.com

RE: Is anyone aware of

Thank you everyone for help. We have figure out differences in our scripts. They were NOT related to JOINs. Regards, Mikhail Berman -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 2:12 PM To: Berman, Mikhail; mysql@lists.mysql.com Subject

Does anyone have experience?

Hi, I am promoting this E-mail to larger list in hope to find people who can help me. Regards, Mikhail Berman -Original Message- From: Berman, Mikhail [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 9:57 AM To: [EMAIL PROTECTED] Subject: Does anyone have experience? Hi

RE: Does anyone have experience?

:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 10:39 AM To: Berman, Mikhail Cc: mysql@lists.mysql.com Subject: Re: Does anyone have experience? Berman, Mikhail [EMAIL PROTECTED] wrote on 04/28/2005 10:32:53 AM: Hi, I am promoting this E-mail to larger list in hope to find people who can

RE: Does anyone have experience?

: Thursday, April 28, 2005 11:41 AM To: Berman, Mikhail Cc: mysql@lists.mysql.com Subject: RE: Does anyone have experience? Berman, Mikhail [EMAIL PROTECTED] wrote on 04/28/2005 10:50:17 AM: Yes, I do test DSN connection itself. It returns Success. Connection was made. I am creating User DSN

RE: Does anyone have experience?

See inserts below From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 12:36 PM To: Berman, Mikhail Cc: mysql@lists.mysql.com Subject: RE: Does anyone have experience? OK, I am still confused. Let's run down the list of what's

RE: Does anyone have experience?

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 3:02 PM To: Berman, Mikhail Cc: mysql@lists.mysql.com Subject: RE: Does anyone have experience? Thank you for being so patient with me. What options does SigmaPlot give you when selecting an ODBC data source

RE: Does anyone have experience?

PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 3:27 PM To: mathias fatene Cc: Berman, Mikhail; mysql@lists.mysql.com Subject: RE: Does anyone have experience? MySQL is not listed in the screenshot because that is a sample screenshot provided by the **manufacturer**, not a screen

RE: host info

Brian, In UNIX from mysql prompt do: mysql system /bin/hostname Mikhail -Original Message- From: Stanton, Brian [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 11:03 AM To: 'mysql@lists.mysql.com' Subject: host info Does anyone know a function that will return the

RE: host info

Unfortunately, that gives me the host of the machine I'm connecting from, not the server I'm connecting to. Thanks, Brian Stanton -Original Message- From: Berman, Mikhail [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 10:28 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE

RE: host info

[mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:10 PM To: 'mysql@lists.mysql.com' Subject: RE: host info Using 4.0.18... connected from one unix box to another using mysql -h server -u user -p database Thanks, Brian Stanton -Original Message- From: Berman, Mikhail [mailto

RE: mysql table structures

A couple of apps: EMS MySQL Manager - http://sqlmanager.net/products/mysql/manager/ SQLyog - http://www.webyog.com/index.php Mikhail -Original Message- From: Mayuran Yogarajah [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 1:28 PM To: mysql@lists.mysql.com Subject: mysql

RE: Need Help with 813-MDB File

Is there a description of tables anywhere on CD-ROM for Access database. Mikhail -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 9:10 AM To: David Blomstrom; mysql@lists.mysql.com Subject: Re: Need Help with 813-MDB File - Original Message