Programming Languages – ASP Questions

ASP support articles: all you need to know about Microsoft's server-side scripting language in relation to 20i Windows hosting.

Do you support ASP.NET?

ASP.NET is available for use on our Windows packages, which is available for 20i Resellers.

We currently support the ASP 2.0, 3.0, 3.5., 4.0, 4.5 and 4.8 frameworks.

Programming Languages

Programming Languages – ASP

Andrew Porter

Can I use parent paths in Classic ASP?

ASP Parent Paths are disabled on our platform.

As a result, Classic ASP scripts using "../" notation for includes will not work correctly.

As an alternative to using parent paths in your ASP code, you can use virtual paths. Virtual paths need you to enter the full folder path from the URL root of your website. For example, changing:

Programming Languages

Programming Languages – ASP

Lloyd Cobb

How can I show detailed ASP errors?

By default, Windows Server hides application errors from your website. You can override this by adding the following inside a 'web.config' file that will cause IIS to output any errors to your browser:

<configuration>
  <system.webServer>
      <httpErrors errorMode="Detailed" />
  </system.webServer>
  <system.web>
      <customErrors mode="Off" />
      <compilation debug="true" />
  </system.web>
</configuration>

Please be aware it's possible the <configuration> Element might already exist, therefore if this is the case just paste the rest of the code inbetween the start and the end of the element.

Programming Languages

Programming Languages – ASP

Lloyd Cobb

How do I connect to my database via .NET?

A website built using .NET can be connected to databases of different types: MySQL, MSSQL, and Access databases.

You need to use a specific connection string to connect to each database type:

MySQL

Driver={MySQL ODBC 5.3 Unicode Driver}; Server=(MySQL hostname); Port=; Option=0; Socket=; Stmt=; Database=(MySQL database name); Uid=(MySQL username); Pwd=(the password for the MySQL user);

MSSQL

A driver need not be specified when connecting to an SQL database:

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Access Database

Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=\\path_to_.mdb_file

As long as the placeholders in the above are replaced with your actual database connection details, it should allow a connection to the database.

Databases

Programming Languages

Databases – MS-SQL

Databases – MySQL

Programming Languages – ASP

Andrew Porter