CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Example CODECHARGE PHP + ACCESS

Print topic Send  topic

Author Message
pais18

Posts: 2
Posted: 09/12/2010, 5:28 AM

Hi,
I'm trying to create a simple web application. I'm a beginner and I need support.

I would display data in a Grid, from Access table.

Software:
Codecharge + XAMPP + Mozilla Firefox

Settings:
Database Name = dbEsempio.mdb
Path = C:\xampp\htdocs\xampp\Esempio\dbEsempio.mdb
Tables = tblArticoli
Fields = ID, MARCA, TIPO, DESCRIZIONE, PREZZO

Project Settings:
General->Code Language->PHP4\PHP5 with Templates
General->New Page Template =
General->Home page =
Server\Script->Secure Server URL =
Server\Script->Code file extension = .php
Server\Script->Encode extension =
Server\Script->Improved Http Caching = Yes
Server\Script->Output file format = Windows
Server\Script->Php version = 4.x
Server\Script->Template Folder =
Server\Script->FCKeditor base path = FCKeditor
Publishing->Active Server = Server1
Publishing->Type = Local\Network
Publishing->Server Path = C:\xampp\htdocs\xampp\Esempio
Publishing->Server URL = http://localhost/xampp/Esempio
Connection->Connection name = Connessione
Connection->Design->Connection name = Connessione
Connection->Design->Database = MS ACCESS

Connection->Design->Use connection string = Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\xampp\htdocs\xampp\Esempio\dbEsempio.mdb;Mode=ReadWrite;Persist Security Info=False

Connection->Design->User Name = Admin
Connection->Design->Password =
Connection->Server->PHP Database Library = OLEDB
Connection->Server->Database = MS ACCESS
Connection->Server->Database or Odbc connection name = dbEsempio.mdb

If I click on TEST connection, response is: Test connection succeeded. :-)

Security->Security Method = none
Security Groups = none
Caching = disable

I have added a Grid Builder, and Data Properties are:
Name = gridArticoli
Attributes =
Connection = Connessione
Data Source Type = Table
Data Source = tblArticoli
Restricted = NO
Records per page = 10
Page size limit =100
Features =

I save, publish project and page, but after I click on Live Page and an error appears:


Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][Driver Manager ODBC] Nome origine dati non trovato e driver predefinito non specificato.' in C:\xampp\htdocs\xampp\Esempio\db_oledb.php:63 Stack trace: #0 C:\xampp\htdocs\xampp\Esempio\db_oledb.php(63): com->Open('dbEsempio.mdb') #1 C:\xampp\htdocs\xampp\Esempio\db_oledb.php(81): DB_OLEDB->connect() #2 C:\xampp\htdocs\xampp\Esempio\db_adapter.php(124): DB_OLEDB->query('SELECT * ??FROM...') #3 C:\xampp\htdocs\xampp\Esempio\HeeloWorld.php(279): DB_Adapter->query('SELECT * ??FROM...') #4 C:\xampp\htdocs\xampp\Esempio\HeeloWorld.php(194): clstblArticoliSearchDataSource->Open() #5 C:\xampp\htdocs\xampp\Esempio\HeeloWorld.php(667): clsRecordtblArticoliSearch->Show() #6 {main} thrown in C:\xampp\htdocs\xampp\Esempio\db_oledb.php on line 63

:(

Please help me.
Thank you.
View profile  Send private message
datadoit
Posted: 09/12/2010, 6:58 AM

Suspect you may be seeing a permissions issue in your publishing location.

Choose Help->Submit a Support Ticket and they'll be glad to help you.
pais18

Posts: 2
Posted: 09/13/2010, 1:29 PM

Hi,
I have required help sending email to Product Support.
Goodbye.
Ivano.
View profile  Send private message

Add new topic Subscribe to topic   


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.