Hi, I am using npgsql as a connector (
https://support.office.com/en-us/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4?CorrelationId=1e7dd3e7-2adc-4334-93c9-1bb4283ddd9f&ui=en-US&rs=en-US&ad=US) in Excel 64 bits Power Query, and I have hit a problem.
I get "Value was either too large or too small for an Int32" during the inital "login".
[ I am inexperienced in nppgsql, and used
http://pgfoundry.org/frs/download.php/3796/Setup_Npgsql-2.2.3.0-r2-net40.exe to install (also tried .net 4.5 version)
]
So 1 question is where is the error coming from (database/nppgsql/excel)
( and obvioulsy best if soemone knew solution)
[DataSource.Error] Value was either too large or too small for an Int32.
StackTrace:
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass4.<BeginGetResult>b__3(EvaluationResult2`1 result)
InnerException
Exception:
ExceptionType: System.OverflowException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: Value was either too large or too small for an Int32.
StackTrace:
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at NpgsqlTypes.NpgsqlTypesHelper.LoadTypesMappings(NpgsqlConnector conn, NpgsqlBackendTypeMapping TypeMappings, IEnumerable`1 TypeInfoList)
at NpgsqlTypes.NpgsqlTypesHelper.CreateAndLoadInitialTypesMapping(NpgsqlConnector conn)