Is there any way to convert that to an SQL/remote server database string?
The other option is of course to create a DSN with cfregistry/factory
services. Keep in mind that if you can't comfortably code the registry
changes to create a dsn you shouln't be scripting registry changes ;>
Also depends on cfregistry being enabled in pre mx versions, but since
factory services can't be locked down :)
----- Original Message -----
From: "Trent Shepherd" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 2:30 PM
Subject: [cfaussie] Re: DSN LESS CONNECTION
> Here is a snippet I picked up some where for access db
>
> CFQUERY NAME="insertdata" datasource=#REQUEST.DSNMain#>
> INSERT INTO
`#CurrentDirectory#DB\MERCHANT#variables.MerchantID#TEMP.mdb`.ProductLinks
(field1)
> VALUES('data1')
> </CFQUERY>
>
> or use with FROM.
>
> The datasource=#REQUEST.DSNMain# is just a dummy. The key is putting the
full path and database name with a dot table name as shown.
>
>
> cheers
> trent
>
>
>
> ---------- Original Message ----------------------------------
> From: "Carl" <[EMAIL PROTECTED]>
> Reply-To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
> Date: Wed, 22 Jan 2003 15:04:50 +1100
>
> >Hi CF Aussie,
> >
> >just wanting to know if any know of how to set the variables of a dsn
less
> >connection for Cold Fusion (Running CF MX)
> >
> >I think it looks something like this???
> >
> >
> >Provider=SQLOLEDB; datasource=SERVER-WHERE-SQL-SITS; Initial
> >Catalogue=DATABASENAME; User ID=USERNAME; Password=PASSWORD"
> >
> >Carl
> >
> >
> >
> >---
> >You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> >To unsubscribe send a blank email to
[EMAIL PROTECTED]
> >
> >MX Downunder AsiaPac DevCon - http://mxdu.com/
> >
>
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
[EMAIL PROTECTED]
>
> MX Downunder AsiaPac DevCon - http://mxdu.com/
>
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
