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


1  2  3  4  5  6  7  8  9  [10]  11  12  13  14  15  ...
NoWriterDateCnt.TitleFile(s)
13380정성태6/24/20233290스크립트: 52. 파이썬 3.x에서의 동적 함수 추가
13379정성태6/23/20233302스크립트: 51. 파이썬 2.x에서의 동적 함수 추가
13378정성태6/22/20233196오류 유형: 868. docker - build 시 "CANCELED ..." 뜨는 문제
13377정성태6/22/20237052오류 유형: 867. 파이썬 mysqlclient 2.2.x 설치 시 "Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually" 오류
13376정성태6/21/20233416.NET Framework: 2129. C# - Polly를 이용한 클라이언트 측의 요청 재시도파일 다운로드1
13375정성태6/20/20233096스크립트: 50. Transformers (신경망 언어모델 라이브러리) 강좌 - 2장 코드 실행 결과
13374정성태6/20/20233205오류 유형: 866. 파이썬 - <class 'AttributeError'> module 'flask.json' has no attribute 'JSONEncoder'
13373정성태6/19/20234514오류 유형: 865. 파이썬 - pymssql 설치 관련 오류 정리
13372정성태6/15/20233202개발 환경 구성: 682. SQL Server TLS 통신을 위해 사용되는 키 길이 확인 방법
13371정성태6/15/20233233개발 환경 구성: 681. openssl - 인증서 버전(V1 / V3)
13370정성태6/14/20233403개발 환경 구성: 680. C# - Ubuntu + Microsoft.Data.SqlClient + SQL Server 2008 R2 연결 방법 - TLS 1.2 지원
13369정성태6/13/20233207개발 환경 구성: 679. PyCharm(을 비롯해 JetBrains에 속한 여타) IDE에서 내부 Window들의 탭이 없어진 경우
13368정성태6/13/20233353개발 환경 구성: 678. openssl로 생성한 인증서를 SQL Server의 암호화 인증서로 설정하는 방법
13367정성태6/10/20233483오류 유형: 864. openssl로 만든 pfx 인증서를 Windows Server 2016 이하에서 등록 시 "The password you entered is incorrect" 오류 발생
13366정성태6/10/20233260.NET Framework: 2128. C# - 윈도우 시스템에서 지원하는 암호화 목록(Cipher Suites) 나열파일 다운로드1
13365정성태6/8/20232999오류 유형: 863. MODIFY FILE encountered operating system error 112(failed to retrieve text for this error. Reason: 15105)
13364정성태6/8/20233804.NET Framework: 2127. C# - Ubuntu + Microsoft.Data.SqlClient + SQL Server 2008 R2 연결 방법 [1]
13363정성태6/7/20233361스크립트: 49. 파이썬 - "Transformers (신경망 언어모델 라이브러리) 강좌" - 1장 2절 코드 실행 결과
13362정성태6/1/20233300.NET Framework: 2126. C# - 서버 측의 요청 제어 (Microsoft.AspNetCore.RateLimiting)파일 다운로드1
13361정성태5/31/20233739오류 유형: 862. Facebook - ASP.NET/WebClient 사용 시 graph.facebook.com/me 호출에 대해 403 Forbidden 오류
13360정성태5/31/20233120오류 유형: 861. WSL/docker - failed to start shim: start failed: io.containerd.runc.v2: create new shim socket
13359정성태5/19/20233454오류 유형: 860. Docker Desktop - k8s 초기화 무한 반복한다면?
13358정성태5/17/20233770.NET Framework: 2125. C# - Semantic Kernel의 Semantic Memory 사용 예제 [1]파일 다운로드1
13357정성태5/16/20233562.NET Framework: 2124. C# - Semantic Kernel의 Planner 사용 예제파일 다운로드1
13356정성태5/15/20233880DDK: 10. Device Driver 테스트 설치 관련 오류 (Code 37, Code 31) 및 인증서 관련 정리
13355정성태5/12/20233816.NET Framework: 2123. C# - Semantic Kernel의 ChatGPT 대화 구현 [1]파일 다운로드1
1  2  3  4  5  6  7  8  9  [10]  11  12  13  14  15  ...