Error 42000 Simba
Date perels Date 2008-10-22 3:12 PM Replies 10 replies Subscribers 320 subscribers Views 7223 views Dynamics NAV ODBC NODBC Query ASP.NET C# Navision Windows Server 2003 Options Share RSS Tags More Cancel Click here to login or become a member to ask questions and reply in our fourms. ERROR [42000] [Simba][SimbaEngine ODBC Driver]SELECT DISTINCT (<< ??? >>[Field 1]) FROM dbo.MyTable Hi, I am new to Navision development, but experienced in C#. I am running on Windows 2003 Server - both webserver and Navision. NODBC.dlldriver version is 5.00.24199.00.I am trying to built an ASP.NET webinterface for a Native Navision database - I am using the C/ODBC drivers for Navision and connecting via System.Data.Odbc. Upgrading to SQL database is unfortunately not an option. I get this error: ERROR [42000] [Simba][SimbaEngine ODBC Driver]SELECT DISTINCT (<< ??? >>[Field 1]) FROM dbo.MyTable The query I am running is the following:SELECT DISTINCT ([Field 1]) FROM dbo.MyTable - however the SimbaEngine driver (C/ODBC) appends the << ??? >> in the query... I have tried removing brackets, removing "dbo." - but no luck... what am I missing? According to Microsoft Dynamics™ NAV ODBC Driver 5.0 Guide, DISTINCT keyword is supported.part of my C#source: .... DataSet result = new DataSet();OdbcDataAdapter OdbcDA = new OdbcDataAdapter();OdbcCommand cmd = new OdbcCommand(); cmd.Connection = new OdbcConnection(ConfigurationManager.ConnectionStrings["myConn"].ToString());cmd.CommandType = CommandType.Text;cmd.CommandTimeout = 600;cmd.Connection.ConnectionTimeout = 600;cmd.CommandText = "SELECT DISTINCT ([Field 1]) FROM dbo.MyTable";cmd.Connection.Open();OdbcDA.SelectCommand = cmd; OdbcDA.Fill(result, "Master"); .... Hoping for some help :-) perels Cancel All Responses Answers Only galletin 0 2008-10-22 4:41 PM Hi perels, not sure if this can help you. I've worked with NAV ODBC and Sharepoint BDC service, it's supposed to display information of NAV on sharepoint lists and webparts but it doesn't work, even if it works with other db's ODBC. I've to say this happens only (obviously)with native database, maybe more ODBC NAV errors can be discovered with your thread.Thanks ;-) galletin David Singleton 0 2008-10-23 11:39 AM This maybe off topic, but since you are developin gin C#, why not use
Recent Discussions Activity Best Of... Unanswered Categories 62.4K All Categories73 General 73 Announcements 57K Microsoft Dynamics NAV 11.2K NAV Three Tier 37.1K NAV/Navision Classic Client 3.6K Navision Attain 2.2K Navision Financials 107 Navision DOS 828 Navision e-Commerce 525 NAV Tips & Tricks 728 NAV Dutch speaking only 580 NAV Courses, Exams & Certification 1.8K Microsoft Dynamics-Other 1.4K https://dynamicsuser.net/nav/f/developers/24557/error-42000-simba-simbaengine-odbc-driver-select-distinct-field-1-from-dbo-mytable Dynamics AX 195 Dynamics CRM 96 Dynamics GP 5 Dynamics SL 1.4K Other 928 SQL General 354 SQL Performance 24 SQL Tips & Tricks 17 Design Patterns (General & Best Practices) 0 Architectural Patterns 6 Design Patterns 2 Implementation Patterns 28 3rd Party Products, Services & Events 860 General http://forum.mibuso.com/discussion/10109/odbc-error-error-42000-simba 860 General Chat 1.5K Website 73 Testing 1.1K Download section 23 How Tos section 231 Feedback 12 NAV TechDays 2013 Sessions 13 NAV TechDays 2012 Sessions ODBC-Error ERROR[42000][Simba]...... Ralf Member Posts: 15 2006-02-21 edited 2006-02-27 in NAV/Navision Classic Client Hi, I'm trying to connect to a Navision 4.00 SP1 Server with the NODBC driver and received the following error: ERROR[42000][Simba][SimbaEngine ODBCDriver] Fehler beim schreiben nach Navision Object reference not set to an instance of an object. On an other Server (in Example: Navision 3.70 ODBC) the used code is ok. Can any one help me? Thanks. Ralf 0 Comments kine Member Posts: 12,555 2006-02-22 Which language you have set in the driver? Neutral? German? Kamil Sacek MVP - Dynamics NAV My BLOG NAVERTICA a.s.0 Ralf Member Posts: 15 2006-02-27 I use Neutral in the ODBC Configuration. 0 Sign In or Register to comment.
General Discussions View all Getting Started with the Community Community News Get Connected Business Strategy & Best Practices Suggestions for this Community Technical Discussions View all Announcements https://community.microstrategy.com/t5/Server/TN255685-An-error-message-is-displayed-when-importing-data-from/ta-p/255685 Visualization Gallery Tech Corner Idea Exchange Platform (Installation & Deployment) Object Development http://www.vbforums.com/showthread.php?389272-VB-NET-Connection-String-problem Reporting, Dashboards, and Document Development MicroStrategy Desktop Clients (Interfaces & Visualizations) Administration Tools Intelligence Server Mobile Enterprise Assets (Data Sources & Gateways) MicroStrategy Software Development Kit (SDK) Security (Usher) Performance Events View all Events Blog Symposia 2016 Symposia 2015 Education World 2016 Discussions World 2015 Discussions World 2015 error 42000 Track Sessions & Customer Presentations Community Menu Register · Sign In · Help Server MicroStrategy > Server > TN255685: An error message is displayed when importing data from Google Big Query using the Simba Big Query ODBC driver ... CommunityCategoryKnowledge BaseUsers turn on suggestions Auto-suggest helps you quickly narrow down your error 42000 simba search results by suggesting possible matches as you type. TN255685: An error message is displayed when importing data from Google Big Query using the Simba Big Query ODBC driver on MicroStrategy Analytics Enterprise 10 Started 08-14-2015 by Ohingst Modified 08-14-2015 by Ohingst Article Options Article History Subscribe to RSS Feed Mark as New Mark as Read Bookmark Subscribe Email to a Friend Printer Friendly Page Report Content Labels: Database , ODBC , Server , Windows 1 Like SYMPTOM An error message is displayed when importing data from Google BigQuery with Simba ODBC driver on MicroStrategy Analytics Enterprise 10.x. The following scenarios have been found to generate errors: During data import, on the preview page, it will generate statement such as select * from samples.natality limit 1000 The syntax “limit 1000” is an invalid SQL statement for BigQuery with the Simba ODBC driver. 2. If there is keyword in the SELECT statement, such as select year Year from samples.natality In the statement above "year" is the keyword, the statement will fail to execute. 3. If there are columns wit
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: VB.NET Connection String problem Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Feb 23rd, 2006,03:35 PM #1 joopdog View Profile View Forum Posts Thread Starter Junior Member Join Date Jun 2005 Posts 26 VB.NET Connection String problem VB.NET Connection String problem Im trying to connect to a UNIX server we have. All our data is stored this machine. Im able to connect through Access by linking the database into a Table in Access. Im also able to Import the database into Access and I can Import into Excel. The problem is Im trying to create a WebForm for our internal Intranet site website to read the data. Heres my Connection String for Access (It Works): Code: ODBC;DSN=prodlgo;ServerName=192.168.1.2.1583;ServerDSN=prodlgo;UID=Sharon;PWD=sms999;ArrayFetchOn=1;ArrayBufferSize=8;DBQ=.;;TABLE=CUSTOMER;" Heres my Connection String for Excel (It works): HTML Code: ' Import Data from WCS_UNIX system. With ActiveSheet.QueryTables.Add(Connection:= _ "ODBC;DSN=prodlgo;ServerName=192.168.1.2.1583;ServerDSN=prodlgo;UID=Sharon;PWD=qaz890;ArrayFetchOn=1;ArrayBufferSize=8;DBQ=.;" _ , Destination:=Range("A1")) .CommandText = Array("SELECT * FROM ""employee""") .Name = "prodlgo (not sharable)" .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .PreserveColumnInfo = True .SourceConnectionFile = _ "C:\Program Files\Common Files\ODBC\Data Sources\prodlgo (not sharable).DSN" .Refresh BackgroundQuery:=False End With This is what I Have so far (It doesnt work): VB Code: Sub Page_Load(Source As Object, E As EventArgs) '------------ 'Dim strConnection As String = "Provider=Microsoft.Jet.OleDb.4.0;" & _ ' "data source=" & server.mappath("Joopdog_Linked_Tables.mdb") Dim strConnection As String = "Provider=SQLOLEDB;DSN=prodlgo;ServerName=192.168.1.2.1583;ServerDSN=prodlgo;UID=Sharon;PWD=sms999;TABLE=CUSTOMER;" Dim objConnection As New OleDbConnection(strConnection) Dim strSQL As String = "SELECT CustomerId, DbaNme, StreetAddr1Txt " & _ "FROM CUSTOMER;" Dim objCommand As New OleDbCommand(strSQL, objConnection) '--