ODBCConnection and ASP.NET

[Guest]

I have an ODBC connection (to Perforce) using a System DSN. In a console app
I can open the connection, in an ASP.Net webform I can't, and get the error...

[OdbcException: ERROR [HY000] [
ERROR [HY000] []

I assume it must be permissions? I have tried a few things, firstly making
ASPNET (I'm running IIS5) andAdmin user, then giving it permissions to the
System DSN registry key, but to no avail.

I'm using the 1.1 Framework and the System.Data.Odbc.OdbcConnection object.

Anbody got any ideas?

 

[Guest]

Hi

You can try

1) Set impersonate in web.config file (e.g. use your userid and password):
<identity impersonate="true" userName="accountname" password="password" />

2) Change ASP.NET account to a a domain account in machine.config file
(default Machine [or System]/AutoGenerate).
<processModel username="domainuser" password="password" ...

HTH

Elton Wang
(e-mail address removed)

 

[Guest]

I've tried (1) and that didn't work. Haven't tried (2) yet, although I gave
ASPNet admin rights.

Hi

You can try

1) Set impersonate in web.config file (e.g. use your userid and password):
<identity impersonate="true" userName="accountname" password="password" />

2) Change ASP.NET account to a a domain account in machine.config file
(default Machine [or System]/AutoGenerate).
<processModel username="domainuser" password="password" ...

HTH

Elton Wang
(e-mail address removed)

I have an ODBC connection (to Perforce) using a System DSN. In a console app
I can open the connection, in an ASP.Net webform I can't, and get the error...

[OdbcException: ERROR [HY000] [
ERROR [HY000] []

I assume it must be permissions? I have tried a few things, firstly making
ASPNET (I'm running IIS5) andAdmin user, then giving it permissions to the
System DSN registry key, but to no avail.

I'm using the 1.1 Framework and the System.Data.Odbc.OdbcConnection object.

Anbody got any ideas?