eHostingBiz.com - WebHosting and a Great Business Opportunity!

DATABASE

General Questions

Q: How come I can not connect to MySQL or MsSQL DB?
A: To get access to SQL server, go to your control panel and configure its control settings.

ASP

Q: Why is my ASP page returning "...must be updateable query.." messages when trying to make changes to MS Access DB?
A: This happens when your .MDB file does not have WRITE permissions. To fix the problem, go to your Hosting Control Panel, click on the File Permission icon and assign Read + Write to user IUSR_DEDI for the .MDB file.

If this still give you error, you'll have to give write permission to the ENTIRE folder that contains the database file.

Q: My ASP page is returning HTTP Error 500. How can I see the detailed error messages?
A: To see the error messages that the script is producing, please do the following steps:

Go to Extra>Internet Options, click the Advanced Tab and go to the category Surfing and uncheck the line that says:

show userfriendly HTTP error messages (or something similar)

MS Access

Q: How do I create ODBC/DSN connections?
A: Go to Hosting Control Panel and click on the Create ODBC icon.

Q: Why is my ASP page not working when trying to make changes to MS Access DB?
A: This happens when your .MDB file does not have WRITE permissions. To fix the problem, go to your Hosting Control Panel, click on the File Permission icon and assign Read + Write to user IUSR_DEDI for the .MDB file.

If this still give you error, you'll have to give write permission to the ENTIRE folder that contains the database file.

my SQL

Q: What do I use to connect to My SQL?
A: You can use DBTOOLS or similar database management software.

Q: How do I use MySQL with ASP?
A: For a complete tutorial please refer to this site: http://www.mazsoft.com/mysql.asp

MS SQL

Q: What applications can I use to connect to MS SQL?
A: You can use Enterprise Manager or similar remote administration software like CuteSQL. Here's a instruction on how to use CuteSQL:

Open the ODBC Data Source Administrator
Under 'System DSN' tab, create an 'SQL Server' driver entry
Enter the designated IP Address into the 'Server:' box
Click [Next]
Select the second radio button ("With SQL Server auth...")
Click [Client Configuration]
Select the 'TCP/IP' radio button under ---Network libraries---
'Server alias:' and 'Computer name:' should have the same IP Address
'Port number:' value defaults to 1433
Click [OK]
Check box should be checked ("Connect to SQL Server to obt...")
'Login ID:' and 'Password:' entries should correspond to submitted information in Control Panel
Click [Next]; Update settings as you wish
NOTE: your default database name should show in the top window as dimmed
Click [Next]; update settings as you wish
Click [Finish]
Run cuteSQL
From drop-downs, select 'ODBC', your DSN Name, and click the connect icon
You should be in

Q: How to get MSSQL DTS working?
A: Use Import Export Tool (DTS) - select "Copy objects and data between SQL server".

On the next screen, check only: one in the "Create Destination Objects..." - one in the "Copy Data -Replace all Data..." - and one in "Copy all objects...".

In the box "Use Default Options", uncheck it and click the "Options" button. In the following window, clear all of the Security check boxes.

Click OK, Next, Next and Finish.

This way all tables, views and stored procedures are transferred into the SQL Server Database!

Q: How do I enable Full Text Indexing for MSSQL?
A: You need to use SQL Query Analyzer tool for this.

This will enable full-text indexing for the current database:
exec sp_fulltext_database 'enable'
This creates a catalog:
exec sp_fulltext_catalog 'catalogname', 'create'
This enables indexing of a table:
exec sp_fulltext_table 'tablename', 'create',
'catalogname', 'indexname'
This adds a column to an index:
exec sp_fulltext_column 'tablename', 'columnname', 'add'
This activates fulltext on a table:
exec sp_fulltext_table 'tablename', 'activate'
These two enable automatic filling of the full-text index when changes occur to a table:

exec sp_fulltext_table 'tablename',
'start_change_tracking'

exec sp_fulltext_table 'tablename',
'start_background_updateindex'