-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hmm...I would try and set up a differently named Alias for your SQL2000
installation on the CF machine like DATA2000 or something. You should be able
to do this in the Client Network Utility for SQL Server.
Do you have MDAC 2.6 installed on the CF box? It makes connecting to SQL2000
installations a whole lot easier to configure, especially when you factor in a
named instance of SQL2000.
HTH!
Joe
==============================================
Joseph Cruz
Programmer/Analyst
Wharton Computing
3620 Locust Walk, Suite 400
Philadelphia, PA 19104-6302
(215) 898-1220 (w)
(215) 308-0657 (p)
(215) 768-2071 (m)
[EMAIL PROTECTED]
============================================
> -----Original Message-----
> From: Brunelle, John [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 26, 2001 3:22 PM
> To: SQL
> Subject: CF Admin - SQL Server Instances Prob
>
>
> Hi All.
>
> Got a problem with getting cf admin ODBC sources to verify.
> I was wondering if anybody has created two instances of
> SQL Server on a database server one for SQL7.0 and the
> other SQL2000 and tried connecting the ODBC source through
> cf admin on another server(web server). I keep failing. I am
> thinking it has to do with either the server field or the
> database field in the CF Admin ODBC edit screen. Is there a
> certain way to name the server for each instance in the edit
> fields????
>
> ex.
> Server Name: data
> SQL Server Instances:
> instance 1(sql7.0) name: data
> instance 2(sql2000)name: data/data1
>
> I have tried various combinations in the server field
> of cf admin with no luck so far for either instance.
>
> such as: data.data1, data/data1, (data.data1), and even
> data or (data) does not work.
>
> any help would be appreciated.
>
> Thanks,
>
> John Brunelle
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
