CodeCharge Studio
search Register Login  

Visual PHP Web Development

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

YesSoftware Forums -> CodeCharge Studio -> Español

 Problemas para ingresar en la base de datos

Print topic Send  topic

Author Message
Sevans1982

Posts: 3
Posted: 08/18/2007, 3:40 PM

Recién estoy empezando a usar CodeCharge Studio. No tuve ningún problema para conectarme con la BD, pero a la hora de ingresar un nuevo registro me reporta el siguiente error.
[MySQL][ODBC 3.51 Driver][mysqld-5.0.18-nt]Field 'PacienteID' doesn't have a default value (Microsoft OLE DB Provider for ODBC Drivers).
¿que es lo que tengo que hacer?
View profile  Send private message
leosweden

Posts: 61
Posted: 08/18/2007, 3:44 PM

Hola

Por favor envia la Bd. que hiciste.

Leo
View profile  Send private message
Sevans1982

Posts: 3
Posted: 08/19/2007, 12:49 PM

Por ahora, al tratase de un prueba la BD es una sola tabla llamada Pacientes, cada paciente tiene un ID, nombre, apellido, teléfono y dirección. El código que se genera es ASP 3.0, yo lo que hice fue generar una aplicación a partir de esa BD que ya había generado anteriormente(bastante antes de conocer la herramienta). Se generan de forma automática varias páginas para realizar consultas sobre los datos existentes, eso funciona bien. Pero en la página de gestión de pacientes es donde surge el problema... tal vez tenga que agregar algún código al botón de "add".

¿Existe alguna forma de subir los archvos de la BD a este foro?
View profile  Send private message
leosweden

Posts: 61
Posted: 08/19/2007, 1:45 PM

Hola

Ya veo,parece que la base de datos es MS access, para ingrezar nuevos registros es necesario :

Cuando trabajes con ASP y Access, tienes que instalar el IIS de windows que viene con el XP PROFESIONAL únicamente. O bien trabajar con PHP, (OBDC, Xammp) y Mysql

En que trabajaras? tienes hosting apache o windows?
View profile  Send private message
Sevans1982

Posts: 3
Posted: 08/19/2007, 1:48 PM

Tengo instalado IIS y utilizo MySQL(perdoná que no lo especifiqué). ¿Existe algún doc que explique esto en detalle?
View profile  Send private message
leosweden

Posts: 61
Posted: 08/20/2007, 12:38 PM

Primero, en que hosting piensas publicar?

Linux o Windows ?

En fin, aqui está tu documento....
_________________________
Setting up the work environment
CodeCharge Studio has several possible configurations based on the programming language and database being used. Each combination of language and database has its own unique merits. In each of the following tables, we examine some of the typical setups for each language.

Note: You can use setups beyond those show below.

ASP Setup
A common configuration for the development of ASP applications:

Development Environment (for the development and testing of applications):
A Windows desktop computer with an installation of CodeCharge Studio.
A local MS Access database (or a copy of a remote MS Access database) or a local or remote SQL server.
PWS or IIS Web Server with VBScript 5.5 support or higher.
Server Environment (for hosting the final application):
A Windows server, such as Windows NT Server or Windows 2000 Server.
An MS SQL database.
IIS Web Server with VBScript 5.5 support or higher.
The following table provides a list of applicable operating systems, web servers, databases, and language version options for ASP and Templates.

ASP Setup
Server Operating System Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP
Web Server Internet Information Services (IIS) 4.0 or 5.0, Personal Web Server
Scripting Engine/Language ASP 3.0 with VBScript 5.5+

Database Server Microsoft Access, MS SQL Server, Oracle, MySQL, PostgreSQL, DB2, FoxPro, or other database via ODBC

The following is a list of steps that should be performed to setup and test the environment where the ASP pages will be published. These steps don't have to be followed strictly in the order in which they are presented below.

Install and configure the web server software
Some versions of Windows such as Windows NT Server, Windows 2000 Server and Windows XP Professional have the option of installing IIS server during the operating system installation process or later from the operating system setup CD. If your version of Windows does not allow the installation of IIS (e.g. Windows 98) you can install Personal Web Server (PWS) which is a scaled down version of IIS Server. The YesSoftware website has a tutorial that contains more information about installing and configuring PWS.

Test the Web Server
After installing the web server software, you should run a test to make sure that the server is functioning properly. For a server that has been installed on the local machine, the URL http://localhost/ or http://127.0.0.1/ can be used to test the server. When you type in this address you should be able to see the default page in the root directory of the server. In particular, you should test a .asp page since this is the language you will be generating pages in. By default, the IIS server will bring up the .asp page (http://localhost/localstart.asp). Both IIS and PWS come with extensive documentation which you should consult for detailed setup, configuration and testing instructions.

Setup the Database
Once you confirm that you have a fully functional web server make sure that you have a suitable database to use. The easiest database to use for ASP is Access. In order for the web pages to be able to use the Access database, the security settings for the database have to be setup correctly. Make sure that the database file is not opened in exclusive mode by any other user. Using Windows Explorer, right-click on the database file and open the properties dialog. Under the security tab, make sure everyone has access to the file, or at the least the IUSR_MachineName account should have Read and Write Permissions on the file. The IUSR_MachineName account is the account that is used by the web server to access the database.

If you are using a different database such as MS SQL server or Oracle, make sure that you have an account in the database with which you can access the required tables.

Create and Test a CodeCharge Studio Project
CodeCharge Studio comes with a number of example projects that you can easily generate and publish as a way of testing your setup. Each of these examples comes with an Access database as well as a database script file that you can use to recreate the database. Please refer to the section on the example solutions for detailed instructions on how to setup and use them.

You can also refer to the Quick Start section within the documentation for step-by-step instructions to create and publish your first web application and the section on deploying ASP projects.

PHP Setup
A common configurations for the development of PHP applications:

Development Environment (for the development and testing of applications):
A Windows desktop computer with an installation of CodeCharge Studio.
Local or remote MySQL database.
MyODBC driver (required during the design mode, but not during run-time).
Apache Web server.
PHP 4.1 or higher.
Server Environment (for hosting the final application):
A Linux server.
MySQL database (local or remote).
Apache Web server.
PHP 4.1 or higher.
Note: The MyODBC driver is only needed during the application design stage. The generated code can access the database directly without an ODBC driver. You can obtain the MyODBC driver from www.mysql.com.

The following table provides a list of applicable operating systems, web servers, databases, and language version options for PHP.

PHP Setup
Server Operating System Unix/Linux, Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP
Web Server Apache, Internet Information Services (IIS) 4.0 or 5.0, Personal Web Server
Scripting Engine/Language PHP 4.1 or higher
Database Server MySQL, PostgreSQL, Microsoft Access, MS SQL Server, Oracle, DB2, FoxPro, or other database via ODBC

The following is a list of steps that should be performed to setup and test the environment where the PHP pages will be published. These steps don't have to be followed strictly in the order in which they are presented below.

Install and configure the web server software
The PHP engine can be installed on a wide variety of web servers including IIS, PWS, and Apache. The procedure for installing the PHP engine varies depending on the web server being used. The PHP engine can be downloaded from http://www.php.net where you will also find information on how to perform the installation. You can also download the free Apache web server along with its documentation from http://www.apache.org.

Test the Web Server
After installing the web server software, you should run a test to make sure that the server is functioning properly. For a server that has been installed on the local machine, the root URL http://localhost/ or http://127.0.0.1/ can be used to test the server. Please refer to the documentation for the server you have installed for information on how to confirm that the installation was successful.

Setup the Database
It is common to use the MySQL database when publishing in PHP. You can download MySQL from http://www.mysql.com where you will also find documentation for the database as well as a link to download the MyODBC driver which can be used to make an ODBC connection to a MySQL database during design time.

Create and Test a CodeCharge Project
CodeCharge Studio comes with a number of example projects that you can easily generate and publish as a way of testing your setup. Each of these examples comes with an Access database and a database script file that you can use to recreate the database. Please refer to the section on the example solutions for detailed instructions on how to setup and use them.

You can also refer to the Quick Start section within the documentation for step-by-step instructions to create and publish your first web application and the section on deploying PHP projects.
View profile  Send private message
Oper


Posts: 1181
Posted: 08/21/2007, 6:43 AM

PacienteID debe deser Autonumerado(AutoIncrement) ó si esposible que se quede en blanco quita la opcion de Not Null.

pero estoy seguro que es lo primero.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
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.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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