RE: W2K Network
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). -Original Message- From: Otto Saayman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 9:32 PM To: [EMAIL PROTECTED] Subject: W2K Network Hi there I have an Internal Network running MySQL with all machines running W2K. One of them has a VB Application which uses MyODBC to connect to another server running MySQL. The VB produces this error: Access Denied for username@vbappmachinename ... Using Password YES ... ODBC is set up with IP Address, port, username, password and as a System Data Source. No Machine Name. The VB App uses the System DS Name. This setup works fine if the VB App and MySQL server reside on the same machine. How do I get the other machine to work in the same way? Thank you Otto [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
show create table URGENT
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://solair.eunet.yu/~martinj/ ICQ# : 128620743 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYODBC & DSN creation
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/ -Original Message- From: David Rickerl [mailto:[EMAIL PROTECTED]] Sent: nedelja, 22. jul 2001 23:57 To: [EMAIL PROTECTED] Subject: MYODBC & DSN creation Have successfully installed MYODBC, driver shows up in Windows Control Panel, and when I try to add a new User DSN the setup screen appears. I add the info as outlined in the Mysql manual for 3.23.39 and everything appears ok, but I can't find the DSN when I want to connect to Mysql. Did a file find but no DSN was found. Then I tried to set up a File DSN, went through the same add steps but when I tried to save the DSN got message that the file could not be saved. Have re-installed MYODBC 2.50.37 full setup and tried again, same result. I have tried the above steps on two machines both running (successfully) Mysql 3.23.39 and get the same result on both machines. One machine is Win95 and one machine is Win98. I have exhausted my idea bank on what is happening. Any ideas from anyone else would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql manager
You can use Windows explorer to create new database (Not tables). Just create new subfolder of mysql\data on your system. -Original Message- From: Donald Dahlman [mailto:[EMAIL PROTECTED]] Sent: petak, 20. jul 2001 22:03 To: [EMAIL PROTECTED] Subject: mysql manager does anyone have 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.org
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Exporting Access database to Mysql database
You can use myODBC and Access Option "Get External Data" Siomara Pantarotto wrote: > Hi all, > > I got my java connection working but now I need to export a MS Access > database to mysql database. > > Does anyone knows the fastest way to do it > > My main question is: > > Is there a way to export the table structures and data at same time? Or do I > have to create the tables structures and just export the data. > > I noticed some diffreneces in the datatypes when comparing mySQL to Oracle > and I bet there must be some differences related to MSAccess too. > > Thanks > > Siomara > > _ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UNICODE !!!
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://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert...Select...
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 Jeremic - JSoft http://jsoft.webjump.com/ mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Synchronization
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 > > DialUp). Can somebody help me ? > > Does MySQL replication suit your needs? > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 328-7878 Fax: (408) 530-5454 > Cell: (408) 439-9951 -- Martin Jeremic - JSoft http://jsoft.webjump.com/ mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Synchronization
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] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stupid Question ?
Can somebody tell me how to save "SHOW VARIABLES" query into file ? -- Martin Jeremic - JSoft http://jsoft.webjump.com/ mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New Versions
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] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Large Numbers problem
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.webjump.com/ mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php