One other slightly confusing issue in this area, is the fact you can run many "instances" of SQL server, which run on different ports. not just 1433...
Just something to look out for Justin > -----Original Message----- > From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] > Sent: 06 November 2002 14:43 > To: CF-Linux > Subject: RE: Communicating with SQL2000 database from a Red Hat server > > > Steve, > > On the SQL side, make sure that the server is supporting the tcp/ip net > library and you are using "mixed" security. Tcp/ip is supported > by default, > but you have to choose "mixed" security when you install the SQL server. > Some folks running AD also remove tcp/ip in favor of named pipes (though > this is a mistake IMO). > > -mk > > -----Original Message----- > >From: Steve Johnson [mailto:steve@;stevejohnson.org] > Sent: Tuesday, November 05, 2002 4:53 PM > To: CF-Linux > Subject: Re: Communicating with SQL2000 database from a Red Hat server > > > >Does anyone know what it takes to connect up a CF application > >running on Apache/Linux to communicate > >with an SQL2000 database on a windows DB server? Are there ODBC > >drivers out there which can be > >used? Which machine do they go on? > > that's one of the included JDBC drivers. you just install CFMX and > go set up the datasource in the CF Administrator. > > make sure you're using RedHat 7.2 or earlier. > > steve > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
