MYSQL :: PHP Connection To MySQL

Changes Made In One Connection Does Not Reveal In Another Connection At Once.
I use many connection and the same as many threads in my server app to gain performance on a multicpu machine.

Firstlly i call "set autocommit=0" and wrap every statements with "start transaction " and "commit". i use mysql_stmt_execute for every statement rather than mysql_real_execute except those that can't be prepared. The version of mysql is 4.1.11 under Debian linux.

In one connection of one THREAD i insert a row into a table. After i got the sucess code and the last insert id, i then do a "select" from another connection in another THREAD with the "last insert id" return by the previous insert . I expect the select can fetch the row that i have just insert , but some time it does and some time it doesn't.

is there any funtion like "mysql_....flush...cache.." to make the changes from one connection to be reveal to the global at once?

MySQL Error 2013: Lost Connection To MySQL Server During Query
I'm running sugarcrm on mysql and the following query is returning "MySQL error 2013: Lost connection to MySQL server during query":

MYsql Connection/PHP
I am getting the following message, when I installed mysql client version 5.1.11. I get this message when I tried to connect through PHP. I am using, windows XP professional.

"Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Connection To MySQL Using .net
I am trying to connect to a MySQL database, using the .Net framework.

I installed the newest MyODCB (3.51) and the .Net ODBC drivers from
Microsoft.

I made a System DSN using the driver, and i get it to connect - so far
so good.

But if i try making a new connection i my code using the sample
connectionstring from MySQL, i get an Exception :(

"An OLE DB Provider was not specified in the ConnectionString. An
example would be, 'Provider=SQLOLEDB;'."

What i try is:

Return New OleDb.OleDbCommand("DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=bigshop;UID=root ;PASSWORD=;OPTION=3;")

MySQL-PHP Connection
the problem i'm facing is of mySQL-PHP connection. i'm trying ...

<?
$link = mysql_connect("localhost",'root','nawal')or die("Connect Error: ".mysql_error());
print "Successfully connected.
";
mysql_close($link);
?>

and getting this message...

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Program FilesApache GroupApache2htdocs estindex.php on line 5

Connect Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client.

MySQL Connection Over LAN.
I have installed mySQL server on a computer (ServerName: AHMED, ip:192.162.0.1) and teh server listens at port:3306.

I type "mysql -u root -p" on command line to connect to the server on local host.

Now I want to connect to the same server over the network from a computer (ComputerName: FARAZ, ip: 192.168.0.2). I Copied mysql.exe to the client PC (FARAZ) and I typed the line "mysql AHMED -u root -p" on FARAZ (Client PC) but It says that it fails to find any mySQL sever on AHMED.

1] If I only have to copy mysql.exe on the client to access mySQL server over a network.
2] Am I right to type "mysql AHMED -u root -p" on the client to connect to the mySQL server?

MySQL Connection
I just install PHP5 and MySQL5. They all work but I can't connect to MySQL via php connection (mysql_connect). Could you tell me what is the matter?

Connection To MySQL
I have installed MySQL administrator tool on my XP machine and would like to know how and if I can connect to MySQl on Redhad Linux server. What do I have to install on the server to be able to manage it using MySQL Administor gui tool?

Connection To MySQL
I New to Linux PHP apache and MySQL (following the Book, Begining.PHP,
Apache, MySQL Web Development). Got as far as chapter 3 without too many
problems. Well no I'm stuck. I get the following error

Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2) in /usr/local/apache2/test/createmovie.php
on line 4

Database connection error, check your server connection

when then following piece of code is executed

$connect = mysql_connect("localhost", "mysql", "mysql" ) or die
("Database connection error, check your server connection" );

I'm, A bit lost about which file the path is stored.

Has anyone came across this similar problem and found a fix for it?

Vb5 Connection To Mysql
I'm trying to use vb5 to connect to a mysql database. I'm sure that the drivers are installed and the database exists because I tested it using vbscript in an asp page.  With the asp page I am able to connect and query the db, but when I try it with the vb5 application, I can't get it to connect. I get this error:

"Data source name not found and no default driver specified".

This is the vb code I'm using

     Dim ConnectionSTR As String
     Dim conn As ADODB.Connection
     Dim Query As String
     Dim rs As ADODB.Recordset

    Text1.Text = "connecting to database..."
    Set conn = New ADODB.Connection
    conn.ConnectionString = "DRIVER ={MySQL ODBC 3.51 Driver}; SERVER = localhost; DATABASE = testunits; UID=root; PWD=; OPTION=3"
    conn.Open
     Text1.Text = "connection succeeded"

Can anyone tell me why this won't work in vb5, but works with vbscript asp?

Mysql Connection
i am trying to connect the odbc connector to mysql i am new to this, i have fields

datasource name
discription
server
user
password
database

i have tried localhost as the server, there is no username or password and the database dropdown box is empty just dont know how to connect?

PHP MYSQL Connection
I got a small problem with mysql php connection i try the following php code but nothing happens other than just showing the first echo "i am here".

Is there something wrong with the code below or am i supposed to make some special settings to connect PHP with MYSQL locally?

<?php
echo "i am here";
$con = mysql_connect('localhost', 'k1m0', 'passy');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("world", $con); .......

Mysql Connection
I am using iPowerWeb to host PHP files and I am accesing their MySql database.

This is what i use to connect to the database:
mysql_connect("localhost", "studentm_test1", "test1");
mysql_select_db("studentm_test");

Just creating this connection can sometimes take up to 45 seconds. The time ranges from .0006 seconds to up to 45 seconds and it gets realy annoying because the connection times are really random. Most of the times it takes around 5 seconds and this is with very few concurrent users. Maybe 3.

MySQL SSL Connection
We have a server which runs mysql and Apache. Our scripts obviously connect to the the database server through "localhost".

Now our server when entering secure areas encrypts all data between browser and server using SSL. Does this mean that the data being extracted from the DB is secure? The DB Server is on the same machine doing the encrypting.

I understand that if the script was making a request to a server on another network/domain or even within a private LAN should be encrpted using SSL.

And I understand that running a mysql server on the same machine as Apache is not the most desirable setup, but just wanted to ensure that the server will be encrypting all of the data.

MySQL Connection
I have a MySQL connection problem.
(using MacOSX/Apache platform)
When I access mysql from the shell, I have no problems.

However, when I try to connect from Dreamweaver MX or MySQL Administrator, I get the following:

"2002 can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

I actually installed MySQL from the website and now have the MySQL preference pane. Restarting the computer or the server from the prefs pane does nothing.

Did I make a mistake by installing MySQL and Apache 2, not realizing that (at the time, I'm dumb) MacOSX came with MySQL and Apache 1.3?

It's causing Apache connection problems as well. When I start Apache 2 server from the prefs pane (if web sharing is turned on) it says : "you already have an instance of Apache server running". If I turn off web sharing from the prefs panel, I can then start the Apache server from the Apache prefs pane; however, i can no longer connect to my localhost and I can no longe turn on web sharing.

My questions are:

1)Do I need to uninstall Apache 2 server, or is there a way to reconfig so that I can run it from the prefs pane?
2)Did I make a mistake by installing MySQL and MySQL Admin?

MySQL Connection Through LAN
We are new to using MySQL and ran accross a very simple issues. I have installed MySQL in one of the widows XP machine and now i want my network users to access that MySQL database. We are unable to connect. All pcs are in a common work group but still none of the pc's is able to access the MYSQL database from LAN.

Is there any special configuration needed for the my sql server to be able to access it through LAN? Please help ASAP.

Note:- All pcs in our network are running windows XP (including the one in which we have installed my sql to use as a my sql server).

MySQL Connection
Trying To Setup paFileDB, Yes I Have Everything Uploaded, Im Trying To Install it.. http://ultimatemedia.freehostia.com/DLDB/install and im am getting a connection error..

Error: paFileDB Error
paFIleDB encountered an error while running a database query and is unable to continue.

For technical assistance, please visit The PHP Arena support page.
mysql error: [1045: Access denied for user 'joecha10_chat'@'hex12.freehostia.com' (using password: YES)] in CONNECT(mysql3.freehostia.com, '****', '****', joecha10_chat)

MYSQL Connection
If I link to a page after connecting to a database, and the user follows the link, the connection is lost. Is there any way to transfer the connection to the next page

MySQL Connection
Will any body tell how to connect MySQL using My ODBC 3.51 through ADSL modem and router. I have ping the IP of the server successful but using MySQL query connection to same IP fail

Php Mysql Connection
My setup is windows xp , apache 2 , php 4.3.10 , mysql 4.1.8 ...
Php and apache work fine , and i can control mysql via command line .
But ...When i try to control mysql via php with the follow script :

<?php
$connection = mysql_connect ( "localhost", "root", "") or die ( "unable to connect to MySQL" );
echo( "connected to MySQL" );
?>

I take the next message :

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in C:Program FilesApache GroupApache2htdocsSitesTestain.php on line 9
unable to connect to MySQL

Phpmyadmin Mysql Connection
I just recently installed phpMyAdmin on local computer for testing purposes. However, I am experiencing mysql connection on it. I used root@localhost but it's telling me that I couldn't connect to the database. But I know that both my username and the password are correct, so I thought that the problem might be from the hosted server, maybe my sql isn't connected to localhost or something? I am really new to this so I couldn't be sure, is there a way to tell what server the mysql has from the mysql console? Or are there other ways to do so?

MySQL Connection Error
I am trying to put together this PHP script using the database for IPB. I just can't get this one part of the script to work. It is supposed to access the members database, and it just can't find the members database.

I get the error
Quote:
Unable to view external table, ipf_members. Table 'username_ipb.ipf_members' doesn't exist.
username would be my MySQL username, but I won't post that. I know the username works, because all other MySQL connections using that same username work.

I took the piece of code that wasn't working out of the file and tried putting it in its own little test file, and it still wouldn't work.

PHP

<?php$wgIPB_MySQL_Host = 'sql1.byethost7.com' // ipB MySQL Host Name.$wgIPB_MySQL_Username = 'username' // ipB MySQL Username.$wgIPB_MySQL_Password = 'k1tens' // ipB MySQL Password.$wgIPB_MySQL_Database = 'username_ipb' // ipB MySQL Database Name.$wgIPB_UserTB = 'ipf_members' // Name of your IPB user table. (i.e. ipb_members)$wgIPB_UserConvergeTB = 'ibf_members_converge' // Name of your IPB users converge table (i.e. ibp_members_converge)$wgIPB_GroupsTB = 'ibf_groups' // Name of your IPB groups table. (i.e. ipb_groups)$wgIPB_User_GroupTB = 'ibf_groups' // Name of your IPB user_group table. (i.e. ipb_groups)$username = "chris"; $connection = mysql_connect($GLOBALS['wgIPB_MySQL_Host'],$GLOBALS['wgIPB_MySQL_Username'],$GLOBALS['wgIPB_MySQL_Password']) or die ("Couldn't connect to server"); $db = mysql_select_db($GLOBALS['wgIPB_MySQL_Database'],$connection) or die ("Couldn't select database"); $getuserinfo = "SELECT `name` FROM " . $GLOBALS['wgIPB_UserTB'] . " WHERE `name` = "" . $username . """; // Query Database. $userResult = mysql_query($getuserinfo) or die("Unable to view external table " . $GLOBALS['wgIPB_UserTB'] . " " . mysql_error()); $userinfo = mysql_fetch_array($userResult); echo $userinfo['name'];?>

I normally would use the $GLOBAL['variable'] if the variable was defined in the same file like the code above, but I just wanted to see if I could get this block of code to work.

I know for a fact that ibf_members exists. Here is a screenshot from phpMyAdmin.

I just don't know how to fix this problem! The table exists. I have tried repairing the table. I have tried reinstalling IPB. Nothing works!

Php, MySQL Connection Query
I was wondering if anyone out there can help me with this query?

When developing a database for my clients I usually set up two connections from php, one for the CMS with read, write, update, delete etc privileges and one for guest with read only privileges for public access to the site.

I am at present moving some of my clients to a new server but MySQL only allows one connection (the one set up for the account).
To me this seems to be a bit of a security problem as the public access will have all the privileges of the admin area. Am I correct in my thinking? and if so is there a way around this? (without looking for another hosting company )

The hosting company is using php4 and MySQL 4.1.20 at present but are considering upgrading to php5 and MySQL 5 in the near future.

Connection To MYSQL Database
I am new to the forum and have little experience of using MYSQL, PHP and Apache.

I am wanting to create a database or try to get the example of the "Pet Shop Catalogue" in the PHP and MYSQL dummies book to work first before I try developing my own database. Each time it comes up with an error of "Cannot connect to the database." I have entered the SQL for the example in the program given in the book, made sure that PHP is working and Apache Web page is up and running and MYSQL server is running in the back ground.

Also I tried to enter the SQL directly into the server but to no avail. Below shows the status of the MYSQL server.

mysql Ver 11.18 Distrib 3.23.52 for pc-linux -gnu (i686)
connection id 1
current database
current user root@localhost
current pager stdout
using outfile ' '
server version 3.23.52
protocol version 10
connection Localhost via UNIX socket
client characterset latin1
server characterset latin1
Unix socket /var/lib/mysql/mysql.sock

Threads 1 Questions 2 Slow Queries 0 Opens 6 Flush Tables 1 Open Tables 0 Queries per second avg 0.009

Connection String From Db.asp To MySQL DB
I have a project that was originally developed to run on an access db due to it's lack of traffic, now I trying have the same project use MySQL as it's db in anticipation of more traffic.

Below is the connection string for my Dev (local) site.

ConString = "Driver={MySQL ODBC 3.51 Driver}; Server=216.251.43.11; Database=c:/program files/mysql/MySQL Server 4.1/cdi_cdnsys_com; UID=****; PWD=****; Option=3"

MySQL Connection Query
As you'll be able to tell by this question I am completely new to MySQL.  I have installed MySQL on Windows 2000.  I opened the program winmysqladmin and was asked to enter an admin name and password which I did.  This, as I am sure you all know, is listed in the my.ini file.

The problem arises when I try to connect to MySQL through the mysql monitor via a DOS prompt.  I can connect to it fine whenever I don't specify a user name and password (by just using the 'mysql' command).  However if I try to connect using the username and password I set when I opened winmysqladmin for the first time it won't allow me. I get a 1045 access denied error.

Why is this?  I obviously need to specify some security and the only way I can connect to the server is with no security.  I don't know if this makes any difference but I the database server is on the same machine as I am trying to make the connection from.

Making MySQL Connection
I'm using DreamWearverMX, and try to establish the MySQL connection, but I'm confuse when it's asking for the connection name, MySQL server info, user name, password, and database. Where I can get these information to make the MySQL connection. I already build the "reservation" database, which contained fours tables, booking, clients, room and users.

Connection To MySQL On The Server
We have MySQL 4.1 on our Windows server but can not get it loaded or a client gui on my local workstation due to security issues with my company.

How can I create a database from my client workstation?
Do I just send the SQL to create my database to the Server admin and let him fun it from an MySQL command line?

Or can I use our Access Database GUI and connect to MySQL?

MySQL And PHP How Can I Get Connection With The Server.
At home I have server (windows2000 with apache).

When I start mysql form the commentline or with the administrator program I haven no probleem. I can make databases; everthing looks okay. Also PHP is installed and working okay.

To test MYSQL in combinatie with PHP I wrote a small script (make connextion with mysql and show the record in the database. When i try it I get the following message:

"Client does not support authentication protocol requested by server; consider upgrading MySQL client"

What wrong, who can help me? Mysql version is 4.1.14-nt, mysql client version is 5.0.11

Mysql ODBC Connection +VC+Win
Want to create Mysql ODBC connection with visual C under Windows. I do not want to use DSN. Any ideas? I know there is ODBCconnection class under .NET, but how about visual C?

Remote Connection To MySQL
Trying to connect to a MySQL server from my desktop.

Specs:

My Desktop - XP OS - MySQL Administrator.
Server - Red Hat Linus OS - MySQL version 4.x

From the MySQL I am getting an error code 2003 "Can't connect to MySQL server (10060)". I am using the default port 3006.

Any suggestions? What additional information do you need to help me out here?

MySql Remote Connection
I'm having problems in trying to remote connect to a database and it's driving me nuts.

Database is on server, trying to connect to it through internet using MySQL Control Center with following settings:

Name: Lucca
HostName: IP address of server
UserName: Beeps
Password: """"
Port: 3306

I've made sure that the firewall will allow entry and can successfully ping the server, but I get the following error:

Error 2003: Can't connect to MySQL server on "ip" (10060)

MySQL And OGSA-DAI Connection
I am a student working on a project which involves accessing MySQL database from OGSA-DAI, when i type the command for accessing the already created database from the command prompt, it gives me the error that database cannot be accessed by this user - unauthorised access.

MySQL Connection Error
I have my web server on a Linux machine.

Apache 2.0, MySQL 5 and PHP 5

I have a utility (phpmaker) that helps me administer my databases. When I went to set it up I get this connection error.

"Error on connect: Host 10.1.1.10 is not allowed to connect to this MySQL Server"

Where do I enable so this ip (host) is allowed?

AcuODBC To MySQL Connection
I have a MySQL server with a AcuODBC client ODBC connection that is setup in Data Sources as a System DSN. I installed the MySQL ODBC connector as well.

What I want to do is populate a MySQL database with the data from the AcuODBC server (separate server). What do I need to setup and what steps are involved in doing this?

MySQL Connection Error
Using MySQL server config wizard, I created a database 'polls' and set passwd as 'admin'. I used the following PHP code to connect this db:

$host = "localhost:3036";
$user = "polls";
$pass = "admin";

$conn = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($user) or die ("Unable to select database!");

and I got the following error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'polls'@'localhost' (using password: YES) in C:ServerApache2 htdocsPollsuser.php on line 17 Unable to connect!

and BTW, what is the difference between the user name and db name? when I try to connect the db from DOS, it just prompted for password only, not username.

Mysql Backup Connection In PHP
I notice with PHP if a connection cannot be established to a mysql
server with mysql_connect() PHP will timeout and never try the backup
server. In this example:

$db = mysql_connect('db1.local.net', 'username', 'password');
if (!$db) {
$db = mysql_connect('db2.local.net', 'username', 'password');
}

This works great and connects to the 2nd database if the 1st one
rejects the connection completely; however, if the 1st db is under high
load and doesn't respond for 10+ seconds it never jumps to the 2nd one.
Curious if there's a better way to accomplish this. If the 1st db
doesn't respond in 1 second max I'd like to hop to the 2nd one.

Does the newer mysqli_connect handle this better, anyone know?

Connection Priorisation In Mysql
I have a question if there is any features in mysql 3 /4 to support
connection priorisation. Currently we are running some update queries
that squeeze all all other connections running on the database.

Connection To MySQL Server
Can you connect to a mysql server with the same user more than one time at the same time and all sessions to be different? I want to write a C program who creates several child procesess and in each child there will be a connection to a mysql server and want to now if I have to connect from each child using a different user or I can use one user for all and the sessions to be different.

Php Mysql Connection Problem
I can access mysql via phpmyadmin and have imported a db into it.
everything is fine but i am unable to connect to the mysql db via php

I am using the same code(that works perfectly on a domain host(with host username and password changed of course))but I keep getting errors.

I tried connecting with this code

<?

$dbh=mysql_connect ("localhost", "root", "admin") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("motorcro_moto");

$query="SELECT * FROM admin";

$result = mysql_query($query) or die("Could not run query.");
$numrows = mysql_num_rows($result);

echo "numrows=".$numrows;

?>

but when I run it it returns

Could not run query.

Mysql Connection Problem
I'm having trouble with my PHP application which uses MySQL as the database. In every function that I interacts with the database, I added the connection creation object, execution of the SQL script, and finally the close connection (for recordset and connection). This worked fine on a PHP page that makes many queries via functions using persistent connection to mysql. But when I changed it to non-persistent connection, I'm not getting the results that I need. It seems the application ceased operation after the first SQL query.

MySQL Connection Sometimes Slow
I have been developing an application in Visual Basic that accesses a MySQL database either on the local machine, or a remote machine. Locally, database connections run smoothly. However, when I try to connect to the remote system (another computer on my local network) some databases take longer to connect than others (sometimes 10 - 20 seconds).

The application usses the myvbql.dll (sorry lost the link, found it through google) wrapper around the libmysql.dll file to perform database actions. The application seems to hang when it tries to actually make the connection to the datatbase. This is only happening on the remote database server, and does not happen on every connection to that server.

Connection Issue To Mysql
I got a setup of mysql/apache/php running on my home server. The server is not the most powerfull 1Go of memory 2.66 Ghz cpu, and a 2Mbits bandwith. It is running under Fedora core 3.
This should still be enough for the hosting of my home website and forum...

the issue I have is that often during the evening the connection to mysql failed for some users and for me as well from time to time. It is happening mainly when there is many visitors on the forum (100 or more)

The error message is the following :
PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /var/www/html/lib/init_variables.php on line 30

Do you have any idea of the reason of this problem? to reproduce the issue it is easy i just have to try running the apache benchmark :
ab -c 50 -n 5000 -A "admin:btd3txwn" http://192.168.0.1/testPage.phpl"

this is really annoying for the visitors of my website and it seems that this is also happening on some other website : doing a google search with mysql.sock' (11) show many results ...

Connection To MySQL Server
Shortly after calling my procedure from the mysql command prompt I get this error 2013 about losing my connection to the sql server. I have warnings enabled and wait_timeout set to 50000 but I don't get any errors about a problem with my stored proc.

MySQL ODBC Connection
This is my first task with MySQL. We have a site with php as front end
MySql as back end. The remote database is on Linux.

Now my task is to update some data to MySql database (on the web
server) from VB. My operating system id Windows.

I installed the MySQL ODBC 3.51 driver on my system. Now when i'm
trying to create a DSN with the above driver, I'm getting an error '
Lost connection to MySQL server during query'.

What could be the reason...the same error is coming when tried to
create a ADO connection from VB.. and the same error when tried to
create a service from MySQL front end.

Lost Connection To Mysql
i have mysql server located in in machine that used Red Hat 8.0 and my mysql server version was 3.23.58. I am trying to connect using my machine..And currently i used Red Hat Fedora...But when i am trying to connect to mysql server i got this error message.....

"ERROR 2013: Lost connection to MySQL server during query"
And i am also trying to killall my mysqld and start the mysql server through mysql kernel....
/usr/libexec/mysql -Sg --user=root&
After that, when i tried to reconnect it, it's hang up !.....nothing to be done and i need to start my machine back to run mysql.

Mysql Tcp Connection Error
The configuration of MySQL on my linux box is somehow set that I cannot use TCP to connect to it
When I try to logon from the CLi/telnet, it says:
Quote: [root@chrislinux chris]# mysql
ERROR 1045 (00000): Access denied for user: 'root@localhost' (Using password: NO)

If I try to use a connection within a program like Zend IDE, it says:
Quote: Server connection failure during transaction. Due to underlying exception: 'null, message from server: "Host chris.linux is not allowed to connect to this MySQL server".
I did have skip-networking uncommented but that just produced a pipe error. I have restarted mysql everytime I have made a change to my.cnf as well.
Can anyone point me where to look to possibly find the cause of this?
Thanks for any help anyone can give.

Lost Connection To MySQL
Ok heres a quick background on the situation. I run a large mysql orinated website, and tried splitting the load between 2 servers together connected via lan. On server 2 im running debian 3.0 testing/unstable with MySQL 4.0.24. When i try to execute a php mysql search script from Server 1 I get this error:

Warning: mysql_pconnect(): Lost connection to MySQL server during query ..............
Connection Error

I have searched googled, and found a possible solution, which turned out did not work. I simply added these 2 lines to my /etc/hosts.allow

/etc/hosts.allow
mysqld : ALL : ALLOW
mysqld-max : ALL : ALLOW

Also I edited /etc/mysql/my.cnf and added wait_timeout 16000

Intraweb And MYSQL Connection
I can run a simple app showing some data using delphi7 as a win32 app.
I create an intrweb standalone app and I can show the same data.
However when I compile the app as an ISAP (Dll) the browser just hangs. If I turn of the connections to MYSQL the app runs fine.
I have set the user name and password and Loginpromt to false.
I presume I need to do something different for the browser to make the connection to MYSLQ.I am using DACforMYSql Delphi 7 and intraweb 7. All full registered products.

PHP Connection To MySQL

I'm working on a simple script to create two tables within a database, and I'm sure its just some stupid error I'm making, but I cannot seem to get it to work! Here's my function: Code: