For Programmers: Free Programming Magazines  


Home > Archive > Unix Programming > May 2006 > Problem connecting with a role using the .Net Data Provider









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Problem connecting with a role using the .Net Data Provider
Steve Brown

2006-05-30, 4:04 am

Hi, I'm trying to connect to an Ingres database using the .Net Data
Provider, it all works fine until I try connecting with a role:

Connection string:
" Database=dctest;ROLEID=dctest_role;ROLEP
WD=abc123;UID=user2;PWD=abc999;Server=te
sthost;BlankDate=NULL"

This fails with a Role Authentication error.

A network trace seems to show the role being passed down to the server but
not the role password.

All the details are correct and a simlar connection string works with a
legacy ODBC connection.

Has anyone else got this to work?

Thanks,

Steve


Steve Brown

2006-05-30, 4:04 am

Sorry I posted in the wrong group!

"Steve Brown" <Steve@nowhere.com> wrote the following rubbish in message
news:...
> Hi, I'm trying to connect to an Ingres database using the .Net Data
> Provider, it all works fine until I try connecting with a role:
>
> Connection string:
> " Database=dctest;ROLEID=dctest_role;ROLEP
WD=abc123;UID=user2;PWD=abc999;Server=te
sthost;BlankDate=NULL"
>
> This fails with a Role Authentication error.
>
> A network trace seems to show the role being passed down to the server but
> not the role password.
>
> All the details are correct and a simlar connection string works with a
> legacy ODBC connection.
>
> Has anyone else got this to work?
>
> Thanks,
>
> Steve
>



Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com