Database

Q: How do I use MySQL with ASP?

A: For a complete tutorial please refer to this site: http://www.mazsoft.com/mysql.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 gives you an error, you'll have to assign write permission to the ENTIRE folder that contains the database file.

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 gives you an error, you'll have to assign 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 user-friendly HTTP error messages (or something similar)

Q: How do I create ODBC/DSN connections?

A: Go to Hosting Control Panel and click on the Create ODBC icon.

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.

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 an 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: What do I use to connect to My SQL?

A: You can use DBTOOLS or similar database management software.