Thanks everyone for the help.
I finally got it working, but only after mucking about in the ODBC
configuration (as per Shane's suggestion) from the machine's Control
Panel. There a little button in there that says something to the effect
of 'get additional configuration from the SQL server' and gives you a
space for a user name and password to log into the SQL server. That
seemed to do it.
Jim
-----Original Message-----
From: Boothroyd, Charles J <[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Date: Friday, August 18, 2000 12:39 PM
Subject: RE: Setting Up a MS SQL Datasource
>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
