|
Databases
What databases can I
use?
You may use Microsoft Access, Excel, etc.
You can not use FoxPro. Depending on what type of account you have,
you may also use SQL Server.
Except for SQL databases, when you create
a database, you will need to alert technical
support so we can make sure the permissions are set correctly.
Back to top
Where should
I put my Access database?
Databases should be put in a /database
directory. This /database directory should be at the SAME level
as the /html directory (also called the root directory), not within
it. That means that when you connect via FTP, you directory structure
will look like this:
/html
/database
If you are having trouble with this, please
call or email Technical Support and we will assist you in
creating the /database directory for you.
Back to top
How do I setup an Access
DSN?
If you have properly placed your database
in a /database directory as mentioned above, you can create an Access
DSN by going to the Control Panel.
Back to top
Can I use a DSN-less
connection?
Yes, you can use a DSN-less connection.
However, we cannot offer technical support for DSN-less connections.
Back to top
Do I replace
or update my database?
It is better to update your database, especially
if you are using SQL Server.
Back to top
Can I use a SQL Server database?
If you have a Platinum Plan or InstAccount
plan, you may use a SQL Server database. For Platinum Plan customers
there is a one-time $50 setup fee for a SQL Server database. This
setup fee is waived for InstAccount customers.
SQL Server setup consists of a 25MB database
and a 5MB transaction log. This is enough space for literally 1,500,000
records. If more space is required, it is available for $0.50/MB
per month. This fee applies to both Platinum and InstAccount customers.
If you are a Platinum or InstAccount customer,
you may request a SQL Server database at the Control Panel. This will also create a SQL Server
DSN.
Back to top
How do I request a full-text
index for my SQL Server database?
There is a $25 setup fee for creating a
full-text index on a SQL Server database. You may request this at
the Control Panel.
Back to top
How do I connect
to the SQL Server?
You will be sent the information you need
to connect to the SQL server when you request a DSN. Full instructions
are on our SQL Server
information page.
Back to top
I have created my
database, but get an "operation must use updateable query" or "permission
denied" error when accessing the database on the web.
These errors mean that the database permissions
are set to "read only". Please Email Technical Support, and include the location
of your database, so they can change the permissions to "write".
Back to top
CGI & Perl
What is CGI?
CGI stands for Common Gateway Interface.
CGI provides a method to interface a computer program with an HTML
page. CGI programs can be written to do many different things, which
includes: Chat Rooms, BBS, counters and online forms.
Back to top
Do you support CGI? What
type?
We have installed and support full CGI-BIN
access written in Perl 5. You do not need to know the path of the
Perl compiler with Windows NT. Every file that has a .pl
extension is automatically executed as a Perl script.
Back to top
Can I chmod
the directory?
On IIS 4.0 servers you simply put your
scripts in the cgi-bin directory which already has the necessary
permissions.
Back to top
Is Perl available
on the servers?
Active Perl is installed on all of our
servers.
Back to top
What is the path
to Perl on NT?
This is not required on MS IIS 4.0 servers.
The path to Perl is mapped on the server.
|
