Re: OT? SQLServer-CFPARAM problem

2005-12-18 Thread Mike Kear
That'll be the problem Dave. It's a while back now but I'm pretty sure I used windows authentication, not mixed-mode. Can you change that setting without having to reinstall SQLServer? Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebwork

RE: OT? SQLServer-CFPARAM problem

2005-12-18 Thread Dave Watts
> No, becuase when I set up SQLServer, and installed CFMX7 > something went wrong and i can't connect to it using CF's > native drivers. Instead i have to set up a ODBC datasource > and connect to that. Can you provide more detail about the something which went wrong? I think you'd be much bett

Re: OT? SQLServer-CFPARAM problem

2005-12-17 Thread Mike Kear
No, becuase when I set up SQLServer, and installed CFMX7 something went wrong and i can't connect to it using CF's native drivers. Instead i have to set up a ODBC datasource and connect to that. If i try to connect to SQLServer using the CFMX MSSQLServer driver, I get the following message: Conn

Re: OT? SQLServer-CFPARAM problem

2005-12-17 Thread James Holmes
Perhaps it's the driver, not the DB. Can you try a native driver rather than an ODBC one? On 12/18/05, Mike Kear <[EMAIL PROTECTED]> wrote: > Not sure if this is best directed at the CF=Talk list or teh SQLServer > list, but anyway . > > Whenever I use cfqueryparam with cfsqltype="cf_sql_time

OT? SQLServer-CFPARAM problem

2005-12-17 Thread Mike Kear
Not sure if this is best directed at the CF=Talk list or teh SQLServer list, but anyway . Whenever I use cfqueryparam with cfsqltype="cf_sql_timestamp", I get the following error: [quote] Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not i