Pass Basic Security from site to SQL Server for CFQUERY?

[wmd3]

I am creating a web page (CF MX) that uses Basic Authentication and resides on our internal network.

I need to be able to access our SQL Server (version 2000, if that matters) as the current person logged into the site.

I have done this before in .NET by using the a connection string, but I now need to be able to do this in CF. And as of yet, I have not been able to get the CONNECTSTRING to work?

This is what I have tried:

<cfquery name=&quot;test&quot; dbtype=&quot;dynamic&quot; connectstring=&quot;data source=SQL.Server.Name;initial catalog=DBName;integrated security=SSPI&quot;>

Any suggestions?

 

[webmigit]

CFMX has no ability to connect through connectstring...

One of Macromedia's wonderful upgrades.. Only v5 could do this..

MX is JDBC based while v5 is is ODBC.. guess they were too lazy to keep programming. ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[wmd3]

Thanks webmigit,

That is also what I have discovered after visting a few other sites.

But, is their a way it can be done? Even if not with a connection string?

Thanks again.