Have solved it by loading MDAC 2.7 which contained a driver for SQL2000. Everything works fine now.
-----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 02 April 2003 12:40 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Datasources in CF5 The ones that conme with CF work fine. You should check that the uername/pass u are using are correct and that the CF server can connect to the SQL server. Also check in the control panel/ODBC datasource sthat the connection has been setup using TCP/IP and not named pipes. HTH Russ -----Original Message----- From: Osullivan Karl (RKB) Senior Analyst/Programmer [mailto:[EMAIL PROTECTED] Sent: 02 April 2003 09:21 To: CF - Development Group Subject: [ cf-dev ] Datasources in CF5 UHCWT Logo Hi I'm setting up a datasource in CF5 to a MS SQL2000 server. Everytime I try and complete, it fails. Can I use the Microsoft SQL Server Driver that comes with CF5 for SQL2000, or do I need to load some different drivers onto the server? Thanks Karl O'Sullivan Senior Analyst/Programmer Computer & Network Services UHCW NHS Trust Clifford Bridge Road COVENTRY CV2 2DX Contact: Tel (internal): 28952 Tel (external): +44 (0) 24 7596 8952 Email: [EMAIL PROTECTED] Web: www.uhcw.nhs.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
