Coding for Database connection (Brinkster)

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Coding for Database connection (Brinkster)

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> Dreamweaver Help >> Coding for Database connection (Brinkster)

Page: [1]


musicalbell Posts: 2 Joined: 2/28/2008 Status: offline	Coding for Database connection (Brinkster) - 2/28/2008 2:55:54 I'm a beginner learning web design with Dreamweaver MX and now start dealing with database and recordset. Here's a bit of the background (you may skip this paragraph). At first I have troubles with web server because my WinXP Home doesn't have IIS or PWS, so I went for alternative and installed Apache...BUT it doesn't seem to come with ASP mode. Alas...so I abandon testing server completely and just upload it to the web. So...here comes a problem when I attempted to upload my asp files to the web. I DON'T KNOW HOW TO DEAL WITH CONNECTION!!! Do I need to change the coding of my connection file? How? Here's my code, can anyone change it for me please. <% ' FileName="Connection_ado_conn_string.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="false" ' Catalog="" ' Schema="" Dim MM_connSongofsoul_STRING MM_connSongofsoul_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\SongOfSoul\songofsoul.mdb; pwd=cyl12321" %> By the way, I got my free web hosting from Brinkster, and they provide me with this link http://kb.brinkster.com/Kb.asp?kb=108078 when i asked for coding support. Besides the connection file, do I need to change anything to my database .mdb files and the other .asp files? Please help...especially the coding part...

Spooky

Posts: 26559
Joined: 11/11/1998
From: Middle Earth
Status: offline

RE: Coding for Database connection (Brinkster) - 2/28/2008 18:48:48

It would be something like this:

MM_connSongofsoul_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

              "Data Source=C:\sites\Single??\UserName\database\songofsoul.mdb;" & _

              "Persist Security Info=False"

However you will need to do this :

quote:

The following path reference is not specific: C:\sites\Single??
Please log into your account, select Website Settings, and use the absolute path to your file structure.

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

��k�

Database / DRW help Check out the Tutorials for Frontpage Databases

Forum FAQ' s

Developers Edition Spooky Login User Registration and Management tool

Personalized Frontpage Hosting

(in reply to musicalbell)