성태의 닷넷 이야기
홈 주인
모아 놓은 자료
프로그래밍
질문/답변
사용자 관리
사용자
메뉴
아티클
외부 아티클
유용한 코드
온라인 기능
MathJax 입력기
최근 덧글
[정성태] 아쉽게도, 커뮤니티는 아니고 개인 블로그입니다. ^^
[정성태] 질문이 잘 이해가 안 됩니다. 우선, 해당 소스코드에서 ILis...
[양승조
] var대신 dinamic으로 선언해서 해결은 했습니다. 맞는 해...
[양승조
] 또 막혔습니다. ㅠㅠ var list = props[i].Ge...
[양승조
] 아. 감사합니다. 어제는 안됐던것 같은데....정신을 차려야겠네...
[정성태] "props[i].GetValue(props[i])" 코드에서 ...
[정성태] 저렇게 조각 코드 말고, 실제로 재현이 되는 예제 프로젝트를 압...
[정성태] Modules 창(Ctrl+Shift+U)을 띄워서, 해당 Op...
[정성태] 만드실 수 있습니다. 단지, Unity 엔진 내의 스크립트와 W...
[공진영] 안녕하세요 좋은글 감사합니다. 현재 제가 wpf로 관제 모...
글쓰기
제목
이름
암호
전자우편
HTML
홈페이지
유형
제니퍼 .NET
닷넷
COM 개체 관련
스크립트
VC++
VS.NET IDE
Windows
Team Foundation Server
디버깅 기술
오류 유형
개발 환경 구성
웹
기타
Linux
Java
DDK
Math
Phone
Graphics
사물인터넷
부모글 보이기/감추기
내용
<div style='display: inline'> <h1 style='font-family: Malgun Gothic, Consolas; font-size: 20pt; color: #006699; text-align: center; font-weight: bold'>C# - 닷넷 응용 프로그램에서 Informix DB 사용 시 오류 메시지 정리</h1> <p> 연결 문자열을 이렇게 구성했을 때,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Server=db_engine_tcp; User ID=sysmaster; Password=in4mix"; </pre> <br /> 이런 식의 오류가 발생한다면?<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > D:\temp\temp>ConsoleApp1.exe Unhandled exception. Informix.Net.Core.IfxException (0x80131937): ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Server db_engine_tcp is not listed as a dbserver name in sqlhosts. at Informix.Net.Core.IfxConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at Informix.Net.Core.IfxConnectionHandle..ctor(IfxConnection connection, IfxConnectionString constr, OdbcEnvironmentHandle environmentHandle) at Informix.Net.Core.IfxConnectionOpen..ctor(IfxConnection outerConnection, IfxConnectionString connectionOptions) at Informix.Net.Core.IfxConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at Informix.Net.Core.IfxConnection.Open() at ConsoleApp1.Program.Main(String[] args) in C:\temp\ConsoleApp1\ConsoleApp1\Program.cs:line 15 </pre> <br /> 아래의 레지스트리에,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > HKEY_LOCAL_MACHINE\SOFTWARE\INFORMIX\SQLHOSTS </pre> <br /> db_engine_tcp 항목이 없기 때문입니다. 이에 대한 설명은 다음의 문서에 있습니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Setting up the SQLHOSTS registry key with Setnet32 (Windows) ; <a target='tab' href='https://www.ibm.com/docs/en/informix-servers/12.10?topic=key-setting-up-sqlhosts-registry-setnet32-windows'>https://www.ibm.com/docs/en/informix-servers/12.10?topic=key-setting-up-sqlhosts-registry-setnet32-windows</a> </pre> <br /> 따라서, SQLHOSTS 레지스트리에 db_engine_tcp 항목을 구성하면 되는데요, (물론 직접 입력해도 되지만) 간편하게 다음의 exe 파일을 이용할 수 있습니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > C:\Program Files\IBM Informix Client-SDK\bin\setnet32.exe </pre> <br /> 대략 다음과 같은 식으로 구성하면 됩니다.<br /> <br /> <img alt='informix_err_1.png' src='/SysWebRes/bbs/informix_err_1.png' /><br /> <br /> <hr style='width: 50%' /><br /> <br /> 만약 다음과 같은 오류가 발생한다면?<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Fatal error. System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Repeat 2 times: -------------------------------- at Interop+Odbc.SQLDriverConnectW(Informix.Net.Core.IfxConnectionHandle, IntPtr, System.String, Int16, IntPtr, Int16, Int16 ByRef, Int16) -------------------------------- at Informix.Net.Core.IfxConnectionHandle.Connect(System.String) at Informix.Net.Core.IfxConnectionHandle..ctor(Informix.Net.Core.IfxConnection, Informix.Net.Core.IfxConnectionString, Informix.Net.Core.OdbcEnvironmentHandle) at Informix.Net.Core.IfxConnectionOpen..ctor(Informix.Net.Core.IfxConnection, Informix.Net.Core.IfxConnectionString) at Informix.Net.Core.IfxConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection) at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection, System.Data.Common.DbConnectionOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionPoolGroup, System.Data.Common.DbConnectionOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(System.Data.Common.DbConnection, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal, System.Data.ProviderBase.DbConnectionInternal ByRef) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory) at Informix.Net.Core.IfxConnection.Open() at ConsoleApp1.Program.Main(System.String[]) </pre> <br /> 여러 가지 경우에 나올 수 있겠지만, 제가 겪은 상황에서는 "Protocolname"을 (잘 모르고 설정한) drsoctcp로 했던 경우에 발생했습니다. 그 값을 "onsoctcp"로 바꾸면 됩니다.<br /> <br /> <hr style='width: 50%' /><br /> <br /> 만약 다음과 같은 오류가 발생한다면?<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Unhandled exception. Informix.Net.Core.IfxException (0x80131937): ERROR [HY000] [Informix][Informix ODBC Driver][Informix]INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES. sqlerrm(informix) at Informix.Net.Core.IfxConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at Informix.Net.Core.IfxConnectionHandle..ctor(IfxConnection connection, IfxConnectionString constr, OdbcEnvironmentHandle environmentHandle) at Informix.Net.Core.IfxConnectionOpen..ctor(IfxConnection outerConnection, IfxConnectionString connectionOptions) at Informix.Net.Core.IfxConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at Informix.Net.Core.IfxConnection.Open() at ConsoleApp1.Program.Main(String[] args) in C:\temp\ConsoleApp1\ConsoleApp1\Program.cs:line 45 </pre> <br /> 문서상으로는 INFORMIXSERVER와 DBSERVERNAME/DBSERVERALIASES 간의 대문자 사용 등의 문제라고 하는데,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Error 761 trying to connect ; <a target='tab' href='https://www.ibm.com/support/pages/error-761-trying-connect'>https://www.ibm.com/support/pages/error-761-trying-connect</a> </pre> <br /> 실제로는 다른 원인일 수 있습니다. 제 경우에, 다음과 같은 식으로 연결 문자열을 지정하고,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Server=db_engine_tcp; User ID=sysmaster; Password=in4mix"; </pre> <br /> setnet32를 이용해 db_engine_tcp 항목을 만들었지만 동일하게 그런 오류가 발생했습니다. 제가 Informix에 대해 잘 알지 못해서 확실하게는 모르겠지만, 저 "Server" 값, 즉 setnet32에서 입력하는 "IBM Informix Server" 값은 임의로 부여할 수 있는 것이 아니고 Informix 데이터베이스가 설치된 서버에 등록된 정보에 의해 결정됩니다.<br /> <br /> 이 값을 알아내기 위해 Informix DB가 설치된 서버에서 sqlhosts 파일을 확인해 보면,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > // docker로 올린 informix 기본 환경의 경우 $ <span style='color: blue; font-weight: bold'>cat $INFORMIXDIR/etc/sqlhosts</span> ############################################################ ### DO NOT MODIFY THIS COMMENT SECTION ### HOST NAME = ifx ############################################################ <span style='color: blue; font-weight: bold'>informix</span> onsoctcp *ifx 9088 informix_dr drsoctcp *ifx 9089 </pre> <br /> 위와 같이 나왔을 때, setnet32에 "IBM Informix Server" 값으로 "informix"를 설정해야 합니다. 그리고, 연결 문자열에서도 그 이름을 따라 설정하면 됩니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Server=informix; User ID=sysmaster; Password=in4mix"; </pre> <br /> <hr style='width: 50%' /><br /> <br /> 아래와 같은 오류가 발생한다면?<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Unhandled exception. Informix.Net.Core.IfxException (0x80131937): ERROR [28000] [Informix][Informix ODBC Driver][Informix]Incorrect password or user sysmaster@_gateway[testpc] is not known on the database server. at Informix.Net.Core.IfxConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at Informix.Net.Core.IfxConnectionHandle..ctor(IfxConnection connection, IfxConnectionString constr, OdbcEnvironmentHandle environmentHandle) at Informix.Net.Core.IfxConnectionOpen..ctor(IfxConnection outerConnection, IfxConnectionString connectionOptions) at Informix.Net.Core.IfxConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at Informix.Net.Core.IfxConnection.Open() at ConsoleApp1.Program.Main(String[] args) in C:\temp\ConsoleApp1\ConsoleApp1\Program.cs:line 46 </pre> <br /> 말 그대로 연결 문자열에 지정한 ID/Password가 올바르지 않은 것입니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > "Server=informix; ...[생략]...; <span style='color: blue; font-weight: bold'>User ID=testusr; Password=testpw</span>"; </pre> <br /> 일례로 docker container로 올린 경우 기본 사용자 정보가 informix, in4mix이므로 다음과 같이 설정하면 됩니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > // docker로 올린 informix 기본 환경의 경우, "Server=informix; ...[생략]...; <span style='color: blue; font-weight: bold'>User ID=informix; Password=in4mix</span>"; </pre> <br /> <hr style='width: 50%' /><br /> <br /> 아래와 같은 오류가 발생한다면?<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Unhandled exception. Informix.Net.Core.IfxException (0x80131937): ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -23101. at Informix.Net.Core.IfxConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at Informix.Net.Core.IfxConnectionHandle..ctor(IfxConnection connection, IfxConnectionString constr, OdbcEnvironmentHandle environmentHandle) at Informix.Net.Core.IfxConnectionOpen..ctor(IfxConnection outerConnection, IfxConnectionString connectionOptions) at Informix.Net.Core.IfxConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at Informix.Net.Core.IfxConnection.Open() at ConsoleApp1.Program.Main(String[] args) in C:\temp\ConsoleApp1\ConsoleApp1\Program.cs:line 47 </pre> <br /> 다양한 상황에서 발생할 수 있겠지만, 제 경우에는 다음의 레지스트리에,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > HKEY_LOCAL_MACHINE\SOFTWARE\Informix\Environment </pre> <br /> INFORMIXDIR 값이 없으면 발생했습니다. (기본 설치 환경인 경우) 이런 식으로 값을 넣으면 됩니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > 이름: INFORMIXDIR 타입: REG_SZ 값: C:\Program Files\IBM Informix Client-SDK\ </pre> <br /> <hr style='width: 50%' /><br /> <br /> 이런 오류는,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Unhandled exception. Informix.Net.Core.IfxException (0x80131937): ERROR [IM009] [Informix][Informix ODBC Driver]Unable to load translation shared library (DLL). at Informix.Net.Core.IfxConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at Informix.Net.Core.IfxConnectionHandle..ctor(IfxConnection connection, IfxConnectionString constr, OdbcEnvironmentHandle environmentHandle) at Informix.Net.Core.IfxConnectionOpen..ctor(IfxConnection outerConnection, IfxConnectionString connectionOptions) at Informix.Net.Core.IfxConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at Informix.Net.Core.IfxConnection.Open() at ConsoleApp1.Program.CreateSampleDB(String connectionString) in C:\Users\SeongTae Jeong\Dropbox\articles\informix_basic\ConsoleApp1\ConsoleApp1\Program.cs:line 110 at ConsoleApp1.Program.Main(String[] args) in C:\temp\ConsoleApp1\ConsoleApp1\Program.cs:line 17 </pre> <br /> EXE가 실행된 디렉터리, 또는 설치 디렉터리에 igo4n304.dll이 없기 때문입니다.<br /> <br /> <hr style='width: 50%' /><br /> <br /> 아래와 같은 오류는,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > System.DllNotFoundException HResult=0x80131524 Message=Unable to load DLL 'iclit09b.dll' or one of its dependencies: The specified module could not be found. (0x8007007E) Source=Informix.Net.Core StackTrace: at Interop.Odbc.SQLAllocHandle(SQL_HANDLE HandleType, IntPtr InputHandle, IntPtr& OutputHandle) at Informix.Net.Core.OdbcHandle..ctor(SQL_HANDLE handleType, OdbcHandle parentHandle) at Informix.Net.Core.OdbcEnvironmentHandle..ctor() at Informix.Net.Core.OdbcEnvironment.GetGlobalEnvironmentHandle() at Informix.Net.Core.IfxConnectionOpen..ctor(IfxConnection outerConnection, IfxConnectionString connectionOptions) at Informix.Net.Core.IfxConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at Informix.Net.Core.IfxConnection.Open() at ConsoleApp1.Program.Main(String[] args) in C:\temp\ConsoleApp1\ConsoleApp1\Program.cs:line 13 This exception was originally thrown at this call stack: Informix.Net.Core.OdbcHandle.OdbcHandle(Informix.Net.Core.Ifx32.SQL_HANDLE, Informix.Net.Core.OdbcHandle) Informix.Net.Core.OdbcEnvironmentHandle.OdbcEnvironmentHandle() Informix.Net.Core.OdbcEnvironment.GetGlobalEnvironmentHandle() Informix.Net.Core.IfxConnectionOpen.IfxConnectionOpen(Informix.Net.Core.IfxConnection, Informix.Net.Core.IfxConnectionString) Informix.Net.Core.IfxConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection) System.Data.ProviderBase.DbConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection, System.Data.Common.DbConnectionOptions) System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionPoolGroup, System.Data.Common.DbConnectionOptions) System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(System.Data.Common.DbConnection, System.Threading.Tasks.TaskCompletionSource<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal, out System.Data.ProviderBase.DbConnectionInternal) System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions) System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions) ... [Call Stack Truncated] </pre> <br /> 오류 메시지에도 나오지만, "iclit09b.dll"과 같은 Native DLL들을 함께 추가하지 않아서 발생한 것입니다.<br /> <br /> <hr style='width: 50%' /><br /> <br /> .NET 5.0 Console 프로젝트에서 Informix.Net.Core.dll을 참조 추가하고 실행하면 이런 오류가 발생합니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > System.TypeInitializationException HResult=0x80131534 Message=The type initializer for 'Informix.Net.Core.IfxConnection' threw an exception. Source=Informix.Net.Core StackTrace: at Informix.Net.Core.IfxConnection..ctor() at Informix.Net.Core.IfxConnection..ctor(String connectionString) at ConsoleApp1.Program.Main(String[] args) in C:\temp\ConsoleApp1\ConsoleApp1\Program.cs:line 12 This exception was originally thrown at this call stack: Inner Exception 1: FileNotFoundException: Could not load file or assembly 'System.Security.Permissions, Version=4.0.3.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified. </pre> <br /> nuget으로부터 "System.Security.Permissions" 패키지를 참조 추가하면 됩니다.<br /> </p><br /> <br /><hr /><span style='color: Maroon'>[이 글에 대해서 여러분들과 의견을 공유하고 싶습니다. 틀리거나 미흡한 부분 또는 의문 사항이 있으시면 언제든 댓글 남겨주십시오.]</span> </div>
첨부파일
스팸 방지용 인증 번호
2635
(왼쪽의 숫자를 입력해야 합니다.)