For this you'll need full access to the ColdFusion Administrator
application. Here's what to do in detail:
a. Start the ColdFusion Administrator (usually found by clicking Start |
Programs | ColdFusion Server 4.x | ColdFusion Administrator).
b. Log in using the password for administrator access that you chose when CF
Server was installed.
c. Click on ODBC under the Data Sources section on the left sidebar.
d. Type the data source name ("CVR" in this example), choose the ODBC Driver
("Microsoft SQL Server Driver" in this example) and click the Add button.
e. Enter the name or IP address of the database server in the Server field.
f. In the database field enter the name of the database you created ("CVR"
in this example).
g. Click the CF Settings button and complete the username and password
fields to access this database.
h. Make sure Maintain Database Connections is checked.
i. Click the Create button. After the data source is created you should see
your list of data sources again, with "verified" next to the data source you
just created. If you don't see "verified," you must take whatever steps are
necessary until this server is able to connect to the data source. The
connection must be verified before you can continue.
> -----Original Message-----
> From: Shane Witbeck [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, August 18, 2000 6:09 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Setting Up a MS SQL Datasource
>
> I also have just set up this configuration for the first time and once I
> set
> up a login on the SQL Server and used the web server's ODBC control panel
> instead of the CF admin area, everything went smoothly. This took me a
> while
> to figure out so you may need to stock up on patience :)
>
> Shane Witbeck
> Webmaster
>
> -----Original Message-----
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 17, 2000 6:42 PM
> To: [EMAIL PROTECTED]
> Subject: Setting Up a MS SQL Datasource
>
>
> I'm setting up a Microsoft SQL7 server running on a separate server from
> my IIS/CF server. This is the first time I've set up MS SQL and the
> ODBC datasources.
>
> So far, I've attempted to set up the datasource on the IIS/CF server
> (from CF's Administrator) without much luck. Questions:
>
> Under 'Server' in the ODBC configuration, do I just specify the IP
> address of the SQL server? From the hierarchy in the SQL MMC, I gather
> that it may be a trifle more complex than this.
>
> If I have no security set up (yet) on the database, is it necessary to
> specify a 'Username'?
>
> Anything else I should know?
>
> Thanks,
> Jim
>
>
>
> --------------------------------------------------------------------------
> --
> --
> To unsubscribe, send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
>
> --------------------------------------------------------------------------
> ----
> To unsubscribe, send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
