How do I connect to my database in my scripts?

To connect to your database from your scripts, use the connection information found on the Update Database page within Helm.  To get there, click the database manager icon in Helm for your domain, then choose your database.

DO NOT use the MS SQL management IP address to connect to your database.  This is in violation of the acceptable use policy.

You can connect using a Data Source Name (DSN) by first creating your database in Helm, then creating an ODBC DSN in Helm to that database. When you connect to your database in your scripts, you can reference the DSN instead of the actual server name or IP.

For MS Access databases, if you need to use the full path (such as may be required in an Access connection string), go to the Web Site Settings page for your domain in Helm. You'll see the full path to your domain root there.  Follow that path with \db (i.e. c:\domains\\db).  This assumes you have copied your Access database to the \db directory of your domain root.
  • 5 Users Found This Useful
Was this answer helpful?

Related Articles

How do I reduce the size of my MS SQL Log Files?

MS SQL Server Databases are set to Simple backup mode, so you shouldn't see large log...

I need to move my MSSQL or MySQL database over from another host

You will need to provide us with a MSSQL .bak file or all the MySQL database files from your old...

How do I edit my MS SQL Database?

There are two ways to edit your MS SQL Database. A. You can connect to your databases online...

Can I connect to my database from a website not hosted at

No, we do not allow linking to your database from a website hosted elsewhere. This is in...

How do I edit my MySQL database?

There are two ways to edit your MySQL Database. A. You can connect to your databases online by...