CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Problem in Database Connectivity

Print topic Send  topic

Author Message
Karthikeyan
Posted: 01/04/2002, 3:35 AM

I am a CF programmer and new to PHP. I downloaded the Employee Directory (template version) of PHP. I have installed PHP4.0 and mySQL in C: along with myODBC driver in my Windows system. I then created a database by name pixelempdir in mysql and created a System DSN pixel_empdir using ODBC connection. The following are the changes i did in common.php file.

// Database Initialize
$db = new DB_Sql();
$db->Database = "pixel_empdir";
$db->User = "";(not defined)
$db->Password = "";(not defined)
$db->Host = "localhost";

I am saving the files in E:\ of my system. I can see the home page when i browse it through localhost. But it is not connecting to the database and the templates also doesn't seems to be included. The header files appear simply as {header} and {footer} at the top and bottom of the pages. And the datas in combobox and textbox appears as {value} and so on. Also I am not getting any error message.
How can I verify that I am properly connected to the database?
Is there any more changes that I have to do to run the application?
Is there any problem in path specifications?
Nicole
Posted: 01/04/2002, 4:13 AM

Hello,
you should run .php files not .html ones.
Karthikeyan
Posted: 01/04/2002, 4:31 AM

I run the login.php file . ButI get the following error while logging in.
Warning: Wrong parameter count for odbc_pconnect() in E:\Inetpub\wwwroot\pixelempdir\db_odbc.inc on line 35
Database error: Link-ID == false, odbc_pconnect failed
ODBC Error: 0 ()
Session halted.
Thanks

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.