Database Discussion - Connecting to Access

Print Page | Close Window

Connecting to Access

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=993
Printed Date: 28 March 2026 at 10:23pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Connecting to Access

Posted By: Ninel
Subject: Connecting to Access
Date Posted: 13 March 2003 at 12:26pm

A 3rd party company is doing my web hosting.

My scripts and database sit on their web server.

I need to write a connectionstring in order to connect to the database.

Their directory structure looks like this:
1. /www/companyname/scripts : I place all my asp scripts here.
2. /www/companyname/data : I place my Access database here.
3. /www/companyname/html : I place my HTML scripts here.

The DSN IP address is 64.55.188.5 on port 1433.

Would the connectionstring look something like this?

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/www/mydomain.com/data/MyDatabase.mdb; User ID=myUserid;Password=myPassword"

Thanks

Replies:

Posted By: michael
Date Posted: 13 March 2003 at 1:10pm

It would look something like this but you say the dsn is on port 1433 and 1433 is the default port for SQL Server so unless they have some odd setup it is not access you are using with that connection, it is sql server.