Microsoft MVP성태의 닷넷 이야기
홈 주인모아 놓은 자료프로그래밍질문/답변사용자 관리 RSS OPML Link
오류 유형: 807. C# - 닷넷 응용 프로그램에서 Informix DB 사용 시 오류 메시지 정리 [링크 복사], [링크+제목 복사],
조회: 6333
글쓴 사람
정성태 (techsharer at outlook.com)
홈페이지
http://www.sysnet.pe.kr
첨부 파일
 

C# - 닷넷 응용 프로그램에서 Informix DB 사용 시 오류 메시지 정리

연결 문자열을 이렇게 구성했을 때,

Server=db_engine_tcp; User ID=sysmaster; Password=in4mix";

이런 식의 오류가 발생한다면?

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

아래의 레지스트리에,

HKEY_LOCAL_MACHINE\SOFTWARE\INFORMIX\SQLHOSTS

db_engine_tcp 항목이 없기 때문입니다. 이에 대한 설명은 다음의 문서에 있습니다.

Setting up the SQLHOSTS registry key with Setnet32 (Windows)
; https://www.ibm.com/docs/en/informix-servers/12.10?topic=key-setting-up-sqlhosts-registry-setnet32-windows

따라서, SQLHOSTS 레지스트리에 db_engine_tcp 항목을 구성하면 되는데요, (물론 직접 입력해도 되지만) 간편하게 다음의 exe 파일을 이용할 수 있습니다.

C:\Program Files\IBM Informix Client-SDK\bin\setnet32.exe

대략 다음과 같은 식으로 구성하면 됩니다.

informix_err_1.png



만약 다음과 같은 오류가 발생한다면?

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[])

여러 가지 경우에 나올 수 있겠지만, 제가 겪은 상황에서는 "Protocolname"을 (잘 모르고 설정한) drsoctcp로 했던 경우에 발생했습니다. 그 값을 "onsoctcp"로 바꾸면 됩니다.



만약 다음과 같은 오류가 발생한다면?

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

문서상으로는 INFORMIXSERVER와 DBSERVERNAME/DBSERVERALIASES 간의 대문자 사용 등의 문제라고 하는데,

Error 761 trying to connect
; https://www.ibm.com/support/pages/error-761-trying-connect

실제로는 다른 원인일 수 있습니다. 제 경우에, 다음과 같은 식으로 연결 문자열을 지정하고,

Server=db_engine_tcp; User ID=sysmaster; Password=in4mix";

setnet32를 이용해 db_engine_tcp 항목을 만들었지만 동일하게 그런 오류가 발생했습니다. 제가 Informix에 대해 잘 알지 못해서 확실하게는 모르겠지만, 저 "Server" 값, 즉 setnet32에서 입력하는 "IBM Informix Server" 값은 임의로 부여할 수 있는 것이 아니고 Informix 데이터베이스가 설치된 서버에 등록된 정보에 의해 결정됩니다.

이 값을 알아내기 위해 Informix DB가 설치된 서버에서 sqlhosts 파일을 확인해 보면,

// docker로 올린 informix 기본 환경의 경우

$ cat $INFORMIXDIR/etc/sqlhosts
############################################################
### DO NOT MODIFY THIS COMMENT SECTION
### HOST NAME = ifx
############################################################
informix        onsoctcp        *ifx         9088
informix_dr     drsoctcp        *ifx         9089

위와 같이 나왔을 때, setnet32에 "IBM Informix Server" 값으로 "informix"를 설정해야 합니다. 그리고, 연결 문자열에서도 그 이름을 따라 설정하면 됩니다.

Server=informix; User ID=sysmaster; Password=in4mix";



아래와 같은 오류가 발생한다면?

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

말 그대로 연결 문자열에 지정한 ID/Password가 올바르지 않은 것입니다.

"Server=informix; ...[생략]...; User ID=testusr; Password=testpw";

일례로 docker container로 올린 경우 기본 사용자 정보가 informix, in4mix이므로 다음과 같이 설정하면 됩니다.

// docker로 올린 informix 기본 환경의 경우,

"Server=informix; ...[생략]...; User ID=informix; Password=in4mix";



아래와 같은 오류가 발생한다면?

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

다양한 상황에서 발생할 수 있겠지만, 제 경우에는 다음의 레지스트리에,

HKEY_LOCAL_MACHINE\SOFTWARE\Informix\Environment

INFORMIXDIR 값이 없으면 발생했습니다. (기본 설치 환경인 경우) 이런 식으로 값을 넣으면 됩니다.

이름: INFORMIXDIR
타입: REG_SZ
값: C:\Program Files\IBM Informix Client-SDK\



이런 오류는,

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

EXE가 실행된 디렉터리, 또는 설치 디렉터리에 igo4n304.dll이 없기 때문입니다.



아래와 같은 오류는,

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]

오류 메시지에도 나오지만, "iclit09b.dll"과 같은 Native DLL들을 함께 추가하지 않아서 발생한 것입니다.



.NET 5.0 Console 프로젝트에서 Informix.Net.Core.dll을 참조 추가하고 실행하면 이런 오류가 발생합니다.

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.

nuget으로부터 "System.Security.Permissions" 패키지를 참조 추가하면 됩니다.



[이 글에 대해서 여러분들과 의견을 공유하고 싶습니다. 틀리거나 미흡한 부분 또는 의문 사항이 있으시면 언제든 댓글 남겨주십시오.]





[최초 등록일: ]
[최종 수정일: 5/3/2022]

Creative Commons License
이 저작물은 크리에이티브 커먼즈 코리아 저작자표시-비영리-변경금지 2.0 대한민국 라이센스에 따라 이용하실 수 있습니다.
by SeongTae Jeong, mailto:techsharer at outlook.com
비밀번호
댓글 작성자
 


... 31  32  33  34  35  36  37  [38]  39  40  41  42  43  44  45  ...
NoWriterDateCnt.TitleFile(s)
12698정성태7/7/202111845오류 유형: 732. Windows 11 업데이트 시 3% 또는 0%에서 다운로드가 멈춘 경우
12697정성태7/7/20217688개발 환경 구성: 574. Windows 11 (Insider Preview) 설치하는 방법
12696정성태7/6/20218317VC++: 146. 운영체제의 스레드 문맥 교환(Context Switch)을 유사하게 구현하는 방법파일 다운로드2
12695정성태7/3/20218356VC++: 145. C 언어의 setjmp/longjmp 기능을 Thread Context를 이용해 유사하게 구현하는 방법파일 다운로드1
12694정성태7/2/202110378Java: 24. Azure - Spring Boot 앱을 Java SE(Embedded Web Server)로 호스팅 시 로그 파일 남기는 방법 [1]
12693정성태6/30/20218055오류 유형: 731. Azure Web App Site Extension - Failed to install web app extension [...]. {1}
12692정성태6/30/20217980디버깅 기술: 180. Azure - Web App의 비정상 종료 시 남겨지는 로그 확인
12691정성태6/30/20218734개발 환경 구성: 573. 테스트 용도이지만 테스트에 적합하지 않은 Azure D1 공유(shared) 요금제
12690정성태6/28/20219590Java: 23. Azure - 자바(Java)로 만드는 Web App Service - Tomcat 호스팅
12689정성태6/25/202110201오류 유형: 730. Windows Forms 디자이너 - The class Form1 can be designed, but is not the first class in the file. [1]
12688정성태6/24/20219862.NET Framework: 1073. C# - JSON 역/직렬화 시 리플렉션 손실을 없애는 JsonSrcGen [2]파일 다운로드1
12687정성태6/22/20217782오류 유형: 729. Invalid data: Invalid artifact, java se app service only supports .jar artifact
12686정성태6/21/202110290Java: 22. Azure - 자바(Java)로 만드는 Web App Service - Java SE (Embedded Web Server) 호스팅
12685정성태6/21/202110525Java: 21. Azure Web App Service에 배포된 Java 프로세스의 메모리 및 힙(Heap) 덤프 뜨는 방법
12684정성태6/19/20218965오류 유형: 728. Visual Studio 2022부터 DTE.get_Properties 속성 접근 시 System.MissingMethodException 예외 발생
12683정성태6/18/202110440VS.NET IDE: 166. Visual Studio 2022 - Windows Forms 프로젝트의 x86 DLL 컨트롤이 Designer에서 오류가 발생하는 문제 [1]파일 다운로드1
12682정성태6/18/20218065VS.NET IDE: 165. Visual Studio 2022를 위한 Extension 마이그레이션
12681정성태6/18/20217420오류 유형: 727. .NET 2.0 ~ 3.5 + x64 환경에서 System.EnterpriseServices 참조 시 CS8012 경고
12680정성태6/18/20218564오류 유형: 726. python2.7.exe 실행 시 0xc000007b 오류
12679정성태6/18/20219083COM 개체 관련: 23. CoInitializeSecurity의 전역 설정을 재정의하는 CoSetProxyBlanket 함수 사용법파일 다운로드1
12678정성태6/17/20218281.NET Framework: 1072. C# - CoCreateInstance 관련 Inteop 오류 정리파일 다운로드1
12677정성태6/17/20219917VC++: 144. 역공학을 통한 lxssmanager.dll의 ILxssSession 사용법 분석파일 다운로드1
12676정성태6/16/20219813VC++: 143. ionescu007/lxss github repo에 공개된 lxssmanager.dll의 CLSID_LxssUserSession/IID_ILxssSession 사용법파일 다운로드1
12675정성태6/16/20217882Java: 20. maven package 명령어 결과물로 (war가 아닌) jar 생성 방법
12674정성태6/15/20218765VC++: 142. DEFINE_GUID 사용법
12673정성태6/15/20219891Java: 19. IntelliJ - 자바(Java)로 만드는 Web App을 Tomcat에서 실행하는 방법
... 31  32  33  34  35  36  37  [38]  39  40  41  42  43  44  45  ...