Ynt: connect mysql to java and/or asp

2001-07-18 Thread Yusuf Incekara

For mysql and asp :
check
http://www.avukatpro.com/mysql.html




- Original Message -
From: Hasan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 12:40 PM
Subject: connect mysql to java and/or asp


> anyone can give me a scoop on how to connect mysql to java and/or asp?
>
> thanks
>
> -
> 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




Ynt: installing berkley db in windows

2001-07-18 Thread Yusuf Incekara

install mysql-max edition
and read mysql manual for required setting to run bdb.

- Original Message -
From: suharman <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 12:00 PM
Subject: installing berkley db in windows


> how to installing berkeley db in windows 98 with mysql 3.23.39?
>
> thx
>
>
>
> -
> 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




Ynt: VB?

2001-07-17 Thread Yusuf Incekara

yes :
check :
http://www.avukatpro.com/mysql.html

for Visual Basic & Mysql , Asp & Mysql , Mysql & Myodbc silent installation



- Original Message -
From: Evan James Dembskey <[EMAIL PROTECTED]>
To: Mysql <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 11:26 AM
Subject: VB?


> Hi,
>
>
> Is it possible to use Visual Basic to access a MySQL db running under NT?
>
>
> Regards,
>
> Jim
>
> -
> 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




Ynt: Slient install - Win32 Mysql

2001-07-17 Thread Yusuf Incekara

check :
http://www.avukatpro.com/mysql.html

for Visual Basic & Mysql , Asp & Mysql , Mysql & Myodbc silent installation


- Original Message -
From: Eyal Rif <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2001 6:06 PM
Subject: Slient install - Win32 Mysql


> Hi,
>
> I am trying to create a Mysql Install packages with other Programs (Such
as
> apache).
>
> Does any one know what registry keys need to be updated or how can I
perform
> a silent install of win32-mysql ?
>
>
> Thanks,
>
> -
> 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




Ynt: Unattended MyODBC installation

2001-07-02 Thread Yusuf Incekara

Try this :
myodbc silent installation merge module
http://www.avukatpro.com/mysql.html



- Original Message -
From: Tiago Luchini <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 3:58 PM
Subject: Unattended MyODBC installation


I need to provide MyODBC with one of my systems' installation. It would need
to be as smooth and simple as possible (completely unattended is preferred).

Does anyone know how to do this or where I could find some information?

Thanks a lot.

Atenciosamente,

Tiago Luchini
Diretor Técnico-Comercial
Galluch Soluções Internet
Telefax: 11 6912 3255
Celular: 11 3176 7740
http://www.galluch.com.br/



-
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




Ynt: How to connect Mysql with vb6 applications?

2001-07-02 Thread Yusuf Incekara

try this :
Mysql & VB6

http://www.avukatpro.com/mysql.html


- Original Message -
From: Tiago Luchini <[EMAIL PROTECTED]>
To: Gopal Saha <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 2:56 PM
Subject: Re: How to connect Mysql with vb6 applications?


> Easy solution: download MyODBC from mysql.com
>
> Atenciosamente,
>
> Tiago Luchini
> Diretor Técnico-Comercial
> Galluch Soluções Internet
> Telefax: 11 6912 3255
> Celular: 11 3176 7740
> http://www.galluch.com.br/
> -Original Message-
> From: Gopal Saha <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Monday, July 02, 2001 7:45 AM
> Subject: How to connect Mysql with vb6 applications?
>
>
> Hi,
> I am a Vb programmer wants to connect with Mysql database please suggest
me.
> I have download Mysql for windows95 .
> My mail address is [EMAIL PROTECTED]
> Thanks,
> Sougata
>
>
>
> -
> 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




Ynt: Connecting to MySQL w/VB

2001-06-29 Thread Yusuf Incekara

see this :
About mysql & vb6

http://www.avukatpro.com/mysql.html


- Original Message -
From: Dennis Salguero <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 6:03 AM
Subject: Re: Connecting to MySQL w/VB


> - Original Message -
> From: "Robert Skinner" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 28, 2001 7:44 PM
> Subject: Connecting to MySQL w/VB
>
>
> > I am trying to connect to MySQL using a connection string using VB6.
The
> > read part is great but I don't seem to be able to add records.  Can
anyone
> > steer me in the right direction?
>
> A bit more information might help us help you. If you the db reads work
> fine, then you at least have the connection made - that's already half-way
> there! I have done extensive work with MySQL and VB/VBScript, but if you
can
> execute a SELECT query (as your e-mail indicates) I don't see how you
would
> have problems executing an INSERT query (assuming the SQL statement is
> valid).
>
> What exactly seems to be the problem?
>
> Good Luck,
>
> Dennis
> **
> Beridney Computer Services
> http://www.beridney.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




Ynt: Mysql via ODBC

2001-06-28 Thread Yusuf Incekara

i don't know how to change registry for ODBC DSN settings in
Clarion but in Visual Basic you may easily do it via WINAPI functions.
If you interested i may send you the required vb codes.

Yusuf INCEKARA


- Original Message -
From: Amanda <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 12:34 PM
Subject: Mysql via ODBC


Hi,

I am trying to access a mysql unix database from Clarion.
Setting up the database throgh ODBC Administrator and then accessing through
Clarion is Fine. However depending on selections mad by the User we need to
connect to a different MySQL database. Claion suggessted creating a file DSN
to get the parameter settings. However whenever i try to create a file DSN a
get "file not saved". Where else can i get the names of the attibutes to set
up the ODBC srouce programatically. Is there a windows API function to
change/setup DSN?
Any advice would be greatfully accepted,
Thanks,
Amanda Weddell.



-
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 via ODBC

2001-06-28 Thread Yusuf Incekara

The informations about ODBC DSN are stored in registry
HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/yourdsn/
server , user , port , password etc.
You may change this values when needed.
Regards

Yusuf INCEKARA

- Original Message -
From: Amanda <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 12:34 PM
Subject: Mysql via ODBC


Hi,

I am trying to access a mysql unix database from Clarion.
Setting up the database throgh ODBC Administrator and then accessing through
Clarion is Fine. However depending on selections mad by the User we need to
connect to a different MySQL database. Claion suggessted creating a file DSN
to get the parameter settings. However whenever i try to create a file DSN a
get "file not saved". Where else can i get the names of the attibutes to set
up the ODBC srouce programatically. Is there a windows API function to
change/setup DSN?
Any advice would be greatfully accepted,
Thanks,
Amanda Weddell.



-
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




Ynt: How to config the client installation

2001-04-25 Thread Yusuf Incekara

add % line to your grants.
that means this user can connect from everywhere.
read mysql documents Section 6.13 for detail instructions.

shell> mysql --user=root mysql
mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
mysql> INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
mysql> INSERT INTO user SET Host='localhost',User='admin',
 Reload_priv='Y', Process_priv='Y';
mysql> INSERT INTO user (Host,User,Password)
VALUES('localhost','dummy','');
mysql> FLUSH PRIVILEGES;



- Original Message -
From: johnd <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 25, 1999 10:23 PM
Subject: How to config the client installation


Hi,
I installed the Win32 static binary of MySQL GUI 1.7.4-2. client version on
one computer.
I have also MySQL 3.23.37 mysqld-nt server installed on another computer. I
can ping each other.
I tried to connect from client to server, but failed. Error shows: Access
denied for user: 'administrator@JOHND' (Using password: YES)

Here is server side my.ini file:
#This File was made using the WinMySQLadmin 1.1 Tool

#4/24/2001 12:04:36 PM

#Uncomment or Add only the keys that you know how works.

#Read the MySQL Manual for instructions

[mysqld]

basedir=D:\MySQL

#bind-address=208.199.176.191

datadir=D:\MySQL\data

#language=D:\MySQL\share\your language directory

#slow query log#=

#tmpdir#=

port=3306

#set-variable=key_buffer=16M

[WinMySQLadmin]

Server=D:/MySQL/bin/mysqld-nt.exe# I tried to replace the "/"  instead
of "\", it can't do it.

user=administrator@johnd # This is the computer that
client software installed.

password=password

Could you tell me how to configue these on both side to get connect?
Thank you very much.

Regards,

John Ding



-
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




İlt: About Last Insert ID and Getting Column Names

2001-04-25 Thread Yusuf Incekara


- Original Message - 
From: Yusuf Incekara 
To: [EMAIL PROTECTED] 
Sent: Wednesday, April 25, 2001 2:50 PM
Subject: About Last Insert ID and Getting Column Names


I created a Visual Basic Project that uses Last insert id function and 
getting column names.
Working properly. 

Anyone interested please mail me. 

Regards 
Yusuf Incekara



Stupid robot : database,sql,query




Re: Run time version of MySQL

2001-04-19 Thread Yusuf Incekara

Well it is exactly depends on who you are , what are you doing ,
on which platform , for which purposes etc...


- Original Message -
From: johnd <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 6:40 PM
Subject: Run time version of MySQL


Hi,

We are planning to move on to MySQL.
Could you send us your opinions about MtSQL. It will greatly help us to make
decision and to use MySQL.

Thanks.

Regards,

John Ding




-
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




Ynt: Plase Let us know if there is a Racialism for Mysql product and quit

2001-04-19 Thread Yusuf Incekara

Dear René ,

First of all i apologize from all mysql list and
all mysql team (except one :)   )
I think this is a virtue that realizing when to stop and when to apologize.

your product and your documentation works fine
and i am not directly blaming anyone related to this product.
The problem is not in documentation nor in product.

well like i said in my last mail this situation is become too personal
between two person.
That's why i am stoping to write about this subject.

you 're 100%  right in your mail
and again sorry for wasted time for all list members.
Regards.

Yusuf Incekara

- Original Message -
From: René Tegel <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>; John Dean <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 11:18 AM
Subject: Re: Plase Let us know if there is a Racialism for Mysql product and
quit


> Yusuf,
>
> i don't understand why you are so angry and are trying to fight it out on
> this list.
>
> 1. Loads of computer-related things are vulnerable for different
> explanations. especially with software that is easily ported between
> platforms, it's also easy to have a manual that is not dedicated for one
> platform and thus now and then one makes mistakes in interpration. There
> will be thousands of other things to discuss about, but there is never
> reason to get angry
>
> 2. All people joining this list are volunteers. They answer just what they
> think, and i never discovered somebody being not honest. Maybe somebody is
> wrong, but we all make mistakes. Every sentence said is the author's
> personal knowledge and/or opinion.
>
> 3. Nobody ever blamed you for not being native english. Only thing said
was:
> read carefully, and if it's not working, think twice about what's being
> said.
>
> 4. I'd love it if all software was that well documented as mysql, and that
> easy-to-use
>
> Last but not least: i hope you have a nice time programming and
researching,
> which looks like a better thing to do for me than wasting your time
blaming
> people for things nobody really did wrong. Let's discuss things
technically,
> ok?
>
> regards,
>
> rene
>
> - Original Message -
> From: "Yusuf Incekara" <[EMAIL PROTECTED]>
> To: "John Dean" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, April 19, 2001 9:49 AM
> Subject: Re: Plase Let us know if there is a Racialism for Mysql product
and
> quit
>
>
> > - Original Message -
> > From: John Dean <[EMAIL PROTECTED]>
> > To: Yusuf Incekara <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 18, 2001 10:39 PM
> > Subject: Re: Plase Let us know if there is a Racialism for Mysql product
> and
> > quit
> >
> >
> > > At 18:50 18/04/2001 +0300, you wrote:
> > > >You said :
> > > >Only those who don't read English too good. Being a native English
> > speaker
> > > >it is very clear to me.
> > >
> > > Correct and it is obvious to me that your English is very poor
> > >
> > It is your humble opinion. I don't care.
> > >
> > >
> > > >Could you please be more open and honest?
> > >
> > > I could not be more open or honest than what I said above. But just in
> > case
> > > you don't understand I will say it again. Your English is poor
> > >
> > It is your humble opinion. I don't care also.
> > The problem is not in reading and understanding
> > in English.  Problem is in your mind.
> > Let me try to explain. Question is about being open and honest.
> > That means if you have an opinion you can easily defend this opinion in
> > everywhere.
> > And have to tell this in every platform as your opinion.
> > If theese opinions are rude so you are rude. But this is you are.
> > Act what you are and what you seems like.
> > But don't try to hide them and don't act in different platform in
> different
> > ways.
> >
> > > >It is obviously seen that i can easily read and write in English.
> > >
> > > Only you think so
> > >
> > > >But if you disturbed that one Turk found your bug please let me know
> > > >and quit .
> > >
> > > Personally I could not care less from which country you come from
> > >
> > > >Let all your customers become from Mansfield, England, UK.
> > >
> > > Look what you said above. That sentence does not make sense. What do
you
> > > mean, "Let all your customers become from Mansfield " You are not
> e

Re: Plase Let us know if there is a Racialism for Mysql product and quit

2001-04-19 Thread Yusuf Incekara

- Original Message -
From: John Dean <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 10:39 PM
Subject: Re: Plase Let us know if there is a Racialism for Mysql product and
quit


> At 18:50 18/04/2001 +0300, you wrote:
> >You said :
> >Only those who don't read English too good. Being a native English
speaker
> >it is very clear to me.
>
> Correct and it is obvious to me that your English is very poor
>
It is your humble opinion. I don't care.
>
>
> >Could you please be more open and honest?
>
> I could not be more open or honest than what I said above. But just in
case
> you don't understand I will say it again. Your English is poor
>
It is your humble opinion. I don't care also.
The problem is not in reading and understanding
in English.  Problem is in your mind.
Let me try to explain. Question is about being open and honest.
That means if you have an opinion you can easily defend this opinion in
everywhere.
And have to tell this in every platform as your opinion.
If theese opinions are rude so you are rude. But this is you are.
Act what you are and what you seems like.
But don't try to hide them and don't act in different platform in different
ways.

> >It is obviously seen that i can easily read and write in English.
>
> Only you think so
>
> >But if you disturbed that one Turk found your bug please let me know
> >and quit .
>
> Personally I could not care less from which country you come from
>
> >Let all your customers become from Mansfield, England, UK.
>
> Look what you said above. That sentence does not make sense. What do you
> mean, "Let all your customers become from Mansfield " You are not even
> a customer you are just an upset user who can not take the truth

Well the truth is situation is not about my English or not about me to pay
license fee.
The problem is about you are harding to accept you fault.
So i solved my problem. And just don't want others users to have same
problem.
That's all.

>
>
> >I am not insisting that my English is perfect. But be sure that
> >it is not necessary that being a native English speaker.
> >
> >I said that no matter but you are looking for a trouble ...
>
> Only you say that because you must have some kind of persecution complex
or
> inferiority complex

Well it must be a complex of yours and i think it can be named
insufficient understanding complex , harding to accepting you fault complex
,
(thinking) faultless complex , individuality complex etc...

>
>
> >If you read carefully followed instructions ( by using your perfect
native
> >English )
> >you 'll see the differences between Windows directory and System
Directory.
>
> I am perfectly aware of the difference but it is obvious you don't what is
> meant by what is written in the manual. Windows-system-directory does not
> equal windows\system. The give away are the hyphens i.e '-' between the
> words windows, system and directory. Note it does not contain any
> backslashes i.e. '\'
>
>
well it is more obvious that
Windows-system-directory is not equal Windows directory.
Any Windows programmer - as well as noticed in Microsoft References-
knows that Windows Directory is a c:\Win95 or c:\WinNT and
System Directory or Windows System Directory is a c:\Win95\System or
c:\WinNT\System32 (or c:\WinNT\System or whatever).
And this situation becomes more personal. That'y why
i won't reply any mail. I hope this will be the last...


> >If still there is some issues that your perfect English mind can not
> >understand
> >please mail me.
>
> I have no the consult you whatever on any issue concerning Windows or the
> Windows API
>
>
> >If you say still i am native English. No one can knows better then me
even
> >Microsoft
> >so there is nothing to say.
>
> I think you need to return to school since it is obvious you were not
> taught manners and while you are there perhaps you improve your poor
Engliah
>
Well i can easily understand what i read in English by using my poor
English.
But it is hard you to be success in your life with your poor personality.
You should better go to a psychiatrist.
>
> >If you undertand your mistake and wanna apologize please forget it.
>
> This I would never do especially to somebody as bad mannered as you
>
>
> >Regards.
> >
> >Yusuf Incekara
> >Avukatpro Limited Sirketi
> >Izmit/Turkey (sorry for not being a native English but smart)
>
> No you not naive English nor are you smart
>
Thanks god for not to be a native English (if they are all like you)
and thanks also giving us a gift that does not exist on them ?

(yo

Plase Let us know if there is a Racialism for Mysql product and quit

2001-04-18 Thread Yusuf Incekara

You said :
Only those who don't read English too good. Being a native English speaker
it is very clear to me.


Could you please be more open and honest?

It is obviously seen that i can easily read and write in English.
But if you disturbed that one Turk found your bug please let me know
and quit . Let all your customers become from Mansfield, England, UK.

I am not insisting that my English is perfect. But be sure that
it is not necessary that being a native English speaker.

I said that no matter but you are looking for a trouble ...

If you read carefully followed instructions ( by using your perfect native
English )
you 'll see the differences between Windows directory and System Directory.

If still there is some issues that your perfect English mind can not
understand
please mail me.

If you say still i am native English. No one can knows better then me even
Microsoft
so there is nothing to say.

If you undertand your mistake and wanna apologize please forget it.

Regards.

Yusuf Incekara
Avukatpro Limited Sirketi
Izmit/Turkey (sorry for not being a native English but smart)




GetSystemDirectory

Reference : Microsoft Web site :
http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_1unt.htm

The GetSystemDirectory function retrieves the path of the system directory.
The system directory contains such files as dynamic-link libraries, drivers,
and font files.

UINT GetSystemDirectory(
  LPTSTR lpBuffer,  // buffer for system directory
  UINT uSize// size of directory buffer
);
Parameters
lpBuffer
[out] Pointer to the buffer to receive the null-terminated string containing
the path. This path does not end with a backslash unless the system
directory is the root directory. For example, if the system directory is
named WINDOWS\SYSTEM on drive C, the path of the system directory retrieved
by this function is C:\WINDOWS\SYSTEM.
uSize
[in] Specifies the maximum size of the buffer, in TCHARs. This value should
be set to at least MAX_PATH.
Return Values



GetWindowsDirectory

Reference : Microsoft Web site :
http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_4k55.htm


GetWindowsDirectory
The GetWindowsDirectory function retrieves the path of the Windows
directory. The Windows directory contains such files as applications,
initialization files, and help files.

UINT GetWindowsDirectory(
  LPTSTR lpBuffer,  // buffer for Windows directory
  UINT uSize// size of directory buffer
);
Parameters
lpBuffer
[out] Pointer to the buffer to receive the null-terminated string containing
the path. This path does not end with a backslash unless the Windows
directory is the root directory. For example, if the Windows directory is
named WINDOWS on drive C, the path of the Windows directory retrieved by
this function is C:\WINDOWS. If the system was installed in the root
directory of drive C, the path retrieved is C:\.
uSize
[in] Specifies the maximum size, in TCHARs, of the buffer specified by the
lpBuffer parameter. This value should be set to MAX_PATH to allow sufficient
room for the path.





- Original Message -
From: John Dean <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 10:11 AM
Subject: Re: Ynt: Bug in Documentation ?


> At 09:29 18/04/2001 +0300, you wrote:
> >Ok . No matter for me anymore. cause i solved my problem.
> >i'm paying attention for other users not to have
> >the same problem.
>
> Only those who don't read English too good. Being a native English speaker
> it is very clear to me
>
> >Regards
> >Yusuf Incekara
> >
> >
> >- Original Message -
> >From: John Dean <[EMAIL PROTECTED]>
> >To: Yusuf Incekara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> >Sent: Tuesday, April 17, 2001 9:27 PM
> >Subject: Re: Bug in Documentation ?
> >
> >
> > > Hi
> > > This is not a "bug" in the documentation, it is the way you have
> > > interpreted what it says
> > > On a Win9x/ME system the Windows-System-Directory is called x:\Windows
but
> > > in Windows NT and Windows 2000 it is called WinNT. If the author meant
to
> > > write windows(winnt)\system that is what he would have written, not
> > > windows-system-directory. So I am sorry to say it is you that is wrong
not
> > > the documentation writer.
> > >
> > > At 10:00 17/04/2001 +0300, Yusuf Incekara wrote:
> > > >in Mysql documents
> > > >section 4.16.5 Options files
> > > >it is documented as :
> > > >
> > > >MySQL reads default options from the following files on Windows:
> > > >
> > > >Filename  Purpose
> > > >windows-system-directory\my.ini   Global options
> > > >C:\my.

Ynt: Bug in Documentation ?

2001-04-17 Thread Yusuf Incekara

Ok . No matter for me anymore. cause i solved my problem.
i'm paying attention for other users not to have
the same problem.
Regards
Yusuf Incekara


- Original Message -
From: John Dean <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 9:27 PM
Subject: Re: Bug in Documentation ?


> Hi
> This is not a "bug" in the documentation, it is the way you have
> interpreted what it says
> On a Win9x/ME system the Windows-System-Directory is called x:\Windows but
> in Windows NT and Windows 2000 it is called WinNT. If the author meant to
> write windows(winnt)\system that is what he would have written, not
> windows-system-directory. So I am sorry to say it is you that is wrong not
> the documentation writer.
>
> At 10:00 17/04/2001 +0300, Yusuf Incekara wrote:
> >in Mysql documents
> >section 4.16.5 Options files
> >it is documented as :
> >
> >MySQL reads default options from the following files on Windows:
> >
> >Filename  Purpose
> >windows-system-directory\my.ini   Global options
> >C:\my.cnf  Global options
> >C:\mysql\data\my.cnf Server-specific options
> >
> >windows-system-directory\my.ini  Global options  line is incorrect
> >
> >
> >it must be corrected as : windows-directory\my.ini  ?
> >Cause when i try to use my.ini option file which is located in
> >c:\windows\system directory it doesn't works.
> >But when i put it into a c:\windows directory it works fine.
> >
> >Regards.
> >Yusuf INCEKARA
> >Avukatpro Limited Sirketi
>
> Regards
> John
>
> --
>
> MySQL Development Team
> __  ___  __   __
>/  |/  /_ __/ __/ __ \/ /   John Dean <[EMAIL PROTECTED]>
>   / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
> /_/  /_/\_, /___/\___\_\/ Mansfield, England, UK
> <___/
>
>
>
>
>
>
>
>
>
> -
> 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




Bug in Documentation ?

2001-04-16 Thread Yusuf Incekara

in Mysql documents 
section 4.16.5 Options files 
it is documented as : 

MySQL reads default options from the following files on Windows: 

Filename  Purpose  
windows-system-directory\my.ini   Global options  
C:\my.cnf  Global options  
C:\mysql\data\my.cnf Server-specific options  

windows-system-directory\my.ini  Global options  line is incorrect


it must be corrected as : windows-directory\my.ini  ? 
Cause when i try to use my.ini option file which is located in
c:\windows\system directory it doesn't works. 
But when i put it into a c:\windows directory it works fine. 

Regards. 
Yusuf INCEKARA
Avukatpro Limited Sirketi







Re: www.kwwda.org

2001-04-15 Thread Yusuf Incekara

try
http://www.avukatpro.com/mysql.html

mysql & asp section. if you use asp


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 15, 2001 10:01 AM
Subject: www.kwwda.org


> DEAR sir,
> I WANT TO connect mysql database to my web site www.kwwda.org.i read the
tutorials as well still i find it difficult to understand how to get started
kindly help.
> asif
> www.kwwda.org
>
> -
> 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




MyOdbc Silent Install

2001-04-12 Thread Yusuf Incekara

Dear Res Rickli , Victor , David Brieck , Joachim Klein, Gerald R. Jensen,
Edward Apostol , Lee Jenkins ...

Thanks for interesting Myodbc Silent Install Merge Module.
Due to i get too many copy request and because of the merge module 's size
(3,5 MB)
i have to put it on a web page.
Scripts are ready , so clear and error free.
I am now trying to writing web page.
I will put both merge modules and spesifications.
Then if you want to use my merge module download mine  or
you may create your own merge module if you prefer by using theese
spesifications.

I think page will be ready on saturday.

Regards.

Yusuf Incekara
Avukatpro Limited Sirketi


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 10:41 AM
Subject: myODBC setup


> Dear Yusuf,
> I am very much interested in your myODBC setup. I think it fills a gap in
> the otherwise nice mySQL world.
>
> Thank you for your work!
> Res Rickli
> [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




Ynt: ms frontpage

2001-04-12 Thread Yusuf Incekara

try to create a odbc dsn using myodbc. 

- Original Message - 
From: ilker YILDIZ <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 11:40 PM
Subject: ms frontpage


Hi,
I want connect mysql databse with ms front page 200.
How?
What do i?
Thanks.



-
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: getting ip of mysql server

2001-04-12 Thread Yusuf Incekara

There is some free codes on the web which written in different languages
that
queries subnet and mysql's standart port on each of theese possible clients.
I mean ping machines first on the subnet. then query port 3306 . if replies
then
try to connect . if connect it works. I have one written with IPWorksV4 on
MSVB6.

Regards.
Yusuf Incekara


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 12:03 AM
Subject: getting ip of mysql server


> Hi there,
>
> I'm wondering if there's a way to findout the IP of the server that MySQL
is running on, once
> logged into MySQL. I know this may seem simple, but I'm looking for
something beyond
> ping somehost.com
> Is there someway to get the ip needed to connect to a mysql database
remotely from MySQL?
> Thanks for any help!
> Jack Dempsey
>
>
>
> -
> 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




İlt: About BDB and INNOBASE

2001-04-10 Thread Yusuf Incekara

this is a stupid robot :)
my message was not off topic

- Original Message -
From: <[EMAIL PROTECTED]>
To: Avukatpro Limited Sirketi <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 12:09 AM
Subject: Re: About BDB and INNOBASE


> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query
>
> If you just reply to this message, and include the entire text of it in
the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. You have written the following:
>
>
> Is it possible to work with INNOBASE and BDB on Win32 in some way?
> If possible how ?
> If not when will you be implement in near future?
> If yes when?
>
>
> Yusuf Incekara
> Avukatpro Limited Sirketi
>
>
>
>


-
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




BDB and Innobase

2001-04-10 Thread Yusuf Incekara

does mysql binary win32 dist  support innobase and bdb tables. 
if yes how ?
if not when will you implement?

 
database. 
Yusuf Incekara



-
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 Server&Client& Myodbc Silent installation successfully completed

2001-04-09 Thread Yusuf Incekara

the page must be :
http://www.avukatpro.com/mysql.html

but i really don't know this is included as my signature and
this page contains mysql and visual basic samples.
not included about silent install yet.
Regards.
Yusuf INCEKARA



- Original Message -
From: John Steele <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>
Sent: Sunday, April 08, 2001 9:39 PM
Subject: Re: Mysql Server&Client& Myodbc Silent installation successfully
completed


> Hello,
>
>   I would be interested in a copy.  Do you have it available from a
website or ftp machine?  BTW, your link in your signature returns a
directory listing denied page (www.avukatpro.com/mysql).
>
> John
>
> At 4/8/2001 09:13 AM, you wrote:
> >I have created a setup program using Wise Windows Installer Professional
3.0
> >.
> >I also create a merge module. It can distribute mysql odbc driver
> >and set it installed ot target windows system  by using odbcinst.ini and
> >odbc ini and required
> >registry key.
> >My setup uses that merge module and distribute out
> >commercial software , mysqlserver , mysql client , myodbc with odbc2.5
and
> >3.0 support ,
> >creates a required dsn etc... by using just one install button :)
> >And it works perfect.
> >
> >If anyone need this please mail me.
> >If i get too many mail i will put theese subject on our company web page.
> >
> >
> >Regards.
> >Yusuf Incekara
> >Avukatpro Limited Sirketi
> >http://www.avukatpro.com/mysql
> >
> >
> >
> >
> >
> >-
> >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
>
> --
> /* SteeleSoft Consulting  John Steele - Systems Analyst/Programmer
>  *  We also walk dogs...  PHP/MySQL/Linux/Hosting - [EMAIL PROTECTED]
>  *http://www.steelesoftconsulting.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




Mysql Server&Client& Myodbc Silent installation successfully completed

2001-04-07 Thread Yusuf Incekara

I have created a setup program using Wise Windows Installer Professional 3.0
.
I also create a merge module. It can distribute mysql odbc driver
and set it installed ot target windows system  by using odbcinst.ini and
odbc ini and required
registry key.
My setup uses that merge module and distribute out
commercial software , mysqlserver , mysql client , myodbc with odbc2.5 and
3.0 support ,
creates a required dsn etc... by using just one install button :)
And it works perfect.

If anyone need this please mail me.
If i get too many mail i will put theese subject on our company web page.


Regards.
Yusuf Incekara
Avukatpro Limited Sirketi
http://www.avukatpro.com/mysql





-
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: free admin/client gui for win32

2001-04-06 Thread Yusuf Incekara

i recommend dbtools 1.0.8 for windows
available for download on mysql download pages.



- Original Message -
From: Spirit <[EMAIL PROTECTED]>
To: Kevin Xin Lin <[EMAIL PROTECTED]>
Cc: mysql <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 9:01 AM
Subject: Re: free admin/client gui for win32


> Hello Kevin,
>
> Friday, April 06, 2001, 1:07:48 AM, you wrote:
>
> KXL> Can any one share with me a good free admin/client GUI for win32?
>
> It  looks  like  there  is no such thing at all. Artronic is extremely
> slow  and  buggy.  TcX's  GUI  client  is noting more than a graphical
> version of console client (that is it doesn't automate anything, you
> still  have  to write queries manually), it doesn't use standard Win32
> controls  but  instead  has  some  proprietary  ugly-beyond-all-limits
> ones. Other GUI clients are no better. :(
>
> P.S. I use Artronic.
>
> Best regards,
>  Spiritmailto:[EMAIL PROTECTED]
>
>  =
>  Reactor Critical: the best 3D Hardware related resource in Russia
>  http://www.reactor.ru  - in Russian
>  http://www.reactorcritical.com - in English
>  =
>
>  -
>  Nothing works the way it was programmed. Nothing is programmed the way it
should work.
>  -
>
>
>
> -
> 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




Documents & Spesifications Does Not Match

2001-03-27 Thread Yusuf Incekara

Tha instructions on mysql web pages , 
downloaded documents and
relelased product versions are not the same for Windows. 
I still could not understand did 3.23.35a or 3.23.36 
support bdb on windows and if 
supports how can i implement this. 

Regards. 




-
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

2001-03-27 Thread Yusuf Incekara

Would you please read this too :)

- Original Message -
From: Yusuf Incekara <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 7:08 PM
Subject: Mysql Server Client & Myodbc Silent Install


> Is there any spesification for
> Installing Mysql Server Clients & Myodbc.
> I mean if i try to install binaries in my own installation script
> what else i need to do?
> What registry keys required.
> Which dll's need to be copy to Windows , Windows/System etc
> Regards
>
> Yusuf Incekara
> Avukatpro Limited Sirketi
>
>
>
> -
> 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




Mysql Server Client & Myodbc Silent Install

2001-03-26 Thread Yusuf Incekara

Is there any spesification for
Installing Mysql Server Clients & Myodbc.
I mean if i try to install binaries in my own installation script 
what else i need to do?
What registry keys required. 
Which dll's need to be copy to Windows , Windows/System etc
Regards

Yusuf Incekara
Avukatpro Limited Sirketi



-
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: win to linux

2001-03-17 Thread Yusuf Incekara

Try to dump your database from Linux first. 
Then put them into Windows via ftp.
Then import it into a Windows. 

> I am using MySQL on windows platform. How can I port mt datas from MySQL
> server on windows to MySQl server on Linux?
> 
> Thanks for all.
> 



-
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 over ODBC

2001-03-17 Thread Yusuf Incekara

If mysqlserver is not installed on your computer then
first try to connect remote host from mysql client.

mysql -h 192.168.0.1 -u root

if you can connect via this way then
odbc can resposible about this situation.
But i don't think so.
Problem is about permissions to remote clients.

If not problem may be in your DSN configuration.
See http://www.avukatpro.com/mysql.html

for tested and working properly DSN configuration.
Regards.
Yusuf Incekara

- Original Message -
From: denis mettler <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 4:36 PM
Subject: MySQL over ODBC


> Hi there,
>
> i received the following message:
>
> [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server
> (#1130)
>
> any ideas
>
> regards
> denis
>
> -
> 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: ODBC driver doumentation !!!

2001-03-13 Thread Yusuf Incekara

Try this.

http://www.microsoft.com/data/odbc/


- Original Message -
From: satish <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 8:02 AM
Subject: ODBC driver doumentation !!!


> Hello ,
>
>   I am developing front end applications with backend mysql server in
> vc++. Can anyone tell how to connect to mysql server using odbc. Where is
> that specific api documentation is found. I badly need it for my project.
>
> satish.
>
>
> -
> 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: Load Data question

2001-02-04 Thread Yusuf Incekara

Dear Benjamin.
I firstly very very thanks for your interest.
This is my 3'rd mail with same question and you 're the first one who
reply.

- Original Message -
From: Benjamin Pflugmann <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>
Cc: Mysql Mailing list <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 2:52 AM
Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server
on 192.9.200.2 (10055))


> Hi.
>
> On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote:
> > Would you please offer me something please ?
> >
> > > From: [EMAIL PROTECTED]
> > > To:   [EMAIL PROTECTED]
> > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2
> > (10055))
> > >
> > >
> > > Description:
> > >  I am connecting from Visual Basic 6 to Mysql via
> > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to
a
> > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on
> > 192.9.200.2
> > > (10055)
> > Is it fault of myodbc or mysql server?
> > > Is it normal. If there a maximum connection limit for process ?
>
> No. Your process is only limited by your OS. E.g. Linux defaults to a
> limit of 256 sockets per process. I don't know about Windows.
I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt 4
with service pack 6 a.
There is a concurrent sleeped process limit. Same on linux too also.

>
> > > I think it is abnormal cause everyone is talking about
> > > 10.000 Web Hit.
>
> Sorry? You can handle 10.000 web hits with only one connection.
i am not interested about web. it works. no problem.
if you just create a server object on asp. loop the recordset. then close.
no problem. cause you only open 1 process then close. and it take 1 secs.
example.

Think a scenario :
You connect via ODBC or Data Environment from VB
then you get a recordset.
You will show this recordset on a grid. (excel style spreadsheet.)
if you use additem method , you can loop recordset and
manually add rows into grid then close recordset no problem.

but if you bound grid into that dao object then until program or form close
it run as a sleep process.

and if you even use 3 connection for program ,
if max sleep process is limited to 90 (due to your hardware configuration ,
but even if you use 1 gb ram
it is limited to max 120) that means maximum 30 user will be execute your
program.

and it is not satify us.

>
> > Is it cause from sleeped process list ?
>
> Quite probably. Why do you need so much sleeping processes? Maybe
> there is a misconception about the need of them?
mentioned above

> > > I increased maximum connection to 200 but it not works.  I think
> > > it is not related with maximum connection. It is related with
> > > maximum process number.
>
> Why do you get so much processes? Do you really get so much hits? If
> so, maybe someone else can help (I have no clue about tuning Windows
> systems).
yes i really need this. as i mentioned above every executed compiled
software
will be needed at least 3 connection till to unloaded.

>
> > > How-To-Repeat:
> > > Run this code on Microsoft Visual Basic 6 ENT Edition.
> > >
> > > For i = 1 To 200
> > > Set Temp_Bag(i) = New ADODB.Connection
> > > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro"
> > > Next i
> > > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE.
>
> Well, do you have a production situation that hits the wall? If not, I
> wouldn't care about it. One of my servers delivers about 5.000.000
> queries (300.000 web hits) a day with only 10-20 concurrent
> connections. (Not, that there is no need for hundreds of connections
> in some applications, but most time you don't need so much).

i have a critical product(which is written in vb for end users)
that needs at least 150 concurrent sleeped process to run.

>
> [...]
> > > Release: mysql-3.23.26-beta
> > >
> > > Exectutable:   mysqld-nt and mysqld-opt
> > > Environment:   PIII 700 MHZ Intel,256 MB RAM with WinNT4 ,
> > > Same Problem on PIII MHZ Intel with 128 MB Ram
> > > System:WinNT4 with Service Pack 6a, Internet Explorer 5
> > >   Same problem on Windows 95 Osr 2
> > > Same Problem on Windows 98 SE
> [...]
>
> Bye,
>
> Benjamin.
>
>




-
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: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))

2001-02-04 Thread Yusuf Incekara


- Original Message -
From: Yusuf Incekara <[EMAIL PROTECTED]>
To: Benjamin Pflugmann <[EMAIL PROTECTED]>
Cc: Mysql Mailing list <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 1:54 AM
Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server
on 192.9.200.2 (10055))


> Dear Benjamin.
> I firstly very very thanks for your interest.
> This is my 3'rd mail with same question and you 're the first one who
> reply.
>
> - Original Message -----
> From: Benjamin Pflugmann <[EMAIL PROTECTED]>
> To: Yusuf Incekara <[EMAIL PROTECTED]>
> Cc: Mysql Mailing list <[EMAIL PROTECTED]>
> Sent: Friday, February 02, 2001 2:52 AM
> Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql
Server
> on 192.9.200.2 (10055))
>
>
> > Hi.
> >
> > On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED]
wrote:
> > > Would you please offer me something please ?
> > >
> > > > From: [EMAIL PROTECTED]
> > > > To:   [EMAIL PROTECTED]
> > > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2
> > > (10055))
> > > >
> > > >
> > > > Description:
> > > >  I am connecting from Visual Basic 6 to Mysql via
> > > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect
to
> a
> > > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on
> > > 192.9.200.2
> > > > (10055)
> > > Is it fault of myodbc or mysql server?
> > > > Is it normal. If there a maximum connection limit for process ?
> >
> > No. Your process is only limited by your OS. E.g. Linux defaults to a
> > limit of 256 sockets per process. I don't know about Windows.
> I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt
4
> with service pack 6 a.
> There is a concurrent sleeped process limit. Same on linux too also.
>
> >
> > > > I think it is abnormal cause everyone is talking about
> > > > 10.000 Web Hit.
> >
> > Sorry? You can handle 10.000 web hits with only one connection.
> i am not interested about web. it works. no problem.
> if you just create a server object on asp. loop the recordset. then close.
> no problem. cause you only open 1 process then close. and it take 1 secs.
> example.
>
> Think a scenario :
> You connect via ODBC or Data Environment from VB
> then you get a recordset.
> You will show this recordset on a grid. (excel style spreadsheet.)
> if you use additem method , you can loop recordset and
> manually add rows into grid then close recordset no problem.
>
> but if you bound grid into that dao object then until program or form
close
> it run as a sleep process.
>
> and if you even use 3 connection for program ,
> if max sleep process is limited to 90 (due to your hardware configuration
,
> but even if you use 1 gb ram
> it is limited to max 120) that means maximum 30 user will be execute your
> program.
>
> and it is not satify us.
>
> >
> > > Is it cause from sleeped process list ?
> >
> > Quite probably. Why do you need so much sleeping processes? Maybe
> > there is a misconception about the need of them?
> mentioned above
>
> > > > I increased maximum connection to 200 but it not works.  I think
> > > > it is not related with maximum connection. It is related with
> > > > maximum process number.
> >
> > Why do you get so much processes? Do you really get so much hits? If
> > so, maybe someone else can help (I have no clue about tuning Windows
> > systems).
> yes i really need this. as i mentioned above every executed compiled
> software
> will be needed at least 3 connection till to unloaded.
>
> >
> > > > How-To-Repeat:
> > > > Run this code on Microsoft Visual Basic 6 ENT Edition.
> > > >
> > > > For i = 1 To 200
> > > > Set Temp_Bag(i) = New ADODB.Connection
> > > > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro"
> > > > Next i
> > > > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98
SE.
> >
> > Well, do you have a production situation that hits the wall? If not, I
> > wouldn't care about it. One of my servers delivers about 5.000.000
> > queries (300.000 web hits) a day with only 10-20 concurrent
> > connections. (Not, that there is no need for hundreds of connections
> > in some applications, but most time you don't need so much).
>
> i have a critical product(

Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))

2001-02-02 Thread Yusuf Incekara

Dear Benjamin.
I firstly very very thanks for your interest.
This is my 3'rd mail with same question and you 're the first one who
reply.

- Original Message -
From: Benjamin Pflugmann <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>
Cc: Mysql Mailing list <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 2:52 AM
Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server
on 192.9.200.2 (10055))


> Hi.
>
> On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote:
> > Would you please offer me something please ?
> >
> > > From: [EMAIL PROTECTED]
> > > To:   [EMAIL PROTECTED]
> > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2
> > (10055))
> > >
> > >
> > > Description:
> > >  I am connecting from Visual Basic 6 to Mysql via
> > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to
a
> > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on
> > 192.9.200.2
> > > (10055)
> > Is it fault of myodbc or mysql server?
> > > Is it normal. If there a maximum connection limit for process ?
>
> No. Your process is only limited by your OS. E.g. Linux defaults to a
> limit of 256 sockets per process. I don't know about Windows.
I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt 4
with service pack 6 a.
There is a concurrent sleeped process limit. Same on linux too also.

>
> > > I think it is abnormal cause everyone is talking about
> > > 10.000 Web Hit.
>
> Sorry? You can handle 10.000 web hits with only one connection.
i am not interested about web. it works. no problem.
if you just create a server object on asp. loop the recordset. then close.
no problem. cause you only open 1 process then close. and it take 1 secs.
example.

Think a scenario :
You connect via ODBC or Data Environment from VB
then you get a recordset.
You will show this recordset on a grid. (excel style spreadsheet.)
if you use additem method , you can loop recordset and
manually add rows into grid then close recordset no problem.

but if you bound grid into that dao object then until program or form close
it run as a sleep process.

and if you even use 3 connection for program ,
if max sleep process is limited to 90 (due to your hardware configuration ,
but even if you use 1 gb ram
it is limited to max 120) that means maximum 30 user will be execute your
program.

and it is not satify us.

>
> > Is it cause from sleeped process list ?
>
> Quite probably. Why do you need so much sleeping processes? Maybe
> there is a misconception about the need of them?
mentioned above

> > > I increased maximum connection to 200 but it not works.  I think
> > > it is not related with maximum connection. It is related with
> > > maximum process number.
>
> Why do you get so much processes? Do you really get so much hits? If
> so, maybe someone else can help (I have no clue about tuning Windows
> systems).
yes i really need this. as i mentioned above every executed compiled
software
will be needed at least 3 connection till to unloaded.

>
> > > How-To-Repeat:
> > > Run this code on Microsoft Visual Basic 6 ENT Edition.
> > >
> > > For i = 1 To 200
> > > Set Temp_Bag(i) = New ADODB.Connection
> > > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro"
> > > Next i
> > > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE.
>
> Well, do you have a production situation that hits the wall? If not, I
> wouldn't care about it. One of my servers delivers about 5.000.000
> queries (300.000 web hits) a day with only 10-20 concurrent
> connections. (Not, that there is no need for hundreds of connections
> in some applications, but most time you don't need so much).

i have a critical product(which is written in vb for end users)
that needs at least 150 concurrent sleeped process to run.

>
> [...]
> > > Release: mysql-3.23.26-beta
> > >
> > > Exectutable:   mysqld-nt and mysqld-opt
> > > Environment:   PIII 700 MHZ Intel,256 MB RAM with WinNT4 ,
> > > Same Problem on PIII MHZ Intel with 128 MB Ram
> > > System:WinNT4 with Service Pack 6a, Internet Explorer 5
> > >   Same problem on Windows 95 Osr 2
> > > Same Problem on Windows 98 SE
> [...]
>
> Bye,
>
> Benjamin.
>
>


-
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




Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))

2001-02-01 Thread Yusuf Incekara

Would you please offer me something please ?

> From: [EMAIL PROTECTED]
> To:   [EMAIL PROTECTED]
> Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2
(10055))
>
>
> Description:
>  I am connecting from Visual Basic 6 to Mysql via
> ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
> server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on
192.9.200.2
> (10055)
Is it fault of myodbc or mysql server?
> Is it normal. If there a maximum connection limit for process ?
> I think it is abnormal cause everyone is talking about
> 10.000 Web Hit. Is it cause from sleeped process list ?
> I increased maximum connection to 200 but it not works.
> I think it is not related with maximum connection . It is related with
> maximum process number.
>
>
> How-To-Repeat:
> Run this code on Microsoft Visual Basic 6 ENT Edition.
>
> For i = 1 To 200
> Set Temp_Bag(i) = New ADODB.Connection
> Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro"
> Next i
> It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE.
>
>
> Fix:
> Any offer? What means 10055 ? I check-out documents. Can't see any
> recomend or definition for this error number.
>
> Additional Information :
> Host:   3.23.30-gamma
> ClientInfo: 3.23.6-alpha
> HostInfo:   192.9.200.2 via TCP/IP
> ProtoInfo:  10
>
> I stopped on 93 process and got process list. It is attached.
>
>
> Synopsis: 
> Submitter-Id: Yusuf Incekara
> Originator: Yusuf Incekara
> Organization:   Avukatpro Limited Sirketi
> MySQL support:  None
> Severity: Critical
> Priority: High
> Category: mysqld, ODBC
> Class:  sw-bug,ODBC-bug
> Release: mysql-3.23.26-beta
>
> Exectutable:   mysqld-nt and mysqld-opt
> Environment:   PIII 700 MHZ Intel,256 MB RAM with WinNT4 ,
> Same Problem on PIII MHZ Intel with 128 MB Ram
> System:WinNT4 with Service Pack 6a, Internet Explorer 5
>   Same problem on Windows 95 Osr 2
> Same Problem on Windows 98 SE
> Compiler:  ?
> Architecture:  i686
>
>



+-+---+---+---+-+--+---+--+
| Id  | User  | Host  | db| Command | Time | State | Info |
+-+---+---+---+-+--+---+--+
| 1   | root  | INCEKARA2 | mysql | Sleep   | 1114 |   |  |
| 189 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 190 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 191 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 192 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 193 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 194 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 195 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 196 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 197 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 198 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 199 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 200 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 201 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 202 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 203 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 204 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 205 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 206 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 207 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 208 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 209 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 210 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 211 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 212 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 213 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 214 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 215 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   | 

Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))

2001-01-27 Thread Yusuf Incekara

From: [EMAIL PROTECTED]
To:   [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))


Description:
 I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on 192.9.200.2
(10055)
Is it normal. If there a maximum connection limit for process ?
I think it is abnormal cause everyone is talking about
10.000 Web Hit. Is it cause from sleeped process list ?
I increased maximum connection to 200 but it not works.
I think it is not related with maximum connection . It is related with
maximum process number.


How-To-Repeat:
Run this code on Microsoft Visual Basic 6 ENT Edition.

For i = 1 To 200
Set Temp_Bag(i) = New ADODB.Connection
Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro"
Next i
It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE.


Fix:
Any offer? What means 10055 ? I check-out documents. Can't see any
recomend or definition for this error number.

Additional Information :
Host:   3.23.30-gamma
ClientInfo: 3.23.6-alpha
HostInfo:   192.9.200.2 via TCP/IP
ProtoInfo:  10

I stopped on 93 process and got process list. It is attached.


Synopsis: 
Submitter-Id: Yusuf Incekara
Originator: Yusuf Incekara
Organization:   Avukatpro Limited Sirketi
MySQL support:  None
Severity: Critical
Priority: High
Category: mysqld, ODBC
Class:  sw-bug,ODBC-bug
Release: mysql-3.23.26-beta

Exectutable:   mysqld-nt and mysqld-opt
Environment:   PIII 700 MHZ Intel,256 MB RAM with WinNT4 ,
Same Problem on PIII MHZ Intel with 128 MB Ram
System:WinNT4 with Service Pack 6a, Internet Explorer 5
  Same problem on Windows 95 Osr 2
Same Problem on Windows 98 SE
Compiler:  ?
Architecture:  i686



+-+---+---+---+-+--+---+--+
| Id  | User  | Host  | db| Command | Time | State | Info |
+-+---+---+---+-+--+---+--+
| 1   | root  | INCEKARA2 | mysql | Sleep   | 1114 |   |  |
| 189 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 190 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 191 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 192 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 193 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 194 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 195 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 196 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 197 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 198 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 199 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 200 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 201 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 202 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 203 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 204 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 205 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 206 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 207 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 208 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 209 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 210 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 211 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 212 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 213 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 214 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 215 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 216 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 217 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 218 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 219 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 220 | avukatpro | INCEKA

Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))

2001-01-27 Thread Yusuf Incekara

From: [EMAIL PROTECTED]
To:   [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))


Description:
 I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on 192.9.200.2
(10055)
Is it normal. If there a maximum connection limit for process ?
I think it is abnormal cause everyone is talking about
10.000 Web Hit. Is it cause from sleeped process list ?
I increased maximum connection to 200 but it not works.
I think it is not related with maximum connection . It is related with
maximum process number.


How-To-Repeat:
Run this code on Microsoft Visual Basic 6 ENT Edition.

For i = 1 To 200
Set Temp_Bag(i) = New ADODB.Connection
Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro"
Next i
It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE.


Fix:
Any offer? What means 10055 ? I check-out documents. Can't see any
recomend or definition for this error number.

Additional Information :
Host:   3.23.30-gamma
ClientInfo: 3.23.6-alpha
HostInfo:   192.9.200.2 via TCP/IP
ProtoInfo:  10

I stopped on 93 process and got process list. It is attached.


Synopsis: 
Submitter-Id: Yusuf Incekara
Originator: Yusuf Incekara
Organization:   Avukatpro Limited Sirketi
MySQL support:  None
Severity: Critical
Priority: High
Category: mysqld, ODBC
Class:  sw-bug,ODBC-bug
Release: mysql-3.23.26-beta

Exectutable:   mysqld-nt and mysqld-opt
Environment:   PIII 700 MHZ Intel,256 MB RAM with WinNT4 ,
Same Problem on PIII MHZ Intel with 128 MB Ram
System:WinNT4 with Service Pack 6a, Internet Explorer 5
  Same problem on Windows 95 Osr 2
Same Problem on Windows 98 SE
Compiler:  ?
Architecture:  i686



+-+---+---+---+-+--+---+--+
| Id  | User  | Host  | db| Command | Time | State | Info |
+-+---+---+---+-+--+---+--+
| 1   | root  | INCEKARA2 | mysql | Sleep   | 1114 |   |  |
| 189 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 190 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 191 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 192 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 193 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 194 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 195 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 196 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 197 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 198 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 199 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 200 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 201 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 202 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 203 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 204 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 205 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 206 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 207 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 208 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 209 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 210 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 211 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 212 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 213 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 214 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 215 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 216 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 217 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 218 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 219 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |   |  |
| 220 | avukatpro | INCEKA

Re: Connecting to MySQL with Visual Basic

2001-01-23 Thread Yusuf Incekara

for visual basic & mysql

http://www.avukatpro.com/mysql.html



- Original Message -
From: Dwight Mowbray <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 4:18 AM
Subject: Connecting to MySQL with Visual Basic


Hi.

Can anyone tell me how or refer me to any tutorials on how to connect to
mysql using Microsoft Visual Basic (v. 6)?

Any help would be much appreciated. Thanks.

Kind regards,
Dwight Mowbray.
E-commerce solutions provider.
Email: [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