RE: W2K Network

2002-02-13 Thread Martin Jeremic
You need to set access privileges for SQL server. try with this : GRANT ALL PRIVILEGES ON database.tables TO [EMAIL PROTECTED] \g flush privileges \g mySQL prompt. Try also to delete password from DNS on client machine. (I'm maybe make a syntax error, look in mySQL manual for details).

show create table URGENT

2001-08-28 Thread Martin Jeremic
This is really stupid, but I can remember how to save results of SHOW CREATE TABLE tbl_name and SHOW COLUMNS FROM tbl_name in to text file. I'm running mysql 23.41 on Win2k. Thanks in advance -- Martin Jeremic mailto:[EMAIL PROTECTED] http

RE: MYODBC DSN creation

2001-07-23 Thread Martin Jeremic
When you create user DSN, it's created in Windows Registry, so there is no file. You can access that DSN from any application which use ODBC drivers. -- Martin Jeremic [EMAIL PROTECTED] http://solair.eunet.yu/~martinj/ http://jsoft.webjump.com

RE: mysql manager

2001-07-20 Thread Martin Jeremic
a program to create and manage a database with out being connected to a server Martin Jeremic [EMAIL PROTECTED] http://solair.eunet.yu/~martinj/ http://jsoft.webjump.com/ - Before posting, please check: http://www.mysql.com

RE: mysql.org

2001-07-19 Thread Martin Jeremic
First, I support mySQL and Open Source community. Maybe you can fight them with their own weapon. They have made some extra applications based on mySQL, and they sell it. You can create same applications as Open Source. -

UNICODE !!!

2001-05-16 Thread Martin Jeremic
When we can expect unicode version of mySQL for Win32 ? -- Martin Jeremic - JSoft http://jsoft.webjump.com/ mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Insert...Select...

2001-04-03 Thread Martin Jeremic
Can somebody tell me where i'm wrong ? insert into table3 select * from table1 where RecNo = 12 --- this works insert into table3 select * from table2 where RecNo = 12 --- Nothing Happens There are 3 fields in all tables, 2 LongText, and 'RecNo' - AutoIncrement Thanks in advance -- Martin

Re: Synchronization

2001-03-29 Thread Martin Jeremic
Yes, Thanks. I was looking for wrong Keyword. "Jeremy D . Zawodny" wrote: On Wed, Mar 28, 2001 at 05:22:56PM +0200, Martin Jeremic wrote: I have two mySQL servers, one is in office, and other at home. I need to synchronize then via DialUp TCP/IP connection (not Internet Di

Synchronization

2001-03-28 Thread Martin Jeremic
I have two mySQL servers, one is in office, and other at home. I need to synchronize then via DialUp TCP/IP connection (not Internet DialUp). Can somebody help me ? -- Martin Jeremic - JSoft http://jsoft.webjump.com/ mailto:[EMAIL PROTECTED

New Versions

2001-03-19 Thread Martin Jeremic
Can you put any warning that you plan to release new version few days before release ? I have downloaded 3.23.34, and when i visited mySQL.com on the next day, 3.23.35 was released. -- Martin Jeremic - JSoft http://jsoft.webjump.com/ mailto:[EMAIL PROTECTED

Large Numbers problem

2001-02-20 Thread Martin Jeremic
I have inserted 1234567890 in a float field. mySQL server rounded this to 123457. Then i have inserted 99 in same field, and tis was rounded to 100. Is this a bug or someyhing else? Field is declared as "field1 float" -- Martin Jeremic - JSoft http://jsoft.w