[PHP-DB] Problem with PHP ODBC

2004-05-05 Thread ofontes
Hi, I try to configure a web server under Debian/GNU/Linux Sarge. All fonctionning perfectly except odbc connect. I have to read datas in an ACCESS2000 mdb file to import in Mysql. Actually this run correct under a windows 2000 workstation with apache/PHP/Mysql I installed on my debian odbc

[PHP-DB] Losing MySQL connection with multiple database classes

2004-05-05 Thread Mika Porspakka
Hello all. I'm getting a weird problem trying to use a database class for multiple connections for different databases on the same server. Whenever I make a new instance of the class, all the previously opened class instances connect to that new MySQL database. So, for example, if I have

RE: [PHP-DB] Losing MySQL connection with multiple database classes

2004-05-05 Thread Uzi Klein
Check your class... Maybe it resets the connection each time you create it. -Original Message- From: Mika Porspakka [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:23 To: [EMAIL PROTECTED] Subject: [PHP-DB] Losing MySQL connection with multiple database classes Hello all.

RE: [PHP-DB] Losing MySQL connection with multiple database classes

2004-05-05 Thread Mika Porspakka
Oh damn. The class was missing the link identifier in one of the functions and that reset the rest of the class instances too. Thanks, probably would have taken hours before i had taken a look at the class.. Check your class... Maybe it resets the connection each time you create it.

Re: [PHP-DB] Problem with PHP ODBC

2004-05-05 Thread Robert Twitty
If you are able to place the Access database on a Windows machine that can be accessed by the Linux machine, then you can use odbtp. You can get it at http://odbtp.sourceforge.net. -- bob On Wed, 5 May 2004 [EMAIL PROTECTED] wrote: Hi, I try to configure a web server under Debian/GNU/Linux

Re: [PHP-DB] Struggling

2004-05-05 Thread Mark
--- Erik Meyer [EMAIL PROTECTED] wrote: Hope someone can help me. I have two tables: evt_details evt_sponsors The structure is as follows: evt_details evt_sponsors evt_detail_id (INT)(PK)

Re: [PHP-DB] Problem with PHP ODBC

2004-05-05 Thread ofontes
I try to configure a web server under Debian/GNU/Linux Sarge. All fonctionning perfectly except odbc connect. I have to read datas in an ACCESS2000 mdb file to import in Mysql. Actually this run correct under a windows 2000 workstation with apache/PHP/Mysql I installed on my

[PHP-DB] Fatal Problem of PHPMSSQL

2004-05-05 Thread
Hi, I found a big problem of mssql dll. I have 2 servers A(WinXP Pro_CN) and B(Win2000 Pro_CN).I am in China. IIS(Configed PHP) are on both servers. SQL Server are on server A. Just use mssql_connect($host,$user,$pass)to connect to the SQL Server. After I installed the

Re: [PHP-DB] Problem with PHP ODBC

2004-05-05 Thread Robert Twitty
If you are able to place the Access database on a Windows machine that can be accessed by the Linux machine, then you can use odbtp. You can get it at http://odbtp.sourceforge.net. -- bob My problem is i can't modify my PHP code. Actually the web site runs on a windows2000

[PHP-DB] Subject: Struggling [Is : With database normalisation]

2004-05-05 Thread Neil Smith [MVP, Digital media]
Probably something as simple as changing the structure to a more normalised form would help : By adding a table which links evt_details to evt_sponsors, you do away with the need to have (up to 4) distinct fields to hold the evt_sponsor in your evt_details table. So add something like table :