Data Source Settings

If you are not at the [Database] tab yet, clicking the icon in the toolbar to go to [Database] tab. ASP XMLMaker can connect to Microsoft Access, Microsoft SQL Server, MySQL, Oracle and other databases that supports ODBC or ADO Connection String.

formatted usb drive recovery	hard disk file recovery	digital picture recovery
best data recovery software	download data recovery tools	data recovery software
laptop data recovery	freeware password recovery	free invisible keylogger

1. Microsoft Access Setup

Select Microsoft Access as database type,
Select the Microsoft Access database file by clicking the button,
Specify the database path where the database file will reside under the root of your ASP Web application,

Note: The database path is relative to application root. Use slashes "/" as path delimiter, no leading slash. e.g. If the application root of your website is C:\Inetpub\wwwroot\demo and you enter "data/" in this textbox, the folder for the database will be C:\Inetpub\wwwroot\demo\data. If you are not sure which folder is application root, please read Creating Virtual Directories in IIS.
Click the Connect button to load the database information.

Database

2. Microsoft SQL Server Setup

Select Microsoft SQL Server as database type,
Enter the name or IP of the SQL server,

Note:
1. The server name or IP should be valid on your production Web server also. Otherwise you'll need to modify the generated connection string in db.asp before you upload it to your production server. For example, if you have a testing SQL Server installed on the same computer, you can use "(local)" as server name when you connect to it with ASP XMLMaker. The generated scripts will then try to connect to a SQL Server on the same computer as the production Web server, if this is not the case on the server, the connection will fail. It is common that SQL Server is installed on a different server in production environment.
2. If you want to use trusted connection with integrated authentication, you can connect using Connection String (see section below). However, note that in this case you'll need to make sure the Web sever user (e.g. "IUSR_<MachineName" if anonymous access is allowed) has appropriate access to the database. Otherwise, you will most likely see an error message such as "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.", when you try to launch your ASP application.
Enter the User ID and Password,
Select the database you want or just enter the name of your database,
Click the Connect button to load the database information.

Database

3. MySQL

Note: If you have installed MyODBC 3.51 on your computer, this database type will be available for selection. You can download MyODBC from the MySQL website.

Select MySQL as database type,
Enter the name or IP of the SQL server,

Note: The server name or IP should be valid on your production Web server also. Otherwise you'll need to modify the generated connection string in db.asp before you upload it to your production server. For example, if you have a testing MySQL Server installed on the same computer, you can use "localhost" as server name when you connect to it with ASP Maker. The generated scripts will then try to connect to a MySQL Server on the same computer as the production Web server, if this is not the case on the server, the connection will fail.
Enter the User ID and Password,
Select the database you want or just enter the name of your database,
Click the Connect button to load the database information.

Database

Home | Contact Us | Request to publish your help manuals | Request to remove your help manuals