Good day all
We are trying to find out where the current connections on
our Mysql database originates from.
We are receiving 4000+ connections at the moment where this
was usually only about half this.
Is there a way of determining where
t to reestablish the connection ...
You should consider either expiring and/or testing
connection validity before use in your application, increasing the
server configured values for client timeouts, or using the Connector/J
connection property 'autoReconnect=true' to avoid this problem.
fully received from the server was40939 seconds ago.The
last packet sent successfully to the server was 40939 seconds ago, which
is longer than the server configured value of 'wait_timeout'. You should
consider either expiring and/or testing connection validity before use in your
applicat
:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Jan 21, 2010 9:43:06 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
javax.servlet.jsp.JspException: Unable to get connection
text log
> INFO: SessionListener: contextInitialized()
> Jan 21, 2010 9:43:06 PM org.apache.catalina.core.StandardWrapperValve invoke
> SEVERE: Servlet.service() for servlet jsp threw exception
> javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid:
>
org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
javax.servlet.jsp.JspException: Unable to get connection, DataSource
invalid: "org.apache.commons.dbcp.SQLNe
stedException: Cannot create PoolableConnectionFactory (Communications
re.StandardWrapperValve invoke
> SEVERE: Servlet.service() for servlet jsp threw exception
> javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid:
> "org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Communications link fa
I'm very new to MySQL, Tomcat, connection pooling, JSP, etc. and I've
been banging my head against a wall for two weeks trying to get a simple
program to connect to a MySQL database.
*Vital Stats:*
Ubuntu 9.10, Java 1.6.0_0, Java Servelet 2.5, Java Server Pages 2.1,
JSTL 1.
form of adding DBWork to it's list to
> process when a connection is received)
> --> These DBWorkers will request a connection from the pool, the pool
> then queues a connection for usage back to the DBWorker (when a connection
> becomes available)
>
> That all being sa
threadpool threads.
DBConnectionPool passes out connections.
DBWorker's accept work (in the form of adding DBWork to it's list to process
when a connection is received)
--> These DBWorkers will request a connection from the pool, the pool then
queues a connection for usage back to the DBW
Hi
Can anyone confirm if there are any connection time out values I can specify
in my application (ASP (VBScript) for the MySQL ODBC connection.
Cheers
Neil
Socket connections do not use tcp (meaning localhost)
Remote hosts use tcpip
Sent via BlackBerry from T-Mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi All,
Any body can explain the difference between socket connection and tcp/ip
connection.
Thanks,
Krishna
ed my database to another machine, on a Windows Server 2008.
> Problem is, the connection to that other server (which is on the same
> network) is very slow, taking 4-6 seconds every time. That is impossible to
> use on our applications. The ping from my machine to the server is around
Hi.
I'm using MySQL on a Ubuntu Server 8.10, I was running as a MySQL server but
switched my database to another machine, on a Windows Server 2008. Problem
is, the connection to that other server (which is on the same network) is
very slow, taking 4-6 seconds every time. That is impossible t
1 AM
To: mysql@lists.mysql.com
Subject: mysql odbc connection problem
Hi All
We are experiencing some problems when trying to connect to a mysql database
using ODBC.
The settings have been configured and it seems to be getting to the DB but
we getting the following error:
[S1T00][unixODBC][MySQL][ODBC
Hi All
We are experiencing some problems when trying to connect to a mysql database
using ODBC.
The settings have been configured and it seems to be getting to the DB but
we getting the following error:
[S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'hostname'
(using pas
the application program and mysql server are in the same host
and i have add skip-name-resolv to the my.cnf and
extend the max_allowed_packet from 16M to 32M
our application connected to mysql server from mysql.sock
before the query which cause "lost connection to MySQLserver.."
w
Since it is very unlikely that you lose connection on the socket file,
I guess you are using a PHP app, that uses the mysql driver and the problem
must be in the driver.
I would not look at mysql but at the PHP and PHP2MYSQL layer, mainly at the
later one.
Try different PHP (and driver) versions
Can you provide more details?
network layout, type of client/app used, connectors,etc,etc?
Thanks
Claudio
2009/9/9 stutiredboy
> hi,all:
>
> we met a problem that:
>
> * Lost connection to MySQL server during query
> SHOW TABLE STATUS WHERE ENGINE='MyISAM'
hi,all:
we met a problem that:
* Lost connection to MySQL server during query
SHOW TABLE STATUS WHERE ENGINE='MyISAM'
*sometimes it works well, sometimes not
our mysql version is 5.0.84
our system is FreeBSD 6.2
thanks
--
MySQL General Mailing List
For list archives: http://lists
connection
1.) remove bind-address= and skip-networking from my.cnf
2.) grant permission to the external 'user'@'host'
3.) remove any firewall rules blocking port 3306
4.) make sure no overrides on the mysqld commandline.
See http://hashmysql.org/index.php?title=Remote_Clients
systems.com.br]
Sent: Tuesday, August 04, 2009 1:09 PM
To: mysql@lists.mysql.com
Subject: Remote connection
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option on my.cnf file however it
doesn't w
Are you sure that root has granted access to connect remotely ??
Carlos
On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote:
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option on my.cnf fi
, 04 de Agosto de 2009 05:09 p.m.
Para: mysql@lists.mysql.com
Asunto: Remote connection
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option on my.cnf file however it
doesn't work.
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option on my.cnf file however it
doesn't work.
I have tried to include the bind_address = 0.0.0.0 but it still doesn't
work. Sure I have commented the s
Here's the query:
INSERT INTO
USERS(USER_ID,USER_NAME,USER_SCREENNAME,USER_DESCRIPTION,USER_FOLLOWERS,USER_IMAGE,USER_FRIENDS,USER_LOCATION,USER_CREATEDAT)
VALUES('31264066','Justin Wienkers','BabyVegaz','I’m your secondhand
news/yeah. That and an (aspiring) screenwriter, trained journalist,
with a mysql client to the mysqld (via socket or via
> localhost). The connection takes 5 to 50 seconds, or it happens that the
> connection is fast, but then the "use somethingdb;" needs 5 to 50 seconds.
>
> We have tried to use some advice from here already:
> http://www.
hi,
I need some urgent help. We have encountered a problem, when we try to connect
in shell with a mysql client to the mysqld (via socket or via localhost). The
connection takes 5 to 50 seconds, or it happens that the connection is fast,
but then the "use somethingdb;" needs 5 to
Per Jessen wrote:
> It happened agaIn this morning, but slightly different:
>
> [snip]
> thd=0x7fe0140c7e00
> Attempting backtrace. You can use the following information to find
> out where mysqld died. If you see no messages after this, something
> went terribly wrong...
> Cannot determine threa
:
INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE
state=1 AND domain='example.com'
It's getting to be a bit annoying - not all our apps were written to be
able to handle the database connection disappearing at any time. Yes,
they should have been, but it is
Darryle Steplight wrote:
> Hi Per,
>
> Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf
> file. Are these queries appearing in your slow query logs?What is your
> LOG_QUERY_TIMES set too?
>
> Here are some other settings you may want to play around wtih
> CONNECT_TIMEOUT
>
ation had choked
> on getting "Error 2013 Lost connection to MySQL server during query".
> The application is running remotely on 32bit using mysql library from
> version 5.0.67.
>
> I've been googling quite a bit, but haven't really found anything of any
> use.
The issues that we saw only came to light under stress. The
application I am referring to ran under a fair bit of load at the best
of times but it was during sustained spikes that the flaws in our
driver made themselves apparent.
Mind you, we weren't using JFS, so I'm not sure how that would have
Michael Dykman wrote:
> Given the new hardware, I'm now suspecting the RAID controller. I have
> seen misconfigured RAIDs or bad RAID drivers take out a server in just
> such a manner. I had a debian server connected to an EMC SAN.. As
> debian isn't supported, we had this open-source driver whi
Given the new hardware, I'm now suspecting the RAID controller. I have
seen misconfigured RAIDs or bad RAID drivers take out a server in just
such a manner. I had a debian server connected to an EMC SAN.. As
debian isn't supported, we had this open-source driver which gave us
no end of problems.
Per Jessen wrote:
> Michael Dykman wrote:
>
>> Have you tried running the offending SQL manually against you new
>> installation? Does it come back clean in the isolated case?
>
> No, not manually, but the job/the SQL is run several times a day,
> maybe 2-3 times per hour.
I've also just run t
Michael Dykman wrote:
> Have you tried running the offending SQL manually against you new
> installation? Does it come back clean in the isolated case?
No, not manually, but the job/the SQL is run several times a day, maybe
2-3 times per hour.
> Is there anything else which runs against this
On Mon, May 25, 2009 at 11:19 AM, Per Jessen wrote:
> Per Jessen wrote:
>
>> Michael Steinfeld wrote:
>>
>>> just a thought: Did you run "mysql_upgrade" after the import?
>>>
>>
>> No, I didn't - I didn't think of it as I really only moved the data
>> across.
>>
>
I suspect that will solve your i
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case? Is there
anything else which runs against this database at night? crons?
Could you post the script that you are running to give some context to
the statement which winds
Per Jessen wrote:
> Michael Steinfeld wrote:
>
>> just a thought: Did you run "mysql_upgrade" after the import?
>>
>
> No, I didn't - I didn't think of it as I really only moved the data
> across.
>
Okay, have done a mysqlcheck --check-upgrade - came back all clean. I
don't see a need to run
Michael Steinfeld wrote:
> just a thought: Did you run "mysql_upgrade" after the import?
>
No, I didn't - I didn't think of it as I really only moved the data
across.
best regards
Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
just a thought: Did you run "mysql_upgrade" after the import?
On Mon, May 25, 2009 at 10:19 AM, Per Jessen wrote:
> Michael Dykman wrote:
>
>> It might be helpful if you could tell us how you affected your data
>> migration
>
> Sorry, I'm not familiar with reporting problems in/on mysql.
>
> The
Michael Dykman wrote:
It might be helpful if you could tell us how you affected your data
migration
Sorry, I'm not familiar with reporting problems in/on mysql.
The data migration was done with a full database dump (mysqldump) from
the 32bit system, then a reload on the new 64bit system. I
Per Jessen wrote:
> This weekend we completed migrating a large(ish) mysql server from
> 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively
> smoothly, until this morning when I noticed an application had choked
> on getting "Error 2013 Lost connection to MySQL se
This weekend we completed migrating a large(ish) mysql server from
5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively
smoothly, until this morning when I noticed an application had choked
on getting "Error 2013 Lost connection to MySQL server during query".
The application
a Perl program on a test run of about 4 hours and my database
> connection expired/broke down.
> Here is the error I got :
>
> DBI connect('project','root',...) failed: Can't connect to local MySQL
> server through socket '/var/lib/mysql/mysql.sock'
Hi,
I run a Perl program on a test run of about 4 hours and my database
connection expired/broke down.
Here is the error I got :
DBI connect('project','root',...) failed: Can't connect to local MySQL
server through socket '/var/lib/mysql/mysql.sock' (2)
Hi,
Is there someone who is able to connect to an MySQL instance
connection via ssl,
from a client located on a different server than where is the MySQL
instance,
using the only option --ssl-ca ?
I'm not able, I can only connect if I use the options --ssl-ca, --ssl-
cert and --ss
Administrator &
Query Browser
(I come from a Visual Basic & MS SQL Server 2000/2005 environment)
When you install MS SQL server the default login is "sa" with a blank
password.
My question is;
How do I login (connection settings) to MySQL (for Administrator and
Query Brows
come from a Visual Basic & MS SQL Server 2000/2005 environment)
>
> When you install MS SQL server the default login is "sa" with a blank
> password.
>
> My question is;
>
> How do I login (connection settings) to MySQL (for Administrator and
> Query Brows
from a Visual Basic & MS SQL Server 2000/2005 environment)
When you install MS SQL server the default login is "sa" with a blank
password.
My question is;
How do I login (connection settings) to MySQL (for Administrator and
Query Browser tools)?
(I start my server by goi
it depends on the vpn router
if u need more info let me know
- Original Message -
From: "Duncan, Kurt (MCUSA)"
To:
Sent: Tuesday, February 17, 2009 12:09 AM
Subject: Slow connection over VPN
We have an application using mysql. When we run it locally there are no
issues.
We have an application using mysql. When we run it locally there are no
issues. If we try and connect to a remote database machine over VPN it
works but takes a VERY long time to get anything done. We are using the
exact same database. All other programs using the same VPN run fine and
the spee
He's using Delphi according to his first post. You might wanna use a
TClientDataSet if you're not doing so already. It provides a bit more
flexibility and won't keep the select query open for longer than is
necessary.
Have fun!
Walter
OlinData: Professional services for MySQL
Support * Consultin
On Sun, 18 Jan 2009 16:26:58 -0600, mos wrote:
> Walter,
> I just re-ran the program this time using my old 5.0 my.ini file
> (which worked fine with MySQL 5.0) with MySQL 5.1.30 and the same problem
> occurs, the Next statement loses connection to the MySQL 5.1 serv
my.ini file
(which worked fine with MySQL 5.0) with MySQL 5.1.30 and the same problem
occurs, the Next statement loses connection to the MySQL 5.1 server after a
while if there are a lot of updates in the loop. If the updates are moved
outside of the loop, the program completes without a problem. So
thing about this is the loop will work fine for a few hundred
> iterations then all of a sudden the Next statement is frozen and then loses
> connection to the server. This fails every single time it is run. If I take
> the updates out of the loop and process them later, it works fine. So there
>
is frozen and then loses
connection to the server. This fails every single time it is run. If I take
the updates out of the loop and process them later, it works fine. So there
is some sort of contention between traversing a table and updating a row of
the table at the same time. There ar
s worked fine in v5.0.1. Since upgrading to v5.1.30 after
a few
> hundred rows have been updated, the Next statement will hang for 60 seconds
> and then I get a "lost connection to mysql server" message. If I take the
> updates out of the loop, it completes just fine. So why are a f
imple and has worked fine in v5.0.1. Since upgrading to v5.1.30 after a few
>> hundred rows have been updated, the Next statement will hang for 60 seconds
>> and then I get a "lost connection to mysql server" message. If I take the
>> updates out of the loop, it completes just
grading to v5.1.30 after a few
> hundred rows have been updated, the Next statement will hang for 60 seconds
> and then I get a "lost connection to mysql server" message. If I take the
> updates out of the loop, it completes just fine. So why are a few thousand
> updates causing a
for 60
seconds and then I get a "lost connection to mysql server" message. If I
take the updates out of the loop, it completes just fine. So why are a few
thousand updates causing a problem inside of a loop? The updates are
updating 1 row at a time and does not alter any of the keys in
On Tue, Jan 13, 2009 at 6:06 PM, Dan wrote:
> On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
> wrote:
>
>> This sounds like you need to raise max_allowed_packet for mysqldump
>> (and possibly mysqld) - these are separate settings for both the
>> client and the server. You can do this via the
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
wrote:
> This sounds like you need to raise max_allowed_packet for mysqldump
> (and possibly mysqld) - these are separate settings for both the
> client and the server. You can do this via the my.cnf (or ~/.my.cnf)
> or specify it as an option on
This sounds like you need to raise max_allowed_packet for mysqldump
(and possibly mysqld) - these are separate settings for both the
client and the server. You can do this via the my.cnf (or ~/.my.cnf)
or specify it as an option on the command line "mysqldump --opt ...
--max_allowed_packet=1G dbna
On Tue, 2009-01-13 at 12:19 +0530, Chandru wrote:
> Hi,
>
> Did u try using this command
>
>
> mysqldump --opt db_name > db_name.sql -p 2>>bkp.err
Not quite. Firstly, I had to alter the normal backup cron job, and that
doesn't happen until late at night.
Secondly, yes I added the redirecti
Solaris 10
x64 (64bit MySQL as well).
I wrote a script that starts a mysqldump process for each table within a
database, which shouldn't be a problem since the host currently has around
12G unused memory. Midway through the dump I seem to lose the connection as
Dan described. After attempti
t;
>> Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have
>> always done nightly backups with:
>>
>> mysqldump --opt db_name > db_name.sql -p
>>
>> Recently this started failing with:
>> Error 2013: Lost connection to MySQL server
&g
n, Jan 12, 2009 at 9:07 AM, Daniel Kasak wrote:
> Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have
> always done nightly backups with:
>
> mysqldump --opt db_name > db_name.sql -p
>
> Recently this started failing with:
> Error 2013: Lost connection to My
Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have
always done nightly backups with:
mysqldump --opt db_name > db_name.sql -p
Recently this started failing with:
Error 2013: Lost connection to MySQL server
I have checked all tables for corruption - nothing found. Also as far
e same database server-
>> if you're doing, say, DNS round-robin or load balancing or something,
>> maybe you're getting shunted to a different db server and it's killing
>> the connection... don't know what your setup is. Another long shot in
>> a multi
a different db server and it's killing
the connection... don't know what your setup is. Another long shot in
a multi-db-server config would be to make sure they all have different
server ID's.
Good luck... hopefully someone else has better advice :)
Jake
Just a guess, but maybe it
cts: recent
versions, persistent vs. non-persistent connections, etc. A long shot
would be to make sure your always talking to the same database server-
if you're doing, say, DNS round-robin or load balancing or something,
maybe you're getting shunted to a different db server and it's killin
We've started seeing mysql errors in the logs, and when i look at the output
of mysql_error() (in php), i get "lost connection to mysql server during
query". Here's an example stack trace:
'Can't connect to database [Lost connection to MySQL server during
query]
nas'@'' (using
password: YES)
$ mysql -u jonas -p --host= --ssl-ca=ca.crt
--ssl-key=mysql-client.key --ssl-cert=mysql-client.crt
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 389
Server version: 5.0.51a-12-log (Debian)
Type
Only increase max_allowed_packet is ok.
On Tue, Aug 19, 2008 at 5:49 PM, Warren Young <[EMAIL PROTECTED]> wrote:
> Mad Unix wrote:
>
>>
>> During the update of the MySQL DB (delete/insert), I keep getting the
>> following message
>> Lost connection to My
ch is:
Connection failed:
1045 - Access denied for user 'root'@'localhost' (using password: NO)
My Old pc has exactly the same settings but that uses MySQL 4
I have done a system restore to the point before I installed MySQL 5,
and then installed MySQL 4 and that went on with no p
Have you tried setting the password with mysql admin?
Example:
mysqladmin -u Root yourpassword 'yournewpassword'
-
Eric
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have just loaded MySQL 5 and MySQL Front on to a new computer, and
I am now getting a MySQL-Error which is:
Connection failed:
1045 - Access denied for user 'root'@'localhost' (using password: NO)
My Old pc has exactly the same settings but that uses MySQL 4
I have done
Hi!
I just upgraded from 4.0.26 to 4.1.22.
On phpMyAdmin with the older (4.0.26) was only one field for "Language"
and it was set to "Hebrew (he-iso-8859-i)".
Now, upgrading (4.1.22) in the "Language" field appears "Hebrew
(he-utf-8)" and a new fiel
Mad Unix wrote:
During the update of the MySQL DB (delete/insert), I keep getting the
following message
Lost connection to MySQL server during query...
By default, the MySQL server drops a connection after 8 hours of
receiving no queries on that connection. This can happen in an
Hi all
During the update of the MySQL DB (delete/insert), I keep getting the
following message
Lost connection to MySQL server during query...
Any thoughts about this issue, could it be a network, code or tunning
problem ...
Thanks
For example,the user is [EMAIL PROTECTED]
I want to adjust timeout value for him ,which is different from the global
parameter named interactive_timeout or wait_timeout?
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
I'm trying to start a connection to a mysql database, but even though
I've installed the connector I don't see where the option to choose that
data type of connection exists.
I'm using Connection/NET v 5.1, btw
--
MySQL General Mailing List
For list archives: http://list
On May 9, 2008, at 12:17 AM, Sebastian Mendel wrote:
Paul DuBois schrieb:
On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote:
Hi,
wouldn't it be very helpful if mysql connectors support some sort
of per session persistent connection?
this would save a lot of queries in many apps
Paul DuBois schrieb:
On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote:
Hi,
wouldn't it be very helpful if mysql connectors support some sort of
per session persistent connection?
this would save a lot of queries in many apps, for example SET NAMES,
setting variables, creating temp
On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote:
Hi,
wouldn't it be very helpful if mysql connectors support some sort of
per session persistent connection?
this would save a lot of queries in many apps, for example SET
NAMES, setting variables, creating temporary tables
How
t; wouldn't it be very helpful if mysql connectors support some sort of
> per
> > > session persistent connection?
> > >
> > > this would save a lot of queries in many apps, for example SET NAMES,
> > > setting variables, creating temporary tables
> &g
wouldn't it be very helpful if mysql connectors support some sort of per
session persistent connection?
this would save a lot of queries in many apps, for example SET NAMES,
setting variables, creating temporary tables
or are there any other methods i am not aware of to achieve this?
This is a little off-topic for this list (recent PHP tutorials
nowithstanding)... replying offline
On Wed, May 7, 2008 at 5:36 AM, Sebastian Mendel
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> wouldn't it be very helpful if mysql connectors support some sort of per
> sessio
Hi,
wouldn't it be very helpful if mysql connectors support some sort of per
session persistent connection?
this would save a lot of queries in many apps, for example SET NAMES,
setting variables, creating temporary tables
or are there any other methods i am not aware of to achieve
0.11:3306
--proxy-backend-addresses=10.25.0.12:3306
--proxy-lua-script=lib/rw-splitting.lua
Works as well for a while, but after stops with this error:
=====
General Error
SQL ERROR [ mysqli ]
Lost connection to My
-infoshop.com
www.giiexpress.com
www.etudes-marche.com
>-Original Message-
>From: Tim McDaniel [mailto:[EMAIL PROTECTED]
>Sent: Monday, April 28, 2008 12:19 PM
>Cc: mysql@lists.mysql.com
>Subject: RE: Problem with character set and connection collation
>
>On Mon, 28 Apr 2008, Jerry
On Mon, 28 Apr 2008, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
A week or so ago I explored this in depth because I was having the
same problems. (It was affecting an English file that had some
Windows (CP-1252) characters that didn't directly map to UTF-8. That
message is at http://lists.mysql.co
nt: Sunday, April 27, 2008 6:01 AM
>To: mysql@lists.mysql.com
>Subject: Problem with character set and connection collation
>
>Hello all,
>here is my problem:
>
>I am trying to set mysql to unicode character, so that i can get my
>dictionary application to look at words in Ne
I am trying to set mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:
mysql charset: utf-8 unicode
when i make a new database:
mysql connection collation is utf8-general-ci
and my new database collation is also utf-general-ci
Hello all,
here is my problem:
I am trying to set mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:
mysql charset: utf-8 unicode
when i make a new database:
mysql connection collation is utf8-general-ci
and my new database
>-Original Message-
>From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 24, 2008 10:01 AM
>To: 'Padiyath Sreekumaran'; mysql@lists.mysql.com
>Subject: RE: Php-mssql connection problems on Windows XP
>
>When using odbc_connect, you don&
When using odbc_connect, you don't use the DSN you've previously created.
You use the complete definition of the connection. Here's an example of
connecting to an MS Access database:
define('ODBC_CONNECT',
'DRIVER={Microsoft Access D
101 - 200 of 1783 matches
Mail list logo