Error 42000 Transoft Tsodbc
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 7 of 7 Thread: vb.net Transoft ODBC Exception Error Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Sep 23rd, 2011,04:18 PM #1 BuckeyeJane View Profile View Forum Posts Thread Starter Junior Member Join Date May 2011 Posts 21 vb.net Transoft ODBC Exception Error Hello - I'm trying to connect to Transoft U/SQL liscense using an odbc connection and and odbcDataAdapter. I am using a function to return a dataset into the mainModule. HTML Code: dsOMD = getOMDinfo(psSerialNbr) dtOMD = dsOMD.Tables(0) The Function code that is being used is as follows: HTML Code: Function getOMDinfo(ByVal strSerialNumber As String) As System.Data.DataSet Dim myconnection1 = New OdbcConnection("DSN=omd.udd;uid=;") Dim strSQL As String = String.Empty Dim strTable As String = "usqlda.SERIAL_EQUIP" strSQL = "SELECT SERIAL_EQUIP.[MODEL], SERIAL_EQUIP.[SERIAL], SERIAL_EQUIP.[CUSTOMER_NUMBER], SERIAL_EQUIP.[PROGRAM_TYPE], SERIAL_EQUIP.[EQUIP_ID] " & _ "FROM(usqlda.SERIAL_EQUIP) WHERE (((SERIAL_EQUIP.[SERIAL])=@strSerialNumber));" Dim adapter1 As New OdbcDataAdapter(strSQL, myconnection1) Dim data As New DataSet adapter1.Fill(data, strTable) Return data End Function I am getting the following error: Message: "ERROR [42000] [Transoft][TSODBC][usqlsd]Name expected ([)" Source: "TSODBCW.DLL" If I change the code to use a datareader it I can loop through the data but a data reader is not recommended to pass through the layers and so I'm wanting to create a dataset/data table process. Anyone have any ideas why the dataset/dataTable code is not working properly? Thank you in advance for your assistance and help! Reply With Quote Sep 26th, 2011,09:20 AM #2 BuckeyeJane View Profile View Forum Posts Thread Starter Junior Member Join Date May 2011 Posts 21 Re: vb.net Transoft ODBC Exception Error I think I'm making a little progress.. but still am in need of some help regarding this pr
am using a function to return a dataset into the mainModule. HTML dsOMD = getOMDinfo(psSerialNbr) dtOMD = dsOMD.Tables(0) The Function code that is being used is as follows: HTML Function getOMDinfo(ByVal strSerialNumber As String) As System.Data.DataSet Dim myconnection1 = New OdbcConnection("DSN=omd.udd;uid=;") Dim strSQL As String = String.Empty [code]... I am getting the following error: Message: "ERROR [42000] [Transoft][TSODBC][usqlsd]Name expected ([)" Source: "TSODBCW.DLL" If I change the code to use a datareader it I can loop through the data but a http://www.vbforums.com/showthread.php?660964-vb-net-Transoft-ODBC-Exception-Error data reader is not recommended to pass through the layers and so I'm wanting to create a dataset/data table process. Anyone have any ideas why the dataset/dataTable code is not working properly? View 6 Replies Similar Messages: Difference Between Oledb Connection And Odbc Connection? Connect To Access Using Odbc ? Connect To Database Using ODBC? Connect To MS ODBC http://vb.net.bigresource.com/connect-to-Transoft-U-SQL-license-using-an-odbc-connection-and-and-odbcDataAdapter--tDu8CiX8V.html Using Sp2 / Version 2.81.1132.0 In XP? Connect To Mas90's File Using Their ODBC That They Setup? Connect To Sql Server 2008 Via Odbc But Not Through .net Code? VB 10 Express Connect Via ODBC To Progress Database? VS 2005 - How To Connect Oracle Database With ODBC Cannot Establish Connection Using Odbc? Keep A Odbc Connection Open? Microsoft ODBC Connection - Using ASP Sqlbulkcopy With Odbc Connection? Connect .net And MS Access ODBC: OdbcConnection Reference Error? Mysql Odbc Driver Not Found Unable To Connect? .net - ODBC Connection To MySQL Won't Add Values? Added On The Database With Odbc Connection? Change Excel Odbc Connection? Create An ODBC Connection In The Registry? Make ODBC Connection Be In The Class? Oracle ODBC Connection Monitoring? Use Data Grid In Vb Using Odbc Connection? Using Parameters With An Oracle ODBC Connection? IDE :: Mysql Connection ODBC Driver Prob From .net? ODBC Connection To Excell Eats First Row - How To Stop It Opening And Closing ODBC Connection Incorrectly? Code For Opening DB Connection Using An ODBC Data Sour
01SQLSTATEErrorCan be returned from 01000General warning Driver-specific informational http://www.easysoft.com/developer/interfaces/odbc/sqlstate_status_return_codes.html message. (Function returns SQL_SUCCESS_WITH_INFO.)All ODBC functions except: SQLError SQLGetDiagField SQLGetDiagRec 01001Cursor operation conflict SQLExecDirect StatementText contained a positioned update or delete statement, and no rows or more than one row were updated or deleted. (For more information about error 42000 updates to more than one row, see the description of the SQL_ATTR_SIMULATE_CURSOR Attribute in SQLSetStmtAttr.) (Function returns SQL_SUCCESS_WITH_INFO)SQLExecute The prepared statement associated with the StatementHandle contained a positioned update or delete statement, and no rows or more than error 42000 transoft one row were updated or deleted. (For more information about updates to more than one row, see the description of the SQL_ATTR_SIMULATE_CURSOR Attribute in SQLSetStmtAttr.) (Function returns SQL_SUCCESS_WITH_INFO.)SQLParamDataSQLSetPos The Operation argument was SQL_DELETE or SQL_UPDATE, and no rows or more than one row were deleted or updated. (For more information about updates to more than one row, see the description of the SQL_ATTR_SIMULATE_CURSOR Attribute in SQLSetStmtAttr.) (Function returns SQL_SUCCESS_WITH_INFO.) The Operation argument was SQL_DELETE or SQL_UPDATE, and the operation failed because of optimistic concurrency. (Function returns SQL_SUCCESS_WITH_INFO.) 01002Disconnect error SQLDisconnect An error occurred during the disconnect. However, the disconnect succeeded. (Function returns SQL_SUCCESS_WITH_INFO.) 01003NULL value eliminated in set function SQLExecDirect The argument Statemen