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


... 46  [47]  48  49  50  51  52  53  54  55  56  57  58  59  60  ...
NoWriterDateCnt.TitleFile(s)
12477정성태1/5/202113965기타: 79. github 코드 검색 방법 [1]
12476정성태1/5/202110720.NET Framework: 996. C# - 닷넷 코어에서 다른 스레드의 callstack을 구하는 방법파일 다운로드1
12475정성태1/5/202113303.NET Framework: 995. C# - Span<T>와 Memory<T> [1]파일 다운로드1
12474정성태1/4/202110748.NET Framework: 994. C# - (.NET Core 2.2부터 가능한) 프로세스 내부에서 CLR ETW 이벤트 수신 [1]파일 다운로드1
12473정성태1/4/20219590.NET Framework: 993. .NET 런타임에 따라 달라지는 정적 필드의 초기화 유무 [1]파일 다운로드1
12472정성태1/3/20219881디버깅 기술: 178. windbg - 디버그 시작 시 스크립트 실행
12471정성태1/1/202110373.NET Framework: 992. C# - .NET Core 3.0 이상부터 제공하는 runtimeOptions의 rollForward 옵션 [1]
12470정성태12/30/202010572.NET Framework: 991. .NET 5 응용 프로그램에서 WinRT API 호출 [1]파일 다운로드1
12469정성태12/30/202014134.NET Framework: 990. C# - SendInput Win32 API를 이용한 가상 키보드/마우스 [1]파일 다운로드1
12468정성태12/30/202010696Windows: 186. CMD Shell의 "Defaults"와 "Properties"에서 폰트 정보가 다른 문제 [1]
12467정성태12/29/202010838.NET Framework: 989. HttpContextAccessor를 통해 이해하는 AsyncLocal<T> [1]파일 다운로드1
12466정성태12/29/20208626.NET Framework: 988. C# - 지연 실행이 꼭 필요한 상황이 아니라면 singleton 패턴에서 DCLP보다는 static 초기화를 권장파일 다운로드1
12465정성태12/29/202011831.NET Framework: 987. .NET Profiler - FunctionID와 연관된 ClassID를 구할 수 없는 문제
12464정성태12/29/202010654.NET Framework: 986. pptfont.exe - PPT 파일에 숨겨진 폰트 설정을 일괄 삭제
12463정성태12/29/20209689개발 환경 구성: 520. RDP(mstsc.exe)의 다중 모니터 옵션 /multimon, /span
12462정성태12/27/202011275디버깅 기술: 177. windbg - (ASP.NET 환경에서 유용한) netext 확장
12461정성태12/21/202012064.NET Framework: 985. .NET 코드 리뷰 팁 [3]
12460정성태12/18/20209931기타: 78. 도서 소개 - C#으로 배우는 암호학
12459정성태12/16/202010330Linux: 35. C# - 리눅스 환경에서 클라이언트 소켓의 ephemeral port 재사용파일 다운로드1
12458정성태12/16/20209680오류 유형: 694. C# - Task.Start 메서드 호출 시 "System.InvalidOperationException: 'Start may not be called on a task that has completed.'" 예외 발생 [1]
12457정성태12/15/20209225Windows: 185. C# - Windows 10/2019부터 추가된 SIO_TCP_INFO파일 다운로드1
12456정성태12/15/20209534VS.NET IDE: 156. Visual Studio - "Migrate packages.config to PackageReference"
12455정성태12/15/20209054오류 유형: 693. DLL 로딩 시 0x800704ec - This Program is Blocked by Group Policy
12454정성태12/15/20209675Windows: 184. Windows - AppLocker의 "DLL Rules"를 이용해 임의 경로에 설치한 DLL의 로딩을 막는 방법 [1]
12453정성태12/14/202010633.NET Framework: 984. C# - bool / BOOL / VARIANT_BOOL에 대한 Interop [1]파일 다운로드1
12452정성태12/14/202010882Windows: 183. 설정은 가능하지만 구할 수는 없는 TcpTimedWaitDelay 값
... 46  [47]  48  49  50  51  52  53  54  55  56  57  58  59  60  ...