Hello,
I can connect to a SQL server in the following way from my windows OS machine:
Start -- control Panel -- Administrative tools --- Data Sources(ODBC)
and provide the necessary input. This works for me without problems.
I have installed xamp sw on this window machine. The SW version is
Padiyath Sreekumaran schrieb:
?php
$dsn=asi_qms;
$username=asi_qms_2006;
$password=something;
$server=xxx;
if(!$handle = odbc_connect($dsn, '$username', '$password')) die('Keine
Verbindung möglich!');
?
I got the following error when I execute the previous script:
Warning: odbc_connect()
Padiyath Sreekumaran schrieb:
Hello Sebastian,
Thanks for your mail. But I donot see any difference in my $username and yours
except
'().
what surprise, yes, thats it!
you have to use no quotes at all (or doublequotes) around variables, RTMF is
this case the one from PHP
but what has
Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: Padiyath Sreekumaran [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 24, 2008 5:56 AM
To: mysql@lists.mysql.com
Subject: Php-mssql connection
-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't use the DSN you've previously
created
Ken,
You should probably be specifying the socket for both the startup
commands and the connect commands just to be sure. Without seeing your
config files, it's hard to say much else.
Rich(ard)
On Nov 6, 2007 9:37 PM, tech user [EMAIL PROTECTED] wrote:
Hello members,
I have two mysqld run on
Hello members,
I have two mysqld run on the same host (redhat linux OS with 2.4 kernel).
the two mysqld are in different versions, one is 4.0.20,another is 5.0.45.
the mysql 4.0.20 uses /etc/my.cnf as its config file,listening on default
3306 port.
the mysql 5.0.45 uses /etc/mysql5.cnf as its
Hello all,I'm running into a intermittent and very annoying problem with all of my servers. I'm currently running FreeBSD 4.11, exim-4.51-0, and mySQL 4.1.13. My exim config is setup to have exim do a mySQL lookup in order to determine whether a given user's e-mail is hosted by our e-mail
On Thursday, 9 February 2006 at 17:02:06 -0800, Michael Jeung wrote:
Periodically, exim throws the following error into its panic log:
Feb 9 13:24:51 mx_server_1 exim[69953]: 2006-02-09 13:24:51 failed to expand
${lookup mysql {select distinct domain from email_table where
I'm trying to set up SSL connectivity to a Fedora Core 4 server running
mysql-server-4.1.16-1.FC4.1 and not having much success. I keep getting
ERROR 2026 (HY000): SSL connection error
no matter what I do.
I followed the directions on
I seem to be getting heaps of aborted connections, and I can't figure
out why. MySQL's error (from mysqld.err, below) is Got an error reading
communication packets, but this is a socket link to localhost so that
rules out network problems. I simply can't figure it out. Has anyone got
any
Just to add to this further, if I reduce max_allowed_packet in my.cnf
down to around 16M, then the error changes to Got a packet bigger than
'max_allowed_packet' bytes.
However, as you can see from the SQL below, the longest SQL statement
I'm executing is around 21 bytes, certainly nowhere
Hello.
I was unable to find reported bugs with similar symptoms for the 5.0
version (hope I haven't missed something). But at the bottom of:
http://dev.mysql.com/doc/mysql/en/packet-too-large.html
we have these lines:
You can also get strange problems with large packets if you are
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute mysqladmin to set the root password using the -h flag
my hostname is truncated, and I get a connection refused message.
The hostname on this box is a fqdn like blah.1.2.3.net. My command line
is
Can you check the host name again? You have a five segment address.
-Original Message-
From: Andrew Hall
To: [EMAIL PROTECTED]
Sent: 7/28/04 3:55 PM
Subject: connection problems
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute
To: [EMAIL PROTECTED]
Sent: 7/28/04 3:55 PM
Subject: connection problems
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute mysqladmin to set the root password using the -h flag
my hostname is truncated, and I get a connection refused message
: RE: connection problems
Yes I have. The hostname of the box returned with 'hostname' is the
fqdn and is in the format of blah.1.2.3.net.
Drew
On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote:
Can you check the host name again? You have a five segment address.
-Original Message
Message-
From: Andrew Hall
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 7/28/04 4:35 PM
Subject: RE: connection problems
Yes I have. The hostname of the box returned with 'hostname' is the
fqdn and is in the format of blah.1.2.3.net.
Drew
On Wed, 2004-07-28 at 17:16
Subject: RE: connection problems
Yes I have. The hostname of the box returned with 'hostname' is the
fqdn and is in the format of blah.1.2.3.net.
Drew
On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote:
Can you check the host name again? You have a five segment address
Victor Pendleton wrote:
What error messages are you receiving?
-Original Message-
From: Peter Bruggink
To: [EMAIL PROTECTED]
Sent: 7/16/04 3:19 AM
Subject: [CONNECTION PROBLEMS]
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53. The old server is running solaris 7
and mysql 3.23.48-max.
I also transferred the database to the new server and tried to connect
the database with mysql front. Everything worked fine.
Then
What error messages are you receiving?
-Original Message-
From: Peter Bruggink
To: [EMAIL PROTECTED]
Sent: 7/16/04 3:19 AM
Subject: [CONNECTION PROBLEMS]
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53. The old server is running
I am getting the following log entry when ever I try to connect to mysql
from the network.
mysqld[2857]: refused connect from 192.168.1.28
This is on an SuSE 9.0 linux box and I haven't enabled any firewall yet
so I don't know why this would be happening. Any ideas?
Chris W
--
MySQL General
Hi,
I am trying use MySQL on RedHat 9 Linux box. I
installed the following rpms for this.
mysql-3.23.54a-11.i386.rpm
mysql-server-3.23.54a-11.i386.rpm
mysql-devel-3.23.54a-11.i386.rpm
After installing I executed the mysql_install_db
script, which executed without giving any error. I
On Wed, Nov 05, 2003 at 03:39:03PM +1030, John wrote:
HI All
I was wondering if anyone could tell me how to get around this problems
Error: could not connect to the database.
It's possible the database itself is just not working at the moment.
The admin should also check that the
HI All
I was wondering if anyone could tell me how to get around this problems
Error: could not connect to the database.
It's possible the database itself is just not working at the moment.
The admin should also check that the database details have been correctly
specified in config.php
Hi All,
I hope someone can help with this connection problem.
We have MySQL 4.0.12 installed on a W2K server and we are using the
Connector/J version 3.0.7 driver to connect our Java applet to the
database. The applet and the database are both on the same machine.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John R Langan wrote:
Hi All,
I hope someone can help with this connection problem.
[snip]
When attempting to connect from the PC on the intranet the trace gives
the following:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driverat
I recently installed Red Hat 7.3 on a box, and have
been having difficulty connecting to my MySQL server.
I can connect locally. That is, on the same machine
as the server. However, if I try and connect from a
remote machine with the following command:
mysql -h IP_ADDRESS -p DATABASE
I get
Steven Nakhla wrote:
I recently installed Red Hat 7.3 on a box, and have
been having difficulty connecting to my MySQL server.
I can connect locally. That is, on the same machine
as the server. However, if I try and connect from a
remote machine with the following command:
mysql -h -p
I get
I am currently having difficulties tracking down a problem. We have two
servers, one of which has mySQL installed (3.23.40). Domains on either
server can opt to have a mySQL database, and there are a number of Dbs set
up. We have a relatively low number of maximum connections allowed, and some
Dear All,
We are running MySQL on a Cobalt Raq 4.
After a while the socket 'mysql.sock' will not work anymore and access to
our database is not possible.
The error MySQL reported is:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
The mysql deamon is still
Ivan,
Monday, April 29, 2002, 11:29:31 PM, you wrote:
IS We use the PHPLib classes for our website.
IS ( http://phplib.sourceforge.net/ )
IS Now we have a lot of lost connection problems when we use 2 or 3 different
IS db queries with different db tables !
IS .
IS $db = new newsDB
Hello list users,
We use the PHPLib classes for our website.
( http://phplib.sourceforge.net/ )
Now we have a lot of lost connection problems when we use 2 or 3 different
db queries with different db tables !
.
$db = new newsDB();
$db-query(SELECT * FROM news ORDER BY HitsOut DESC limit
Hi,
I try to connect to MySQL on a server (not my own, it's a shared server)
with the following PHP script:
?php
mysql_connect(localhost, food, xxx) or die (Could not connect);
?
I always get the error:
Fatal error: Call to undefined function: mysql_connect() .
Normally this means that PHP is
It does appear that MYSQL has not been compiled in. Execute the phpinfo()
function in a script to determine if MYSQL is in there.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 1:14 PM
To: [EMAIL PROTECTED]
Subject: Connection
Config:
* Mac: Mac OS X 10.0.4; java 1.3.1; mysql 3.23.32
* Linux: Linux 2.2.19/debian testing; java 1.3.1; mysql 3.23.36
I *really* could use some help here. I need to get MySQL up and running;
I've been at it for 2 days and can't get my WO app to see it, whether I
try on Linux or OS X.
Hi !!
)-Original Message-
)From: Paul Schreiber [mailto:[EMAIL PROTECTED]]
)Sent: Friday, August 24, 2001 1:21 PM
)To: Web Objects admin; Web Objects newsiest; Web Objects dev; MySQL List
)Subject: MySQL, Web Objects 5: job connection problems
)
)
)Comfit:
)* Mac: Mac OS X 10.0.4; java
Hi all,
I am very new to MYSQL and I am running 3.23 on RedHat Linux 7.1.
I have just set up a simple database.
I was not prompted for a password,and was just allowed to set it
up and access it.I now want to access it through C,and I am trying to set up
a
connection to my database but I am
Look at the source for the mysql client, and see how they do it.
O'SULLIVAN JOHN wrote:
Hi all,
I am very new to MYSQL and I am running 3.23 on RedHat Linux 7.1.
I have just set up a simple database.
I was not prompted for a password,and was just allowed to set it
up and access it.I now
40 matches
Mail list logo