When you were creating the did you create the data source in the ColdFusion
administrator?
Connecting to a data source with ODBC Socket
In ColdFusion 5, an ODBC Data Source Name (DSN) entry that was
created with the ODBC Data Source Administrator would automatically
show up in the list of data sources in the ColdFusion Administrator.
It does not in ColdFusion MX; you must manually add the ODBC DSN
entry.
To manually add the ODBC DSN entry:
1. In the ColdFusion Administrator, select Data & Services > Data
Sources.
2. In the Add New Data Source Name box, do the following:
a. In the Data Source Name text box, enter the data source
name.
You can use the same name as the ODBC DSN entry.
b. In the Driver drop-down list box, select ODBC Socket.
c. Click Add.
3. In the ODBC DSN drop-down list box, select the ODBC DSN name.
4. Click Submit.
"Cold Fusion"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
com> cc:
Sent by: Subject: RE: [KCFusion] Problems
creating SQL Server datasource
[EMAIL PROTECTED]
fusion.org
03/05/03 03:01
PM
Please respond
to CF-List
Sorry for the vagueness of my earlier message. I find errors in two places.
First, there is the error that CFAdmin throws when it can't verify the
datasource.
<Start Error 1>
Connection verification failed for data source: MYDSN
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info.
<End Error 1>
Also, I found the following errors on the machine that is running
ColdFusion
Server.
<Start Error 2>
The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Agent )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer.
The following information is part of the event: ColdFusion MX ODBC
[EMAIL PROTECTED],ErrorCode=3012,ErrorMessage=Configuration file was changed
by someone else.,ClientHost=10.110.71.24,Session=33.
The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Agent )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer.
The following information is part of the event: ColdFusion MX ODBC
[EMAIL PROTECTED],ErrorCode=3012,ErrorMessage=Configuration file was changed
by someone
else.,ClientHost=10.110.71.24,Session=5,ClientUserName=Domain\User.
The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer.
The following information is part of the event: ColdFusion MX ODBC
[EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection reset by
peer.
<End Error 2>
I don't see any messages in the CF Server log or SQL Server Event Viewer.
Phil
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
