Is it possible to procede to a DSNless connection to a mySQL DB in ASP ?
If so could anyone send me a example script ?
Thank you.
Nicolas Villatte
IT Manager
Creative Web
Rue Kessels straat, 38
1030 Brussels
Office Phone: +32 2
This means that the host mbtpc20.bau-verm.uni-karlsruhe.de is not allowed to
connect to your server. You can set this up rather easily with the standard
mysql GUI admin tool. Also have a read on creating/working with users in
the on-line searchable documentation of MySQL
greetings,
Joris
Dear Robert,
If I'm correct you've installed a mysql server on your webserver, I hope that you used
the documentation which is provided on
the mysql-website. I hope that you're sure about the ability to use
scripting-languages on your server and that they can interact with mysql. If you
Hi,
I am importing an Access 97 Database into MySQL.
One of tables tblSuppliers holds all the critical supplier information and has a 4
character Primary key called 'Key'
This is heavily used throughout a lot of VB code in the Access GUI and can't really be
changed easily.
When I import the
Hi
I am wanting to use auto incrementing numbers. Now I know that if I add
an entry to the db then the number is auto assigned. Now what I want is
it where I can get the next auto number and then add my entry using this
number. The reason for this is that I need this number for a number of
I had this segmentationone but that was using java (1.3 form IBM on Red Hat
6.2)
and that was an exception that stopped my Web Apps I switch both jdk (I use
Sun know) and driver mm...2.0.2 to 2.0.3 and I never have this exception
ever since. I hope that helps.
At 18:47 27/03/2001 -0800, you
I'm converting a MS Access database to a mySQL database. All seems to be
fine. But I have problems with MS Access fields of the type (german)
OLE-Objekt (probably OLE object in the English version). These fields are
converted to LONGBLOBs.
In Access, I can fill these fields with graphics or
[EMAIL PROTECTED] writes:
Description:
MySQL 3.23.36, built on a lunix-2.4.2 system using identical
configuration to the previous MySQL-3.23.35 build, dies immediately upon
launch with a SIGSEGV.
How-To-Repeat:
All that's necessary on this system is to try to start
Hi,
I am trying to link a MySQL database (linux) with a StarOffice client
on Windows, with MyODBC installed.
I created the database, tables, set up select,update,delete,insert
privileges on all tables in it from the host running StarOffice.
I can list tables, can insert data into them via
Maybe this question is out of topic, but I'm feeling really unhappy.
I'm trying to compile MysqlGui, but at the end it always says, that there
are no -lrc an -lrcl libraries. And that's the point. I have no idea, what
libraries I should download (I'm using RH7.0 on 200MMX).
Peter Adamka writes:
Maybe this question is out of topic, but I'm feeling really unhappy.
I'm trying to compile MysqlGui, but at the end it always says, that there
are no -lrc an -lrcl libraries. And that's the point. I have no idea, what
libraries I should download (I'm using RH7.0 on
Hello,
This is the following SQL statement used in a results page for a search:
SELECT icaref, id, date, payee, descript, disb, payment, receipt-payment, receipt,
SUM(disb),
SUM(receipt-payment)
FROM data
WHERE receipt-payment 0 AND date BETWEEN 'varStart' AND 'varEnd'
ORDER BY date
GROUP BY
I'm newbie when it comes to installing pkg's on Solairs..
I've dl'd the latest version of mysql from sourceforge
(2.23.36-sun-solairs2.7-sparc.tar.gz). I can
install the pkg ok but when I run mysql_install_db I get the following message..
ld.so.1: /bin/mysql: fatal: libcrypt_1.so.1: open
Hi, I hope that someone can help me on this matter.
I have a C program which uses MySQL. This program does many many (100,000)
SELECT, INSERT, UPDATE, DELETE on single HEAP tables. The machine I developed
it on was a P3 800 256MB Linux machine running MySQL 3.22.32 (standard version
of
Greg,
I checked on all my 2.6 systems and the library libcrypt_1.so.1 appears to be
a Solaris 2.7 library only. I could not find a current version of mysql for Solaris
2.6. I'm in the process of compiling the latest version on my Solaris 2.6 machine.
There is a version for 2.6 but it is
The following peace of code returns sometimes a result with only 1
field, whereas i'm waiting for a result with 3 fields.
How can such a SELECT return less than the field count required ?
Here are the query, *result and mysql just after the mysql_fetch_row()
Thanks if you can help me
Hello,
I am looking for a difinitive answer as to whether data from LDAP and MySQL
may be synchronized.
What I want to know is if there's any way to automagically synchronize MySQL
and LDAP? ie take selected fields from MySQL and have it update an LDAP
authentication database. LDAP as a front
LIBASOV IOANNIS wrote:
I'm not quite sure if this question is appropriate for this mail list, so may be
somebody can tell me whom to ask better.
I was going to run the following code:
..
if (system("mysql -u username -ppassword -h hostname -P 3606 path/to/filename
2errlog"))
Just thought I would explain my stupidity!
One of my tables which I'd forgotten about was 100k entries but I'd dropped
the primary key off earlier. Adding the primary key back again made the two
machines the same speed immediately.
Its amazing what indexes can do!
David
Hi, I hope that
Bordeaux Stan wrote:
Hi guru type folks,
My system crashed over the weekend and I had to reinstall linux. I'm
currently running Mandrake 7.2. Now that I'm up and running again I find
that the output from a mysql query is not formatted properly. The tables
look as though they are
"MW" == Michael Widenius [EMAIL PROTECTED] writes:
MW* Added `SET TRANSACTION ISOLATION LEVEL ...'
How about documenting this?
http://www.mysql.com/doc/S/E/SET_TRANSACTION.html is quite
uninformative as to what the different levels mean.
Is the http://www.mysql.com/doc/S/t/Stability.html document up to
date? In particular, I'm interested in the current stability level of
BDB tables, since I'm in need of transactions for a particular
project. Also, the MyISAM handler is still listed as gamma, not
stable.
--
Hello,
iam new to mysql and have nothing much to do with mysql itself, but i seem
to have the following message whenever i start mysql
it gives me the following message
Starting service MySQLStarting mysqld daemon with databases from
/var/lib/mysql failed.
well , i checked up the mysql
Jason Guritz wrote:
mysql show databases;
+---+
| Database |
+---+
| directory |
| mysql |
| phpBB |
| testdb |
| trial |
+---+
5 rows in set (0.00 sec)
mysql use testdb;
ERROR 1049: Unknown database 'testdb'
Keeps happening to me
I know you people are busy but I have seen this question a few times on the lists to
no avail. *see below*
It has been figured out by my admin.
It appears that one or more entries in the ACL tables is corrupt, when this happens so
its preventing logins.
So you have to replace the ACL with a
And no mention of the machine, the operating system version, the
mysqlsource file
downloaded, the compiler used, which version of make, or even the comand
entered.
gawie wrote:
Hi...please help
Cannot get the version of MySQL compiled..When running a configure it stops at :
Forget it.
That compiler is broken.
Use GCC-2.95.2
root wrote:
hi there o wise ones
i know i should RTFM, but i am, its right here infront of me. maybe its
cause i cant start working with sql till i get home from slavin for the
man or whatever, but id really like to get it
I can't seem to get this version of MySQLGUI 1.7.4-2 to connect to the mysql
server I'm running on the computer. I get the following denial of access
everytime I try to connect:
Access denied for user: ' mailto:'root@localhost' root@localhost
mailto:'root@localhost ' (Using password: Yes)
Daniel Adams wrote:
This is probably a really stupid error, but I'm unable to run myisamchk:
[root@cssrvr1 mail2db.bad]# ls
category.MYD groupcounter.MYD list.MYD message.MYD threadrequest.MYD
category.MYI groupcounter.MYI list.MYI message.MYI threadrequest.MYI
category.frm
Hello,
iam trying to delete tables from a database, the mysql asks for the root
user password which i give but it seems to be not accepting it , i have
included the sequence below
Erasing database tables (you will need to enter the database
root password)
Path of mysql tool (the default is
BIN(intag 255)
Filip Sergeys wrote:
Hi,
WHAT DO I WANT TO DO:
I want to have the binary value of a part of a decimal value.
1)I have a decimal value in column called intag : 262204
2)From this value I'am only interested in the last two bits of the HEX value of
this decimal
The RPMs on RH CD have problems.
Check teh archives for instructions on getting it working, or get
new RPMs.
Stephane Pinel wrote:
When I attempt to launch mysql server with command safe_mysqld, the console
return this:
"starting mysqld daemon with databases from /var/lib/mysql"
"010327
You don't have zlib on your machine.
Check your 6.2 CD.
Chris Becker wrote:
I'm having trouble installing the perl module DBD specifically. I found on
my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and
got errors, I discovered I needed DBI installed first. So I
Thanks for the answer
but it is a bit more complexe, i actually creates these sample table for the
example. Here is an attachement of the structure dump.
Hummm you got me to
think more about my database structure withc is really good. The idea you
bourght up seems really good.
I am a
Hello All,
I'm recently back in the job market, and looking for PHP/MySQL contracting
opportunities. Can some helpful people out there please email with good job
sites and/or real headhunters that specialize in this type of work? I've
already exhausted dice.com, guru.com, monster.com,
I am having problems with a MySQL query. I user the following query:
SELECT search_users.ID FROM search_users,users WHERE search_users.Step=4 AND
users.ID=search_users.ID AND search_users.Login'' AND search_users.LookForSex="M"
AND search_users.Sex="F" AND search_users.Country="US" AND
error 28 is "No space left on device".
Hang wrote:
Greetings,
I am upgrading my mysql from 3.22.23b to 3.23.35 on RedHat with kernel
2.4.0. I followed the instructions on the manual for the upgrade. Every
goes fine except I can't convert one table from ISAM to MYISAM.
I got quite a
Somebody will correct me if I am wrong, but I think cannot have a column in
a table that has the same name as a MySQL reserved word.
You are going to have to change it. 'Key' is simply NOT going to work for
your column name.
On the reasonable chance that I am wrong, the documentation that I am
Sorry to keep harping on this, but back when 3.23.34 was released, there was
a line in the release notes that claimed that binary distributions with BDB
and InnoBase would be tackled "next week".
Has there been any progress on this front? I'm most interested in the Win32
binary distribution,
Greg Wejrowski wrote:
I'm newbie when it comes to installing pkg's on Solairs..
I've dl'd the latest version of mysql from sourceforge
(2.23.36-sun-solairs2.7-sparc.tar.gz). I can
install the pkg ok but when I run mysql_install_db I get the following message..
ld.so.1: /bin/mysql: fatal:
Hi!
First: To this mailing list we only accept full repeatable bug reports
as defined in the MySQL manual.
"Ionut" == Ionut Petre [EMAIL PROTECTED] writes:
Ionut HI!
Ionut I have a problem, and I don't know how to resolve it:
Ionut I want to migrate a database from an SQL Server 7.0 into an
just checking if im on the list still
-
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]
Hi there,
I am looking for a web-based accouting system written in
Mysql/Perl/Apache/Linux.
I am willing to pay for the system, and it could be a simple accounting
system or a complex one. Could be also just a module, for example payroll,
inventory, sales.
I hope someone could tell
I have two mySQL servers, one is in office, and other at home. I need to
synchronize then via DialUp TCP/IP connection (not Internet DialUp). Can
somebody help me ?
--
Martin Jeremic - JSoft
http://jsoft.webjump.com/
mailto:[EMAIL PROTECTED]
On Wed, Mar 28, 2001 at 05:22:56PM +0200, Martin Jeremic wrote:
I have two mySQL servers, one is in office, and other at home. I
need to synchronize then via DialUp TCP/IP connection (not Internet
DialUp). Can somebody help me ?
Does MySQL replication suit your needs?
Jeremy
--
Jeremy D.
Description:
Deadlock possible when LOCKing underlying tables in a MERGE table definition
How-To-Repeat:
mysql CREATE TABLE lock_test1 ( test CHAR(5) DEFAULT '' NOT NULL PRIMARY KEY
);
mysql CREATE TABLE lock_test2 ( test CHAR(5) DEFAULT '' NOT NULL PRIMARY KEY
);
Hi!
I have query from several tables - from news table, picture table and
comments table. It diplays headline, news from news table, number of
comments for news from comments table and picture alignment (on the web)
from pictures table.
As it could be many comments and also many pictures for one
try
INSERT INTO tblDomains (field1, field2) VALUES (1, 'trlinux.com.');
ChrisB
MCSE MCDBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Cesar Martinez
Sent: Wednesday, March 28, 2001 12:40 PM
To: [EMAIL PROTECTED]
Subject: (sin asunto)
that such!!
I have been trying for the last while to come up with a query that will do
the following:
Say I have table with these records:
StartDate StopDate
---
2001-01-23 23:43:12 2001-01-24 04:29:12
2001-01-24 15:24:00 2001-01-26
Speaking of books on MySQL are there more than one to choose from?
If so is MySQL written by Paul DuBois the best one?
John Jackson
Direct Access Recruiters
[EMAIL PROTECTED]
-Original Message-
From: B. van Ouwerkerk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 5:03 AM
What response/results are you getting? Tt would help us to determine the
problem
-Original Message-
From: James Cox [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 7:13 AM
To: [EMAIL PROTECTED]
Subject: GROUP BY behaviour.. help needed..
Hello,
This is the following SQL
Was a password defined when you granted permissions to the user?
-Original Message-
From: Hammad Nasim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 2:43 PM
To: [EMAIL PROTECTED]
Subject: running Mysql client
Hi
I am having some problems running mysql client. I can connect
I hope someone could tell me where to find one.
Off-topic, take a look at www.php.net for php scripts. Otherwise checkout
www.cgi-resources.com
Bye,
B.
-
Before posting, please check:
Hi Rick,
I actually fixed that problem - it was due to the fact that the GROUP BY and ORDER By
statement were
mixed up :(
still don't understand groups well, though :(
Thanks,
James Cox
- Original Message -
From: "Rick Emery" [EMAIL PROTECTED]
To: "'James Cox'" [EMAIL PROTECTED];
Hi,
The short version:
Does anyone know an automated way of keeping two MySQL db's (located on
different machines) in sync? A small window of non-sync could be acceptable.
The long version:
I'm working on a project which basically is about capturing a lot of data
from different places and
Hello All !!!
I've 2 tables in a Shopping Cart Servlet
TransactionTable is having a one to many relation with OrderTable
create table TransactionTable (
TransId Integer Not Null Auto_Increment Primary Key,
OrderDate TimeStamp, Not Null ,
GrandTotal Double Not Null ,
FullName VarChar(40) Not
Did you look at doing something with replication?
Mat
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot now? [ OK ]
- Original Message -
From: "Aigars Grins" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 28, 2001
Hi,
Does anyone know an automated way of keeping two MySQL db's (located on
different machines) in sync? A small window of non-sync could be acceptable.
Read about "replication" in the corresponding chapters in the online manual
of mySQL (http://www.mysql.com/) - Documentation.
Regards
...
Hi!
Let me try to restate my question and provide more information.
Running: Linux 2.2.16-3, Coldfusion 4.5, MySQL 3.23.33
Problem: "The connection to the data source failed. Check the following to
resolve this problem: ..."
Now, I get this error on one database called xprojects while I can
Hi,
I have two joined tables (three actually, but for an example, 2 is OK)...
example:
Names / Function
Then in names I have NameID, Name, and FunctionID, and in Function table, I
havce FunctionID, and FunctionName...
therefore, I need to find the Function Name of a Person, through their
I have Solaris 2.6 on a SUN E450
I downloaded the mysql-3.23.36.tar.gz from some site
and now when i unzip it using
gunzip mysql-3.23.36.tar.gz | tar xvf -
it gives me
tar: directory checksum error
please help
I have downloaded the file mysql-3.23.36.tar.gz twice and unzipped it
twice, i get
On Wed, 28 Mar 2001, Aigars Grins wrote:
Hi,
The short version:
Does anyone know an automated way of keeping two MySQL db's (located on
different machines) in sync? A small window of non-sync could be acceptable.
The long version:
snip
The important question is how much availability
I took a look at the manual, but I am a bit unsure of how this would be done
in a multi-table wuery, such as the one below... if anyone can help, greatly
appreciated! :)
SELECT DISTINCT Questions.QuestionID, Questions.Question,
Experts.ExpertFullName, Category.CategoryName, Questions.Shows,
Assuming that there is a one-to-one relationship between the tables on the
FunctionID (meaning there is only one entry in Functions for each
FunctionID), then...
SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName
FROM Names LEFT JOIN Functions ON
From: "Ralph Graulich" [EMAIL PROTECTED]
Read about "replication" in the corresponding chapters in the online
manual
of mySQL (http://www.mysql.com/) - Documentation.
From: "Mat Murdock" [EMAIL PROTECTED]
Did you look at doing something with replication?
Thanks for the quick reply. I hadn't
Tnx for the answer.
From: "nigel wood" [EMAIL PROTECTED]
The important question is how much availability ( the ability to survive
network partitions) your looking for:
1) Is simple master -- slave replication good enough for your application
?
all inserts updates going onto the Master the
Nevermind about my previous posts I got it to work!
-Tanya
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Your query converted to using left joins:
SELECT DISTINCT Questions.QuestionID, Questions.Question,
Experts.ExpertFullName, Category.CategoryName, Questions.Shows,
Questions.Views
FROM Questions
LEFT JOIN Experts ON (Questions.ExpertID = Experts.ExpertID)
LEFT JOIN Category ON
try to use gtar from www.mysql.com
there is some known problem in solaris tar file...
-Original Message-
From: Shahid Iqbal [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 3:04 PM
To: [EMAIL PROTECTED]
Subject: error in unzip
I have Solaris 2.6 on a SUN E450
I downloaded
I think I got it working...
thanks!
I had a few pretty complex queries, so it took a little while to understand,
and then convert all of them! :)
-Original Message-
From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 8:56 PM
To: Roy Nasser; 'nigel wood';
Actually, these are a portion of a table that's contents are generated by
Radius records imported into a MySQL table, so both values are generated
simultaneously (or, at least as far as MySQL as concerned).
-Original Message-
From: Oson, Chris M. [mailto:[EMAIL PROTECTED]]
Sent:
Hi, I am trying to count all the distinct id numbers in a column but I
just can't figure it out... What would be the appropriate select statement
for this, thanks,
-
Before posting, please check:
At 8:32 AM +0800 3/29/01, [EMAIL PROTECTED] wrote:
Hi, I am trying to count all the distinct id numbers in a column but I
just can't figure it out... What would be the appropriate select statement
for this, thanks,
SELECT COUNT(DISTINCT id) FROM tbl_name
--
Paul DuBois, [EMAIL PROTECTED]
I'd try:
Select distinct count(id) from myTable;
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://superid.dyndns.org:8080/freesql/index.php
"Currently 100% Slogan Free"
-
The O'Reilly MySQL msql book is not bad, but then I bought Paul DuBois'
book, and now I only use the command reference at the back of the O'Reilly
book for quick lookups. I like the way it is layed out. Every other question
relating to MySQL has been answered by Paul's book.
On 3/28/01 1:28 PM,
SELECT COUNT(DISTINCT ID) FROM my_table;
Note: NULL values will be omitted from the count.
regards,
thalis
p.s. would be a good idea to read an SQL tutorial before your next post
On Thu, 29 Mar 2001 [EMAIL PROTECTED] wrote:
Hi, I am trying to count all the distinct id numbers in a
If the user was defined using a password, then you must use the password.
If the user was defined without a password, then you must NOT use a
password.
Since the userid is unique key in the grant tables, you can't have it both
ways. Pick one and go with it (best to use the password)
If you
Thanks. Just needed a confirmation. :-)
Cal Evans wrote:
Yes and I believe it's explained in the manual better than I can explain it
here.
Roughly speaking, if the field contains:
foobar
then
LIKE 'foo%' says match anything starting with foo. Since it's STARTING with
foo then the
Hello All,
I see a -t or a --timeout= option listed for mysqladmin, but I can't
seem to get mysqladmin to recognize it. Is this an oversight in
documentation or a case of my misunderstanding?
My objective is to be able to ping each of our mysql servers with a
script and report on their health.
Is the zlib on CPAN? like module Compress::Zlib ?
Many Thanks Gerald!
ChrisB
MCSE MCDBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Gerald Clark
Sent: Wednesday, March 28, 2001 9:26 AM
To: Chris Becker
Cc: [EMAIL PROTECTED]
Subject: Re: Perl -
Description:
mysql_info() returns an empty string as the return value for
a successful insert/load data.
Furthermore, mysqlimport does not give the same information:
peter@ulisse ~/develop/seler $ mysqlimport --local -u seler seler foo
seler.foo:
Thanks!
So, is there any way to calculate the approximate disk space required for the
transformation
from ISAM to MYISAM?
Gerald Clark wrote:
error 28 is "No space left on device".
Hang wrote:
Greetings,
I am upgrading my mysql from 3.22.23b to 3.23.35 on RedHat with kernel
Hi.
On Thu, Mar 29, 2001 at 10:47:54AM +0800, [EMAIL PROTECTED] wrote:
Thanks!
So, is there any way to calculate the approximate disk space required for the
transformation
from ISAM to MYISAM?
I would have assumed 330MB and don't see the reason why it should use
more. Obviously I am wrong
Alternate solution,
mysqldump --add-droptable db_name table_name
path/with/a/lot/of/room/table_name.sql
Edit your file and change the table create clause to include TYPE = MYISAM
after the column defs. Ie:
CREATE TABLE table_name (column1 def, column2 def,...) TYPE = MYISAM
Then: mysql dbname
I was at the store tonight. Did not see an O'Reilly book but believe I saw
the book by Paul DuBois. There was also a book, one of the Teach Yourself
(MySQL) in 21 Days, series.
Anybody familiar with that one?
John Jackson
[EMAIL PROTECTED]
-Original Message-
From: Lindsay Adams
I got the PaulDubois book , but i made a mistake i bought the transaltion in
french. An advice to all others who are thinking of buying it in french if
you can buy it in englis ,
Yann
- Original Message -
From: [EMAIL PROTECTED]
To: "Lindsay Adams" [EMAIL PROTECTED]; [EMAIL
"Freeing pointer out of range at line 102" this is the message generated in the error
file of the Apache Web Server logs directory. The line 102 in the program refers to
the connectivity command for my sql through 32-bit ODBC driver.
We are working on windows NT and MySql 3.23 .
The error file
Hi
I have not used EJB app server with MySQL w/ BDB support. Indeed I used Jrun
with Sybase for feasibility test.
But for setting AutoCommit,
I suggest u'd check MySQL JDBC whether it supports to disable auto commit.
If it can, try to run your JDBC code to disable instead of running in
Hi
I'am new to sql and I have a problem with a full text dokument in my database.
Is there any way to edit a full text dokument in mysql ?
**
Regards
Morgan Norell
System Administrator
Euro Business Link
www.ebl.se
Dear reader,
Maybe this question is slightly off-topic, but what the hell ;) I'm the sysadming for
a little firm which use a few Windoze computer and a lot of linux/BSD-servers. The
windoze computers are used by the accounting staff and use Staroffice 5.2 as their
Office application. There is
I was at the store tonight. Did not see an O'Reilly book but believe I saw
the book by Paul DuBois. There was also a book, one of the Teach Yourself
(MySQL) in 21 Days, series.
Anybody familiar with that one?
I would go for Paul's book (he should pay me for everytime I refer to his
book :))
91 matches
Mail list logo