Data Source Name Some DSN
Description Whatever
Provider SQLOLEDB
Server \\yourserver\pipe\sql\query (or IP address - depends which
net
lib you use)
Default Database YourDBName
ColdFusion Login
Username <Database username>
Password <Database password>
And that should be all you need.
Make sure your db user is set up correctly. Best to test the connection
using sa first just to make sure you can connect then create a user
specifically for that db.
Steve
> -----Original Message-----
> From: Nille af Ekenstam [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 17, 2000 11:46
> To: [EMAIL PROTECTED]
> Subject: Re: OLEDB
>
>
>
> >----- Original Message -----
> >From: "Nille af Ekenstam" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Sunday, July 16, 2000 2:22 PM
> >Subject: OLEDB
> >
> >
> > > Hi
> > >
> > > Anybody know of a good cf tutorial/sample using OLEDB? I
> don't even know
> > > how to set it up using the CF Administrator. Any pointers
> would be very
> > > appreciated.
> > > Btw, I'm using CF 4.51 Enterprise on W2K Server and MS SQL 7.0 ad DB.
> > >
> > > Thanks!
>
> Mooner Ent skrev:
> >There's a MUST read in one of this years Cold Fusion Journal,
> sorry I don't
> >remember which one.
> >
> >There's a bug that won't let you do it the intuitive way.
> >
> >Rick
>
> Has anybody managed to set up an OLE DB datasource in CF Administrator
> using MSSQL7.0?
> If so; how did you do it? What data goes in to the fields to set it up
> successfully?
> All my attempts fail.
>
> //Nille
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
