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.

 

Back to FAQ