| View previous topic :: View next topic |
| Author |
Message |
gillyb
-
Joined: 07 May 2005
Posts: 1
|
 Posted: Sat May 07, 2005 4:03 pm Post subject: Using ASP in dreamweaver mx |
 |
|
Hey ;)
was wondering if anyone was able to help me. im wanting to connect my access db to dreamweaver, but cant seem to get my connection string right.
what i have written is:-
"PROVIDER:Microsoft.Jet.OLEDB.4.0:DATA SOURCE=C:\Program Files\Abyss Web Server\htdocs\estateagents.mdb;"
this however keeps coming up with an error message.
any help much appreciated, thanx in advance, g |
|
| Back to top |
  |
 |
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Sun May 08, 2005 1:01 pm Post subject: Re: Using ASP in dreamweaver mx |
|
|
gillyb,
What is the error message?
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
 |
|
mcwilliams132
-
Joined: 27 Jul 2003
Posts: 167
Location: Oshkosh, WI
|
| Posted: Wed May 11, 2005 6:31 pm Post subject: |
|
|
You're string should look like this:
Dim MM_test_STRING
MM_test_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[databaseName];User ID=[username];Password=[password];"
I think your main problem is the "PROVIDER:". I think it should be "PROVIDER="...in other words...remove the ":"(colon).
Give that a shot.
I got an OLE DB Connection String Builder off of Macromedia's exchange by Thomas Muck. works great for creating custom connection strings. Free.
_________________
::::::::::::::::::::::::::::::::::::::::::::::::::
:: Jon-Paul LeClair
:: http://mcwilliamsworld.com
:: "Lobster sticks to magnet!" |
|
| Back to top |
 |
|
|
