DSN-less connections in Database panel?

[Julianne]

I have an ASP script that sends an e-mail and writes the information to a database. What I would like to do is build a page that allows me to view the records.

If I have a script that connects to a database via DSN I can set up the connection in Dreamweaver so that there's a little yellow icon in the Databases panel and I can get recordsets to show up (is that the right term - the names of the columns in the database) too.

However, the script I'm now using has a DSN-less connection string and I can't fathom out how to get the connection recognised in the Databases panel for my new page.

I assume I select the Custom Connection String option. Do I literally copy the connection string from the script and enter that? If not, how do I connect to the database with a DSN-less connection so that I'll be able to create the "view records" page?

Many thanks.

Visit my ice hockey site at:

http://www.leevalleylions.co.uk

 

[Cheech]

From DW help

To create a DSN-less connection:
Open an ASP page in Dreamweaver, then open the Databases panel (Window > Databases).
Dreamweaver displays all the connections defined for that site, if any.

Click the plus (+) button on the panel and select Custom Connection String from the pop-up menu.
The Custom Connection String dialog box appears as follows.

Complete the dialog box and click OK

[Peace][Pipe]
The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[Julianne]

That's what I've been doing but I've been getting error messages so I'm assuming there's something in the string that DW doesn't like, or I'm copying too much/not enough of the string.

Visit my ice hockey site at:

http://www.leevalleylions.co.uk

 

[Cheech]

show us what your code looks like?

Cheech

[Peace][Pipe]
The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)