Advertise with us

Control Panel Forum Hosting Help ASP.NET 4.5 & SQL 2012 Hosting Resources Notice

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

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

New Registration: Open

Register Now

Talk to Webmaster
Tony John

Facebook
Google+
Twitter