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
