I am working on a project that replaces this desktop client application with a web frontend application. The desktop application is configured to only work if the sql server authentication is set to 'Windows only'. Both the applications are meant to connect to the same sql server. Because of the way the sql server is configured (ie windows only authentication), I can't get ColdFusion to validate the datasource name with a windows login username.
Is it possible to get a cfquery tag to pull data from a sql server (with the above configuration) without specifiying the "datasource" attribute? I've noticed that cfquery has the following attributes:
dbserver
dbname
username
password
I'll really appreciate your help
Best regards,
cfcoder
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
