|
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 give you
error, you'll have to give 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 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)
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.
Q: What
do I use to connect to My SQL?
A: You
can use DBTOOLS or similar
database management software.
|
