Error - Unable To Allocate An Environment Handle
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have
Connection Handle
Meta Discuss the workings and policies of this site About Us unable to allocate an environment handle oracle Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with sage unable to allocate an environment handle us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers,
Sqlallochandle
just like you, helping each other. Join them; it only takes a minute: Sign up ODBC - unable to allocate an environment handle up vote 0 down vote favorite Hi I am trying to insert data into Navision database from a DataTable. That DataTable contain around 5000 records, if the records count is less then it's working fine but record count is around 5000 I am getting this error. ERROR - unable to allocate an environment handle. This is the code I am using Public Function InsertToHHTTransferLine(ByVal dtTransferLn As DataTable, ByVal hhtNumber As String) As Integer Dim result As Integer Dim cn As OdbcConnection Dim dtTransferLine As DataTable cn = New OdbcConnection(ConnStr) Dim SqlStr As String = "" Try cn.Open() dtTransferLine = dtTransferLn Dim DocType As String DocType = "Purchase" Dim cmd As OdbcCommand Dim hhtNo As String hhtNo = hhtNumber If dtTransferLine.Rows.Count > 0 Then For i As Integer = 0 To dtTransferLine.Rows.Count - 1 If dtTransferLine.Rows(i)("DOC_TYPE").ToString() = "0" Then DocType = "Purchase" End If If dtTransferLine.Rows(i)("DOC_TYPE").ToString() = "1" Then DocType = "Transfer Receipt" End If If dtTransferLine.Rows(i)("DOC_TYPE").ToString() = "2" Then DocType = "Transfer Shipment" End If If dtTransferLine.Rows(i)("DOC_TYPE").ToString() = "3" Then DocType = "Stock Count" End If Try SqlStr = "INSERT INTO ""HHT & Navision Line""(""Document Type"",""Document No_"",""HHT No_"",""Line No_"",""Item No_"",""Document Quantity"",""Scan Quantity"",""Unit Price"",""Posted"") VALUES('" & DocType & "','" &
solutions Success stories Partner Business recommendation Device partner Tracking partner Partner Center Support Useful resources Ask Community (Forum) Read Blog Watch Videos Contact support Sign up for http://forum.gpsgate.com/viewtopic.php?t=9946 Newsletter GpsGate Server GpsGate Server Guide Getting started Supported Devices Connect Tracking https://supportforums.cisco.com/discussion/11566391/unity-connection-bulk-user-delete-problem Device Reports For developers Developer information Developer's Guide GpsGate TrackerOne GpsGate Splitter (Client) User Guides Quick links Unanswered topics Active topics Board indexFAQ Drop Down Lorem ipsum Welcome to phpBB3 Frequently Asked Questions BBCode example Login Register Environment handle error GpsGate.com Board index GpsGate GpsGate Server - How to setup and unable to use Post Reply Print view 7 posts • Page 1 of 1 guytracker Posts: 197 Joined: Thu Apr 30, 2009 6:58 pm Location: South Africa Contact: Website Environment handle error Quote Mon Jun 01, 2009 6:55 pm We have been testing GGS on our own server for a couple of weeks with one vehicle and it's been running fine. Great in fact. But unable to allocate on Saturday it stopped tracking. The log file at the first error is shown below. The error shows: ERROR - unable to allocate an environment handle. What is causing this and how do we fix it? We are using MySQL 5.1 and GGS 2.1.0.1554 LOG EXTRACT: 2009-05-30 18:37:26.2455 | Info | 299 | Device.get_DeviceMessageMapper | DeviceMapper = Name = GpsGate Generic Device Default mapper Linked to Group.ID = 7 loaded for Device = PHcartracker | 2009-05-30 18:37:26.4330 | Info | 299 | NmeaConnection.UpdateGateMessage | New position (28.1236816666667, -26.0117416666667, 0) (0, 214.67) (2009/05/30 04:37:37 PM) for Paulcar,PHcartracker,SmartPipe,tcp | 2009-05-30 18:37:26.7767 | Info | 299 | DAOFactory.EndRoundTrip | Process time: 00:00:00.9687500 DB:54 Paulcar@TcpConnection | 2009-05-30 18:37:26.8392 | Info | 299 | TcpConnection.m_ReadCallback | Client closed connection Paulcar@TcpConnection | 2009-05-30 18:37:26.8392 | Info | 299 | NmeaConnection.Dispose | Disposing... Paulcar@TcpConnection 41.29.192.126:1249 | 2009-05-30 18:37:26.8392 | Info | 299 | GateGroupManager.m_NoConnectionsInGroup | Group count = 0, Name Vehicles, Type GpsGate.Online.VehicleGroup | 2009-05-30 18:38:26.1205 | Info | 11 | TcpNmeaListener.m_Listen | New incoming connection! m_uiAcceptCount = 6460, remoteEP = 41.30.75.214:1250, type = GpsGate.NmeaPipe.SmartPipeTcpListener | 2009-05-30 18:38:26.2298 | Info | 11 | SmartPipeProtoco
Us Help Follow Us Facebook Twitter Google + LinkedIn Newsletter Instagram YouTube DirectoryNetwork InfrastructureWAN, Routing and Switching LAN, Switching and Routing Network Management Remote Access Optical Networking Getting Started with LANs IPv6 Integration and Transition EEM Scripting Other Subjects SecurityVPN Security Management Firewalling Intrusion Prevention Systems/IDS AAA, Identity and NAC Physical Security MARS Email Security Web Security Other Subjects Service ProvidersMetro MPLS Voice Over IP XR OS and Platforms Video Other Subjects Collaboration, Voice and VideoIP Telephony Video Over IP Jabber Clients Unified Communications Applications TelePresence Digital Media System Contact Center Conferencing UC Migrations Other Subjects Wireless - MobilitySecurity and Network Management Wireless IP Voice and Video Getting Started with Wireless WLCCA Other Subjects ServicesCisco ServiceGrid Connected Analytics Smart Call Home Smart Net Total Care Operations Exchange Mobile ApplicationsCisco Proximity Cisco Technical Support Online Tools and ResourcesCisco Bug Discussions Technical Documentation Ideas Cisco CLI Analyzer Support Community Help Data CenterApplication Centric Infrastructure Application Networking Intelligent Automation Server Networking Storage Networking Unified Computing Wide Area Application Services (WAAS) Other Subjects Small BusinessNetwork Storage Routers Security Surveillance Switches Voice and Conferencing Wireless Solutions and ArchitecturesBorderless Networks Collaboration Cisco User GroupsSeattle Cisco User Group (SEACUG) Silicon Valley Cisco User Group (SVCUG) Southern California Cisco User Group (SCCUG) Cisco Certifications Cisco.com Idea Center Cisco Cafe Expert CornerTop Contributors Leaderboards Cisco Live! Events Events Community CornerAwards & Recognition Behind the Scenes Feedback Forum Cisco Certifications Cisco Press Café Cisco On Demand Support & Downloads Community Resources Security Alerts Security Alerts News News Video Cisco Support YouTube Cisco YouTube Blogs Technical Documentation Cisco Products Products Services Services Solutions Solutions Global Support Numbers Cisco Support Community Directory Network Infrastructure WAN, Routing and Switching LAN, Switching a