Access vs Mysql benchmarks

2002-01-26 Thread mweb
ier to persuade if he can read online some actual numbers by independent reviewers (**). TIA, mweb (**) Meaning not on the PHP/MYSQL pages, if possible -- Needs are a function

How to select on two tables

2002-01-05 Thread mweb
? Do I need a common index? Again, I realize that this is really a FAQ and certainly well documented issue, I just need to know what its correct "title" is. Examples are also welcome, of course TIA, mweb -- There is hopeful symbolism in the

Answer to: UPDATE Query works in odbc/Mysql, but fails in odbc/MS Access

2001-12-06 Thread mweb
rence is due to the type of the "Un" column being different between the databases, MySQL and Access having actually different syntax, or any combination of the above. Comments? mweb On Thursday 06 December 2001 13:30, mweb wrote: > Hello, > > I have one MS Acc

UPDATE Query works in odbc/Mysql, but fails in odbc/MS Access

2001-12-06 Thread mweb
is an online ACCESS syntax reference? TIA, mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

What is causing duplicate keys?

2001-12-05 Thread mweb
ut 0 or NULL it complains. Also, Andrew Hill siggested the use of odbc_tables and odbc_columns to get info about the structure of each column which I don't know in detail because the DB was written by the guy who quit, not me) What is the exact syn

Re: FOLLOW UP on "column names not liked by odbc/php/access"

2001-12-05 Thread mweb
you all once more for your quick and kind suggestions. regards, mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Partial answer to "FOLLOW UP on "column names not liked by odbc/php/access"

2001-12-05 Thread mweb
c_exec( no cursor returned ) This is clear, but, since I just take over the database, no docs exists about it, and I only have Linux running right now at home, how do I fins out quickly which columns are type mismatch? the 2.5 value almost sure doesn't go into quotes, right? but what a

FOLLOW UP on "column names not liked by odbc/php/access"

2001-12-05 Thread mweb
is wrong, or some value I try insert is not matching the column type? If so, why would this be a *syntax* error? Is it possible to query access via Php so that it will tell the internal strucure of the table? (this database was d

MySQL access denied from localhost

2001-12-04 Thread mweb
ssage when I do $cnx = odbc_connect( 'domain' , 'testuser', '' ); I haven't run the mysql_install_db because I read somewhere it's part of the rpm install on RH 7.2, but apart from that, I've done anything explained in the web page above. SUggestions?

THANKS for: Failing to connect to MySQL via unixODBC/PHP

2001-12-04 Thread mweb
db97', SQL state S1000 in SQLConnect in /test.php line 87 so now I still have to work a lot, but at least all the pieces are in place, and do talk to each other. Thank you again, mweb --

Re: [PHP] RE: SQL state S1090: Almost connected to mysql via PHP/odbc

2001-12-02 Thread mweb
in original post). There is certainly something wrong with my config files, but I'm checking them aginst all the documentation I found so far, and nothing appears. Any help is appreciated. mweb - Befor

SQL state S1090: Almost connected to mysql via PHP/odbc

2001-12-02 Thread mweb
ill: Warning: SQL error: [unixODBC][TCX][MyODBC]Invalid DSN specified, SQL state S1090 in SQLConnect in /home/mweb/public_html/test.php on line 360 - Before posting, please check: http://www.mysql.com/manual.php (the manua

Problem connecting to mysql via odbc

2001-11-29 Thread mweb
can't figure it out. I saw a thread couple of days ago about myodbc dsn creation, but can't relate it to my problem. Actually, I only have odbcinst, not the commands mentioned in that message. Any help is appreciated! Thanks, mweb RPM list

Failing to connect to MySQL via ODBC/PHP

2001-11-28 Thread mweb
/public_html/cgi-bin/default.php on line 11 What should I check/change/fix? Which config files/commands... Should I recompile PHP (see phpinfo outout) , or may it just be a config issue? Any help is appreciated, mweb

Re: Mysql start on RH Linux 7.1

2001-11-18 Thread mweb
mysql-3.23.36-1 mysql-devel-3.23.36-1 php-mysql-4.0.4pl1-9 unixODBC-2.0.7-1 unixODBC-generic-2.0.7-1 mysqlclient9-3.23.22-4 unixODBC-mysql-2.0.7-1 Thank you! mweb On Sun, Nov 18, 2001 21:35:18 at 09:35:18PM +0900, Batara Kesuma wrote: > Hi, > > On Sun, 18

Mysql start on RH Linux 7.1

2001-11-18 Thread mweb
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql.sock does exists If I try as normal user: [mweb@po mweb]$ safe_mysqld Starting mysqld daemon with databa

Setting up Mysql to work through ODBC

2001-11-17 Thread mweb
-3.23.22-4 unixODBC-mysql-2.0.7-1 what should I do to set up mysql so that it manages a database when it is called from PHP pages via unixodbc? Are there specific tutorial/online examples about this? TIA, mweb -- We need to focus on how to be productive, not just active

RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread mweb
Yes I found it!!: http://www.cynergi.net/exportsql/ thanks you again!! mweb > -- Initial message --- > > From: "Andrew Hill" <[EMAIL PROTECTED]> > To : "mweb" <[EMAIL PROTECTED]> > Cc :

RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread mweb
dy used it? > -- Initial message --- > > From: "Andrew Hill" <[EMAIL PROTECTED]> > To : "mweb" <[EMAIL PROTECTED]> > Cc : <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Date: Tue, 13 Nov 2001 10:48:52 -0500 > Subject

RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread mweb
GREAT, THANK YOU! Now the only step left is how to convert (on Linux) the MS access database to MySQL...How? mweb > -- Initial message --- > > From: "Andrew Hill" <[EMAIL PROTECTED]> > To : "mweb" <[EMAIL

Access to MYSQL via ODBC?

2001-11-13 Thread mweb
hanges) an MS access on NT/IIS. Is it possible? mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

Solution for testing PHP/MS Access on Linux

2001-11-13 Thread mweb
ther issue (performance, stability, whatever) TIA, mweb -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

Re: Faking MS Access on MySQL linux box

2001-11-09 Thread mweb
Thanks for the shameless plug, I'll look into your code. However, shouldn't something like what I want be possible in PHP with ODBC? mweb On Fri, Nov 09, 2001 15:22:11 at 03:22:11PM -0800, Bill Adams wrote: > mweb wrote: > > > >mweb, > > >

Re: Faking MS Access on MySQL linux box

2001-11-09 Thread mweb
>mweb, > To make sure I understand you correctly, you want to create >and >test your PHP/MySQL database on your Linux/Apache box, then upload it >to >your ISP server that is running PHP/Access? I'm sorry but that's not >going >to work. You can't tran