7 Replies Latest reply on Mar 14, 2017 12:32 PM by TSGal

    Filemaker ODBC issue (SQL_NO_NULLS) Excel

    simoncpage

      I have an issue with connecting via ODBC which has only happened over the last couple of weeks (before that I have had no issues). Albeit my laptop can connect without any issue. I have made sure that I have updated the PC Server to the latest release and all clients and ODBC drivers. However I get the following rather long winded error. So I have a driver setup via ODBC 32bit and 64bit and both give me the same issue in excel. I can get the list of all the tables in the database but as soon as I go into selecting a table I get the error and it doesn't matter which table I choose (even a new one with just one text field and 1 record).

       

      I wondered if the issue was due to .NET framework installation but having tried different version this doesn't seen to work. My laptop has a version of Visual Studio 2010 which has the .net framework installation rather than the desktop which has separate .NET installation.

       

      Does anyone have any thoughts or things I can try here to get this working again?

       

      Error Message:

      A column named 'SQL_NO_NULLS' already belongs to this DataTable.

       

      Stack Trace:

      Microsoft.Mashup.Evaluator.Interface.ErrorException: A column named 'SQL_NO_NULLS' already belongs to this DataTable. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: A column named 'SQL_NO_NULLS' already belongs to this DataTable. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: A column named 'SQL_NO_NULLS' already belongs to this DataTable. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: A column named 'SQL_NO_NULLS' already belongs to this DataTable. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: A column named 'SQL_NO_NULLS' already belongs to this DataTable. ---> System.Data.DuplicateNameException: A column named 'SQL_NO_NULLS' already belongs to this DataTable. ---> System.Data.DuplicateNameException: A column named 'SQL_NO_NULLS' already belongs to this DataTable.

         at System.Data.DataColumnCollection.RegisterColumnName(String name, DataColumn column)

         at System.Data.DataColumnCollection.BaseAdd(DataColumn column)

         at System.Data.DataColumnCollection.AddAt(Int32 index, DataColumn column)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.DataTableFrom(IDataReader reader)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.Cache(String[] keyParts, Func`2 func)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.<>c__DisplayClass17.<GetColumns>b__16(IHostTrace trace)

         at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.GetColumns(String catalogName, String schemaName, String tableName)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection.<EnsureInitialized>b__0(IOdbcConnection connection)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<>c__DisplayClassb.<Connect>b__a(IOdbcConnection connection)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<>c__DisplayClass8`1.<Connect>b__7()

         at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)

         at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryDomain.NewQuery(OdbcTableInfo table, FromItem[] fromItems)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTableValue.OdbcTableValueBuilder.CreateTableValue(OdbcTableInfo tableInfo)

         at Microsoft.Mashup.Engine1.Library.Odbc.OdbcHierarchicalNavigationTableValue.<>c__DisplayClass9.<CreateOdbcTable>b__8()

         at Microsoft.Mashup.Engine1.Runtime.DelayedValue.get_Value()

         at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)

         at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)

         at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)

         at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)

         at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)

         at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)

         at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)

         at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)

         at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)

         at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)

         at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)

         at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)

         at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(Value key)

         at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name)

         at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)

         at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()

         at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.Force(Int32 index)

         at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.get_Item(Int32 index)

         at Microsoft.Mashup.Engine1.Runtime.ListValue.get_Item(Value key)

         at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)

         at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)

         at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)

         at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)

         at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)

         at Microsoft.Mashup.Engine1.Language.Expression.ExecuteCondition(Value frame)

         at Microsoft.Mashup.Engine1.Language.DebugExpression.ExecuteCondition(Value frame)

         at Microsoft.Mashup.Engine1.Language.IfExpression.Execute(Value frame)

         at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)

         at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)

         at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)

         at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)

         at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()

         at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Invoke(IValue function, IValue[] arguments)

         at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

         --- End of inner exception stack trace ---

         at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

         at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

         at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)

         at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)

         at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)

         at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)

         at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)

         at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)

         at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)

         at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)

         at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.EvaluationHost.Run()

         at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)

         at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)

         at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)

         at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)

         --- End of inner exception stack trace ---

         at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass2.<BeginGetResult>b__0(EvaluationResult2`1 result)

         --- End of inner exception stack trace ---

         at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass2.<BeginGetResult>b__0(EvaluationResult2`1 result)

         at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

         at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

         at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)

         at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)

         at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)

         at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)

         at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)

         at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)

         at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)

         at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)

         at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.EvaluationHost.Run()

         at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)

         at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)

         at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)

         at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)

         --- End of inner exception stack trace ---

         at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClassc.<>c__DisplayClasse.<OnBeginGetPreviewValueSource>b__b()

         at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass5.<RunStub>b__3()

         at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

         --- End of inner exception stack trace ---

         at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)

         at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)

         at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

         at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)

         at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass1f`1.<OnBeginGetResult>b__1c()

         at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

         at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)

         at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)

         at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)

         at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.EvaluationHost.Run()

         at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)

         at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)

         at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)

         at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)

         --- End of inner exception stack trace ---

         at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)

         at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

         at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)

         at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)

         at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()

         at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()

         at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

       

       

      Invocation Stack Trace:

         at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

         at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)

         at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()

         at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)

         at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

         at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

         at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

         at System.Delegate.DynamicInvokeImpl(Object[] args)

         at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

         at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

         at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

         at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

         at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

         at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

         at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

         at System.Windows.Forms.Control.WndProc(Message& m)

         at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

         at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

         at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

         at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)

         at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

         at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

         at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

         at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)

         at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)

         at Microsoft.Mashup.Client.Excel.ExcelDataImporter.OnImportSuccess(IEnumerable`1 importedQueries, DataImportDestination destination)

         at Microsoft.Mashup.Client.ClientShared.DataImporter.ProcessImportedQueries(IEnumerable`1 importedQueries, DataImportDestination destination)

         at Microsoft.Mashup.Client.ClientShared.DataImporter.ImportNavigationSource(Query query)

         at Microsoft.Mashup.Client.ClientShared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)

         at Microsoft.Mashup.Client.ClientShared.DataImporter.<>c__DisplayClass17.<OnQuerySettingsResolved>b__14()

         at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

         at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

         at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

         at System.Delegate.DynamicInvokeImpl(Object[] args)

         at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

         at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

         at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

         at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

         at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

         at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

         at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

         at System.Windows.Forms.Control.WndProc(Message& m)

         at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       

       

       

       

      Supports Premium Content:

      False

       

       

      Formulas:

       

       

       

       

      section Section1;

       

       

      shared Flag_Comments = let

          Source = Odbc.DataSource("dsn=Portfolio ODBC", [HierarchicalNavigation=true]),

          Date_Flags_Table = Source{[Name="Date_Flags",Kind="Table"]}[Data]

      in

          Date_Flags_Table;

        • 1. Re: Filemaker ODBC issue (SQL_NO_NULLS) Excel
          simoncpage

          So I have solved this as I have just realised that the ODBC driver on my laptop that was working off of version 14 (not 15.0.3) so looks like it is an issue with Filemaker ODBC drivers and in particularly the latest versions.

          • 2. Re: Filemaker ODBC issue (SQL_NO_NULLS) Excel
            TSGal

            simoncpage:

             

            Thank you for your posts.

             

            What version of Windows are you using on the server?

             

            I have sent your entire post to our Development and Testing departments for review.  When I receive any feedback, I will let you know.

             

            TSGal

            FileMaker, Inc.

            • 3. Re: Filemaker ODBC issue (SQL_NO_NULLS) Excel
              simoncpage

              The server is PC on Windows Server 2012 R2 Standard. Just tried this on a freshly installed laptop Windows 10 and I'm getting the same issue all that is on the laptop is 15.0.3 Pro Advanced and Office 365 (64 bit). I initially tried the v15.0.3 ODBC drivers but same issue as above. As soon as I roll it back to v14 it works a treat. I had looked up that you can get that error for timestamps and thought that since most of my tables have modified and created timestamps it was an issue with that but as I said I setup a test table with one text field and one record and it does the same. It is obviously working to an extent as I can go in and setup the connection in the windows ODBC admin console but as soon as I try and query it in Excel I just get to the list of table available and then as soon as I select a table it falls over. I've tried refreshing previously setup connections but that did the same.

               

              Not a big fan of using old drivers so be good to get it sorted out.

               

              Thanks

              • 4. Re: Filemaker ODBC issue (SQL_NO_NULLS) Excel
                TSGal

                simoncpage:

                 

                Thanks for the additional information.  I have added your comments to the original report.

                 

                TSGal

                FileMaker, Inc.

                • 5. Re: Filemaker ODBC issue (SQL_NO_NULLS) Excel
                  strophy

                  Hi, I'm having the same problem but connecting to FileMaker Pro instead of FileMaker Server. Under Windows 10 1607, FileMaker 15.0.3.305, 64 bit Excel 2016 1612 and FileMaker ODBC 15.0.6.0, all 64 bit and fully updated.

                   

                  I get the same error as Simon: "A column named 'SQL_NO_NULLS' already belongs to this DataTable." Since this occurs for both Server and Pro and reverting to the v14 ODBC drivers solves the problem, I would agree that the bug is in the v15 ODBC drivers. Please update here with progress, thanks!

                  • 6. Re: Filemaker ODBC issue (SQL_NO_NULLS) Excel
                    TSGal

                    strophy:

                     

                    I have attached your comments to the original report.  When more information becomes available, I will let you know.

                     

                    TSGal

                    FileMaker, Inc.

                    • 7. Re: Filemaker ODBC issue (SQL_NO_NULLS) Excel
                      TSGal

                      simoncpage and strophy:

                       

                      Our Testing and Development teams have been unable to reproduce the issue.  The notes from the testers show:

                       

                      Tester 1

                      Excel 2013 and Excel 2016 - 64-bit - Windows 10.

                       

                      Tester 2

                      Excel 2016 32-bit on Windows 7

                      Excel 2016 64-bit on Windows 10

                      FileMaker Server 15.0.3 installed on Windows Server 2012 R2, ODBC driver 15.0.6

                       

                      Tester 2 also suggested going to (if it exists):

                      C:\Users\username\AppData\Local\Microsoft\Power Query\Cache

                      ... and deleting all files.

                       

                      Please let me know the results.

                       

                      TSGal

                      FileMaker, Inc.