I'm getting some very strange errors on boiler plate odbc connection code. The code connects to DB2 (which is always a joy to work with) and has never given me issues in the past. This is your typical work ghost....one day it just stopped working. This is happening on 2 separate instances of Windows 2003 servers. On my local machine the code works fine. The code is connecting via a system dsn setup via the IBM DB2 CONNECT components.
One error I get reads:
ERROR [08004] [IBM][CLI Driver] SQL1092N "ASPNET" does not have the authority to perform the requested command.
This happens even after I place the ASPNET account in both the DB2ADMINS and DB2USERS groups. I know the DB2USERS group should have permissions enough, but I tried DB2ADMINS just for kicks, yet neither of them work.
In my other applcation, which is using the exact same system dsn (well, it's trying to anyhow), The error message is simply blank....there isn't one. The stack trace reads:
at System.Data.Odbc.OdbcConne
ction.Hand
leError(Od
bcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConne
ctionHandl
e..ctor(Od
bcConnecti
on connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConne
ctionFacto
ry.CreateC
onnection(
DbConnecti
onOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.D
bConnectio
nFactory.C
reateNonPo
oledConnec
tion(DbCon
nection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.D
bConnectio
nFactory.G
etConnecti
on(DbConne
ction owningConnection)
at System.Data.ProviderBase.D
bConnectio
nClosed.Op
enConnecti
on(DbConne
ction outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConne
ction.Open
()
at code class ... line xxx //abridged
at form class ... line xxx //abridged
I'm at an utter loss here...it worked....and now it doesn't...
Here is the odbc code: