Try putting the (servername.database) This should take care of the problem.
CW
-----Original Message-----
From: Brunelle, John [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 4:45 PM
To: SQL
Subject: ODBC Source for Seperate SQL Server
Just wondering if anybody has set up an ODBC source for SQL in the Cold
Fusion Administrator?
The problem is that the database is on another server and I can not seem to
get the ODBC to verify. I think I may be putting the wrong info in the
server field of Edit ODBC Data Source [Microsoft SQL Server Driver] screen.
In this field I have (PDCDATA1) which is the name of the sever the sql
server is on... is this right or do I need IP address here. Or, can my
problems exist elsewhere... password and username look good and trusted is
on..??? Any help in this manner would be greatly appreciated.
Thanks,
John Brunelle
FMHI Web Programmer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
