Control Panel Forum Hosting Help 6 Months free Hosting (New!) Resources

Total members: 76855
Average new registrations per day (in last 7 days): 84

New Registration: Open

Register Now

Home » Tips » Connection strings for MS Access and SQL Server Express

General	Hosting Features	Upgrade Options	Server Issues
Coding Questions	Security & Permissions	Site Promotion

Connection strings for MS Access and SQL Server Express

09 Nov, 2005

Summary
Learn how to connect to SQL Server Express and MS Access database

How to connect to SQL Server Express ?

We have installed SQL Server 2005 Express and our members are allowed to use the SQL Server service for free.

If you want to upload or create SQL Server 2005 Express database, see this page.

Connection string for SQL Server Express

You are allowed to upload and attach SQL Server databases. The database will be created with UserId as prefix. For example, if you attach an SQL Express database with the name 'Employees', the actual database name will be YourUserId_Exployees.

Here is a sample connection string to connect to SQL Server from your free web hosting account:

"Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=YourUserId_DatabaseName"

Connection string for MS Access database

You may upload your MS Access database to the "database" folder, using the "File Manager". After uploading, you may go to the "Database Manager" to manage files (executing query etc)

You may upload any number of MS Access databases, within the limit of your disk space quota.

Your physical path varies by the domain name you have selected. Here is some sample connection strings to connect to your MS Access databases:

AspSpider.NET

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MemberSites\MemberSites_AspSpider_Net\YourUserId\database\DatabaseName.mdb"

AspSpider.ORG

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MemberSites\MemberSites_AspSpider_Org\YourUserId\database\DatabaseName.mdb"

AspSpider.BIZ

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MemberSites\MemberSites_AspSpider_Biz\YourUserId\database\DatabaseName.mdb"

AspSpider.INFO

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MemberSites\MemberSites_AspSpider_Info\YourUserId\database\DatabaseName.mdb"

AspSpider.WS

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MemberSites\MemberSites_AspSpider_Ws\YourUserId\database\DatabaseName.mdb"

Related Topics:

How to use SQL Server 2005 Express database
How to use MS Access database