Hi All

I am diving in to EWB.

I need to connect to a MSSql database, so I have created a datamodule based on the biolife example.  Instead of using a clientdataset, I have replaced it with a ADOConnection and ADOTable. Added the module to the local server.

I have then created a EWB client to connect to this data.  When I try and download the rows into the dataset I get the error "Dataset load response error (Authentication failed)".  I tried running the url in the browser and I get the error
"Authentication failed".  I think it may be something to do with my custom module, but I do not know what to look for.

Thanks
Godfrey

Godfrey,

<< I need to connect to a MSSql database, so I have created a datamodule based on the biolife example.  Instead of using a clientdataset, I have replaced it with a ADOConnection and ADOTable. Added the module to the local server. >>

Are you using EWB 1.x or EWB 2 ?

<< I have then created a EWB client to connect to this data.  When I try and download the rows into the dataset I get the error "Dataset load response error (Authentication failed)".  I tried running the url in the browser and I get the error "Authentication failed".  I think it may be something to do with my custom module, but I do not know what to look for. >>

Yes, it has to do with handling the incoming user credentials properly.   EWB 2.x has additional functionality to make this easier with web server modules.

Per my other post, if you could post (or email) me the module code that you've got, I'll modify it to show you how it's done.

Tim Young
Elevate Software
www.elevatesoft.com

Per my other post, if you could post (or email) me the module code that you've got, I'll modify it to show you how it's done.

Tim Young
Elevate Software
www.elevatesoft.com

Project send via email

Godfrey