What version of ColdFusion are you using Sanjay? As Fiona says, try setting it up first in >administrative tools/ODBC data sources -- then create a new datasource in CF administrator and set the driver type to ODBC socket and connect to the one you created.
HTH d -----Original Message----- From: sanjay sidar [mailto:[EMAIL PROTECTED] Sent: 21 March 2004 17:28 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] HOW TO CREATE AN SQL DATABASE I am trying to create a database using sql, i am doing my final year uni project on coldfusion mx, and sql server. When i go into cf administrator and then into datasourses, and try to add in a database i get several errors, i have checked my username and password, they are all right what else could it be??? >From: "Snake Hollywood" <[EMAIL PROTECTED]> >Reply-To: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: RE: [ cf-dev ] WooHoo It works ... >Date: Fri, 19 Mar 2004 23:28:07 -0000 > >And I am Automan.... > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > Sent: 19 March 2004 11:52 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] WooHoo It works ... > > > > > > > > Yes I am SQL server 2k > > > > > > > > > > ************************************************************** > > *********************************** > > The information contained within this e-mail (and any > > attachment) sent by Birmingham City Council is confidential > > and may be legally privileged. It is intended only for the > > named recipient or entity to whom it is addressed. If you are > > not the intended recipient please accept our apologies and > > notify the sender immediately, or telephone +(44) 121 303 > > 6666. Unauthorised access, use, disclosure, storage or > > copying is not permitted and may be unlawful. Any e-mail > > including its content may be monitored and used by Birmingham > > City Council for reasons of security and for monitoring > > internal compliance with the office policy on staff use. > > E-mail blocking software may also be used. Any views or > > opinions presented are solely those of the originator and do > > not necessarily represent those of Birmingham City Council. > > We cannot guarantee that this message or any attachment is > > virus free or has not been intercepted and amended. > > > > ************************************************************** > > *********************************** > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > > http://forum.cfdeveloper.co.uk/ > > Archive: > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > CFDeveloper Sponsors and contributors:- > > *Hosting and support provided by CFMXhosting.co.uk* :: > > *ActivePDF provided by activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow > > provided by proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists > > hosted by gradwell.com* > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > >-- >These lists are syncronised with the CFDeveloper forum at >http://forum.cfdeveloper.co.uk/ >Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >CFDeveloper Sponsors and contributors:- >*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided >by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by >proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by >gradwell.com* > >To unsubscribe, e-mail: [EMAIL PROTECTED] > _________________________________________________________________ Find a cheaper internet access deal - choose one to suit you. http://www.msn.co.uk/internetaccess -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
