Skip to main content
Participant
December 3, 2007
Question

Connection string fails in CS3

  • December 3, 2007
  • 1 reply
  • 256 views
Please tell me how to correct the following connection string to my database found at
www.lazardev.com/homepage/cosmatic/database/cosmaticdb.mdb.

The sting I'm using is
"Provider=Microsoft.Jet.OLEDB.4.0;data source=www.lazardev.com/homepage/cosmatic/database/cosmaticdb.mdb"

I'm using Dreamweaver CS3.

Cliff
This topic has been closed for replies.

1 reply

lazarcwlAuthor
Participant
December 15, 2007
This works in an IIS server:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\wwwroot\001145\ylac611b\HomePage\Cosmatic\ASP\cosmaticdb.mdb"

1. Type part exactly, including the double quote :
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\wwwroot

2. Get this part from your ISP:
\001145\ylac611b
the first six numbers are the host computer
the second six characters replace your domain

3. The last part is the path after your domain name:
\HomePage\Cosmatic\ASP\cosmaticdb.mdb"

Include the double quote.

Ask your ISP if your are in an IIS system.