Setting up an OLE DB connection to a SQL Server database

OLE DB not only offers a performance benefit over ODBC connections (DSN) but also has some increased functionality. This article shows how to set up an OLE DB connection to a SQL Server database.

Retrieve record identity from an autonumber field on record insert.
In order to maintain the relationships between database tables or to return the identity of the record they have just created to the user it is necessary to determine the identity of the newly created record. There are many bad examples of how to do this, mainly involving the use of SQL and SELECT MAX(RecordID) to determine the highest record identity value. This article shows a more reliable way to determine the correct identity of the record created.
Using the ActivEdit Server Behavior

The ActivEdit extension is bundled with the trial version of ActivEdit 3.0. This Dreamweaver MX server behavior enables you to easily embed the ActivEdit editor into an HTML form. It is also compatible with Dreamweaver's standard server behaviors, including Insert Record and Update Record.

ActivEdit Features

  • Intuitive, Microsoft Word-style content management
  • Edit documents in Normal or HTML mode
  • Browse and insert images
  • Preview and upload images
  • Java applet offers Netscape 6+ and Mozilla support
  • Apply CSS styles using a drop-down menu
  • Full-featured image, table, and font inspectors
  • Optional spell-checking module (ActivSpell)
  • Optional scanner module (ActivScan)
  • And much more...

Extension Features

Get it now >>

Print-Ready Version
A question that I am asked quite often by other developers creating dynamic news/article content is, "How do sites like CNET and others achive the 'Print Version' that gets rid of images, banners, etc." The process is actually very simple, and uses a server behavior that comes standard with Dreamweaver UD/MX.
PHP and MySQL in Dreamweaver MX

This tutorial will walk you through the following:

  •  Installing MySQL
  •  Set up of phpMyAdmin
  •  Creating your database
  •  Connecting to database
  • Date and Time functions 101

    A short reference document to some of the Date / Time functions in SQL Server.

    Choose The Right Programming Language

    Many webdesigners have discovered that Dreamweaver now gives them the power to develop cool webapplications. In this way you can cross the border between graphical design and web application developers. We have seen a lot more basic starter questions in the Talkzones reflecting the will of many designers to explore these exciting possibilities. Questions like: "I want to build an E Commerce site for a client. Can anyone write a tutorial on how to get started with ASP and MS Access?"

    Let's start with the real basic questions first. Like what programming language are you going to use? This is a major decision to make. When i got started developing as a former webdesigner a few years ago, it took me a long time to figure out.

    Connecting Dreamweaver to MySQL & Chilisoft ASP
    A short tutorial on connecting to a MySQL database using Sun/Chilisoft ASP and Dreamweaver MX (or Ultradev 4). 
    Handling recordsets and multiple selection lists

    Filtering records using dynamically generated checkboxes or Multiple selection lists

    There is an excellent extension and a good tutorial available for deleting and updating records using checkboxes and multiple slection lists. This is based on tweaking the command-options in Dreamweaver. But when you want to use dynamically generated checkboxes or multiple selection lists to filter records, you are virtually on your own. An integrated solution for Dreamweaver is high on my whishlist, but untill then we have to do some handcoding.

    The code below is simplified for clarification. There are some more issues to this. It now uses an OR-operator which is not allways the most elegant way to retrieve data from the DB. In a next article i will cover the use of the IN operator in SQL and Dreamweaver, which does a better job. Trying to use the IN-Operator with Dreamweaver can be a very "interesting experience" since MM forgot about this very handy and common option in SQL as well.

    Newer articles Older articles