- see footer for list info -<
Just to check... you've added it in the control panel- your new CF DSN should be an ODBC socket... do you have that and its not working?

Software Options wrote:

- see footer for list info -<


How do you connect the CF DSN to the ODBC connection generated in Control
Panel without going through the CF Administrator?

Can anyone help me with this?

Ronnie

Ronnie Auld
Applications Research - Internet Webmarketing
www.software-options.com
www.dalston.org.uk
www.craftfoods.co.uk
Tel: 01228 710740

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 10 November 2004 17:01
To: Coldfusion Development
Subject: Re: [CF-Dev] DSN Setup Problem



- see footer for list info -<



Are you using XP with SP2?

If so, I believe this is a bug and you will find similar posts on the MM forums.

The way to get around it is to create an ODBC connection in Control Panel, then connect the CF DSN to that.

HTH

paddy
----------------------------
Paddy McKay
Technical Manager, Scotland
Scottish Property Network Limited

T: +44 (0)141 561 7300
F: +44 (0)141 561 7319

www.scottishproperty.co.uk




"Software Options" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/11/2004 16:30 Please respond to Coldfusion Development


To: <[EMAIL PROTECTED]>
cc: Subject: [CF-Dev] DSN Setup Problem





- see footer for list info -<


Hello



This is my first post - can anyone please help?



I have experienced the following error when setting up a new DSN in CFMX
Administrator:



Connection verification failed for data source: test
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info.




I have done this many times, so not sure why this should suddenly happen.



Ronnie Auld

Applications Research - Internet Webmarketing

www.software-options.com <http://www.software-options.com/>

www.dalston.org.uk <http://www.dalston.org.uk/>

www.craftfoods.co.uk <http://www.craftfoods.co.uk/>

Tel: 01228 710740



_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-


- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help


-<




This email is from Scottish Property Network Limited. The E-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.


Any unauthorised dissemination or copying of this e-mail, and any use or disclosure of any attachments contained in it, is strictly prohibited and may be illegal. If you have received the E-mail in error please notify us on [EMAIL PROTECTED] or telephone 0141 5617300. Any views expressed by an individual within this E-mail do not necessarily reflect the views of the firm.

Our general contact details are;
Scottish Property Network Limited
26 New Street
Paisley
PA1 1YB

Telephone 0141 561 7300
Fax 0141 561 7319
_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-


- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<


---
[This E-mail was scanned for viruses for your protection]




_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to 
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-


- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<






_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to 
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<

Reply via email to