Dave,
I'm still confused on this. I upgraded to MX and most of my
datasources were to a SQL Server using windows authentication. When I
installed all those datasources failed to copy over. Then when I tried
to access them through the CFMX Admin it hung the server for like 5
minutes. I ended up having to delete each ds, then restart CFMX, THEN I
could recreate the ds but having to specify the username/pw of the
windows admin account.
In CF5 you used to be able to create an ODBC connection though
windows ODBC and then validate it through the CF Admin correct? Now with
MX you can't go that route? It seemed clumsy. Perhaps there's a better
way to handle it.
Greg
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 14, 2003 10:30 AM
To: CF-Talk
Subject: RE: DBAs/SQL Server experts?
> MX can act quite strange with DSNs
>
> How I get around it screwing things up:
>
> -setup System DSN through Windows ODBC (tell it to use
> Windows Authentication)
> -setup DSN in CF Admin (this is where you put the username
> and pass)
>
> If I don't do it in that order....KABOOM!!
CFMX is certainly different than CF 5, with regard to database
connectivity. However, you needn't set up an ODBC DSN to connect to MS
SQL Server from CFMX. And, if you do set one up, CFMX will only use it
if you select the "ODBC Socket" datasource option in the CF
Administrator. And, finally, if you use Windows Authentication, you
won't need a username and password in your datasource settings - Windows
Authentication will use the account that makes the connection (that is,
whatever account the CF service is running
within) for authentication.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
