ODBCConnection and ASP.NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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've tried (1) and that didn't work. Haven't tried (2) yet, although I gave
ASPNet admin rights.

Elton W said:
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)



jebloomer said:
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?
Click to expand...
Click to expand...
 
Back
Top