Microsoft MVP성태의 닷넷 이야기
홈 주인모아 놓은 자료프로그래밍질문/답변사용자 관리 RSS OPML Link
오류 유형: 807. C# - 닷넷 응용 프로그램에서 Informix DB 사용 시 오류 메시지 정리 [링크 복사], [링크+제목 복사],
조회: 13268
글쓴 사람
정성태 (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
비밀번호
댓글 작성자
 


... 16  17  18  19  [20]  21  22  23  24  25  26  27  28  29  30  ...
NoWriterDateCnt.TitleFile(s)
13439정성태11/10/202311533닷넷: 2158. C# - 소켓 포트를 미리 시스템에 등록/예약해 사용하는 방법(Port Exclusion Ranges)파일 다운로드1
13438정성태11/9/202311048닷넷: 2157. C# - WinRT 기능을 이용해 윈도우에서 실행 중인 Media App 제어
13437정성태11/8/202311257닷넷: 2156. .NET 7 이상의 콘솔 프로그램을 (dockerfile 없이) 로컬 docker에 배포하는 방법
13436정성태11/7/202311341닷넷: 2155. C# - .NET 8 런타임부터 (Reflection 없이) 특성을 이용해 public이 아닌 멤버 호출 가능
13435정성태11/6/202310602닷넷: 2154. C# - 네이티브 자원을 포함한 관리 개체(예: 스레드)의 GC 정리
13434정성태11/1/202310587스크립트: 62. 파이썬 - class의 정적 함수를 동적으로 교체
13433정성태11/1/20239419스크립트: 61. 파이썬 - 함수 오버로딩 미지원
13432정성태10/31/202310223오류 유형: 878. 탐색기의 WSL 디렉터리 접근 시 "Attempt to access invalid address." 오류 발생
13431정성태10/31/202310750스크립트: 60. 파이썬 - 비동기 FastAPI 앱을 gunicorn으로 호스팅
13430정성태10/30/202310951닷넷: 2153. C# - 사용자가 빌드한 ICU dll 파일을 사용하는 방법
13429정성태10/27/202311087닷넷: 2152. Win32 Interop - C/C++ DLL로부터 이중 포인터 버퍼를 C#으로 받는 예제파일 다운로드1
13428정성태10/25/202311232닷넷: 2151. C# 12 - ref readonly 매개변수
13427정성태10/18/202310732닷넷: 2150. C# 12 - 정적 문맥에서 인스턴스 멤버에 대한 nameof 접근 허용(Allow nameof to always access instance members from static context)
13426정성태10/13/202311243스크립트: 59. 파이썬 - 비동기 호출 함수(run_until_complete, run_in_executor, create_task, run_in_threadpool)
13425정성태10/11/202311124닷넷: 2149. C# - PLinq의 Partitioner<T>를 이용한 사용자 정의 분할파일 다운로드1
13423정성태10/6/202311012스크립트: 58. 파이썬 - async/await 기본 사용법
13422정성태10/5/202310765닷넷: 2148. C# - async 유무에 따른 awaitable 메서드의 병렬 및 예외 처리 [1]
13421정성태10/4/202311027닷넷: 2147. C# - 비동기 메서드의 async 예약어 유무에 따른 차이
13420정성태9/26/202319275스크립트: 57. 파이썬 - UnboundLocalError: cannot access local variable '...' where it is not associated with a value
13419정성태9/25/202310870스크립트: 56. 파이썬 - RuntimeError: dictionary changed size during iteration
13418정성태9/25/202312505닷넷: 2146. C# - ConcurrentDictionary 자료 구조의 동기화 방식
13417정성태9/19/202311794닷넷: 2145. C# - 제네릭의 형식 매개변수에 속한 (매개변수를 가진) 생성자를 호출하는 방법
13416정성태9/19/202310391오류 유형: 877. redis-py - MISCONF Redis is configured to save RDB snapshots, ...
13415정성태9/18/202311827닷넷: 2144. C# 12 - 컬렉션 식(Collection Expressions) [2]
13414정성태9/16/202311159디버깅 기술: 193. Windbg - ThreadStatic 필드 값을 조사하는 방법
13413정성태9/14/202311981닷넷: 2143. C# - 시스템 Time Zone 변경 시 이벤트 알림을 받는 방법
... 16  17  18  19  [20]  21  22  23  24  25  26  27  28  29  30  ...