Windows 2000 Menu
Windows 2000 Main
Windows 2000 Hosting Plans
Windows 2000 FAQ's
H-sphere Documentation
Order a Windows 2000 Plan


Hosting Solutions
Red Hat Linux - cPanel
Windows 2000
FreeBSD




KNOWLEDGE BASE

Jump to 

Databases

1. What are the Databases that your Windows Hosting Support?
2. Your hosting table specify a qouta for every kind of Database. Is that for every database created?
3. How many databases am I allowed to create?
4. How can I create and use a File DSN?
5. What should my connection string look like for a system DSN?
6. How can I connect to my database using DSN-less connection?


What are the Databases that your Windows Hosting Support?
Our Windows hosting supports MySQL, MSSQL, PostgreSQL, MSACCESS/ODBC.

Back To Top

Your hosting table specify a qouta for every kind of Database. Is that for every database created?
The database qouta applies from the whole database in your account.

Back To Top

How many databases am I allowed to create?
The number of database you can create is actually not metered. So you may create as many as you like, as long as you do not go beyond your database qouta.

Back To Top

How can I create and use a File DSN?
The following is an example of a file DSN:

Set DSNConn = Server.CreateObject("ADODB.Connection")
DSNConn.Open "DBQ=" & Server.MapPath("\database.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20;", "admin", ""

Back To Top

What should my connection string look like for a system DSN?
This will work…
Session("DataConn_ConnectionString") = "DSN=mydsn"

so will this…
Session("DataConn_ConnectionString") = "DSN=mydsn;UID=;PWD=" If you are trying to use a file DSN it probably won't work.

Back To Top

How can I connect to my database using DSN-less connection?
Your DSN-less connection may look like this:

connect_string = "Driver={Mssql}; Server=localhost; Database=mydatabase; UID=myuser; PWD=Shhhhhh!"

Back To Top

 

 

   
Support | Forums | Terms of Service | Acceptable Use Policy | Contact Us
©Copyright 2003 Dreamcode Web Hosting