So today I installed IBM's ADO .NET Data Providers for the iSeries in my Development PC so I can do away with ODBC when connecting to the AS400.I can't get pass LINE 07 and I've used several connection string samples on the web already. I'm getting an error:The type initializer for 'IBM.Data.DB2.iSeries.iDB2Constants' threw an exception.
MyCode
01 Imports IBM.Data.DB2.iSeries
02 Public Class Form1
[code]....
I think, although I am not sure, that my problem may stem from the fact that I am trying to do something with a DB2 Packed Decimal Field.If I use MS SQL to import data from an iSeries file I can do something like this Select a, b, c, sum(d) from a file where (criteria here) group by a, b, c Note: field d is a packed decimal field.
In VB using an ODBC connection I can do this: select a, b, c, d from a file where (criteria here)but when I try to do this Select a, b, c, sum(d) from a file where (criteria here) group by a, b, c I am getting an error: -2147467259 (80004005).
I want to do this using VB in Excel because I want the user to be able to input data on the spreadsheet that defines some of the selection criteria.
how can I reset a user account in iSeries?
Actually we have to log on to As400 with our account, write down the username, receive a password and then logon with the new password and change it.
I found some code in the internet but what do I do when I dont know the old password?
Code:
Dim systemNames As New cwbx.SystemNames
Dim as400 As New cwbx.AS400System
On Error GoTo failed
[Code].....
I need to do a daily process that has to copy (download), all the files from a iSeries folder. At the moment, if i know the filename i'm using the following code with the cwbx.dll
Dim dt As New cwbx.DatabaseTransfer
dt.UserID = "user"
dt.Password = "password"
dt.Download("iSeriesName", "dir/filename", "outputfile")
But how can i list all the files that exist in that dir, so that i can copy/download them all ?
I have a problem when i use My.Computer.Network.DownloadFile from a iseries share path
View 2 RepliesI'm writing an application that imports and tidy up address data into a cleaned, deduped excel workbook ordered in rows with each column as an address field. One of the issues I've ran into is that we sometimes get a workbook where the multiple address fields are held in a single cell with line breaks. I've written code to extract all of this data out of the excel sheet in to a dataset with each sheet as a table and the address fields contained within. I now want to create a new Excel workbook from this data with the address fields in Row and columns the problem I have is I can Open/create the Workbook but when I try to insert a new Sheet (Table) I get an error saying the Workbook is read only....
Private Sub MakeSimpleXL(ByRef DsTemp As DataSet)
Dim dsTable As Data.DataTable
Dim tblName As String
Dim dsRow As Data.DataRow
[CODE]...
Here is the error: System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC Excel Driver] Cannot modify the design of table '3 _ 10$'. It is in a read-only database. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String
[CODE]...
It looks to me like it is trying to create the table (Sheet) but has the workbook opened as read only....
I can't get past this error in my loop through the data reader specifically dr(12). I tried adding .To String but that doesn't seem to work either. Can someone help me with what need to do so it can read even if there is a Null value. My code is below:
While objDataReader.Read()
'Set up DataRow object
Dim dr As DataRow = DataReaderTable.NewRow
[code].....
I have this code which populated my form;
Private Sub populateprojdetails()
Dim cmd As New SqlCommand
Dim conn As SqlConnection = GetDbConnection()[code]....
The Error I receive is "Error converting data type varchar to numeric".
Error: MySql.Data.MySqlClient.MySqlException: #42000 You have an error in your SQL syntax
[Code]....
I've spent a substantial amount of time trying to figure this out, but I keep getting the same error
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
A first chance exception of type 'System.NullReferenceException' occurred in project1.exe
This happens when I try to use the DataReader.my code is
Public Function Identification() As List(Of Integer)
Dim returnIndex As New List(Of Integer)
Dim dbCount As String = "SELECT Bookingid FROM bookdetail WHERE Date =" & getCurrentTimeString() & " 12:00:00 a.m."
Dim count As Integer = 0
[code]....
i am trying to connect to an MS Access database and I am getting an erro message on the following line of
searchtable_command = New SqlClient.SqlCommand(searchtable_string, testsearch_connection)
Error:'System.Data.Odbc.OdbcConnection' cannot be converted to 'System.Data.SqlClient.SqlConnection'.
Here my connection string:
Dim testsearch_connection As New Odbc.OdbcConnection("Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Dbq=C:CesarAccessdatabase.mdb;Uid=admin;Pwd=;")
What am I missing?
Do While rdr2.Read()
Dim var1 As String = rdr2.Item("Week").ToString
Dim var2 As String = rdr2.Item("L1").ToString
Dim var3 As String = rdr2.Item("L2").ToString
It generates the following error: A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll
Interestingly, if I use a numeric value for the variable it for LSArraytemp, it writes to the database no problem at all.
I have the following piece of Code in my application shown below,
Try
Dim Oracle_num As New System.Data.SqlClient.SqlCommand(("SELECT Oracle_no FROM gprdsql.TblOracleNos WHERE Prac_no='" & _
[code].....
I am trying to deserialize my data and I keep getting an error.I'm hoping for any ideas of what could be the problem.My code in Visual Basic Express 2010:Imports System.Xml.Serialization
Imports Systm.IO
Public Class Form1
Structure gro
[code]....
I have MSaccess database.I have 2 tables 1) CUSTOMER TABLE=----CUSTOMER ID-Primary --AUTO NUMBER2) ORDER TABLE =----(CUSTOMER ID--Foreign KEY) Now From the front end using VB.net I have an page in which if i enter Customer details and press button add .I have to INSERT into values into CUSTOMER TABLE and I Also at the same time INSERT into ORDER TABLE with this CUSTOMER ID which i generated now.How is it possibl
View 13 RepliesThis error occures when I try to load my data into a datagrid with btnTonen or frmLoad after starting up the program. But after I do something else in the program the data will acctually load when I click btnTonen.
Private Sub btnKlantTonen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnKlantTonen.Click
Dim strSQL As String = ""
strSQL = "SELECT * FROM tblKlanten ORDER BY fldKlantNaam"
[code]....
I'm trying to load data into a DGV row at a time from a dataset and keep getting the following error on the highlighted line.
Private Sub LoadClientGrid()
Try
grdClientList.Rows.Clear()
For Each row As DataRow In rsClientGrid.Tables("tblClients").Rows
Dim grdRow As New DataGridViewRow
[Code] .....
I have a code here which is to insert values in both the tables which has Relationship.[code]...
View 4 RepliesI tried the following code which doesn't throw an error but it doesn't show as well in textboxes:
Try
cnobj = con.cn
cmd.Connection = cnobj
[code].....
I am only pasting what I feel is relevant to this error but if you deem necessary I will paste the w hole code,software used- sqlserver 2005 express, VS 2008 express - language vb.netlittle extra info is added at the end of this code
View 14 Repliesi am getting id from the url and pass it to sqldatasource - selectcommand i get thefollowing error : Conversion failed when converting the varchar value '<%=MyIdVal%> to data type int.
code behind :
Public Partial Class Edit
Inherits System.Web.UI.Page
[code].....
I have recently installed Visual Studio .NET (Pro Edition) and I have tried to run the Data Form Wizard and get an error after entering the "Name" for the dataset and hitting "Next". An error message pops up and says "An unexpected error has occured: Specified argument was out of the range of valid values.Parameter name '0' is not a valid value for 'index'.
View 6 RepliesI built a database from an .sql script file in Microsoft SQL Server 2008 Express Management Studio.Now, I need to connect an application I'm developing to this database. So in Visual Basic 2008 Express (that's what I use) I go to:
Data-->Add New Data Source-->Database-->New Connection
In the dialog which pops up (name: Add Connection) I set:
Data Source = Microsoft SQL Server Database File
[code]....
I am recieving this error on this line
ctl.Value = CType(Me.Value, DateTime)
Conversion from type 'DBNull' to type 'Date' is not valid.
I am using Data Grid View and This is a calendar Type Column
I'm having a bit of trouble developing my login page! Currently i have 2 text boxes which a user can input a username and password. My form should then check whether this data relates to the data in the database and either grant or deny access.The error i'm receiving occurs at the line "If theDataReader.HasRows Then"It says 'The data reader has been used before it is assigned a value"
Here is my code:
Imports
System.Data.SqlClient
Partial
[code]....
I am trying to make a small application and I have a problem in binding data after filtering them.I use VB 2005 and SQL 2005. The data are shown in datagridview and I bind the selected row to the text boxes of the form. eg.[code]Later on I search the data for some records and at the same time I remove the databinding. When I try to bind them again it does not work because the index is from the whole data and not the filter data.I have fixed the problem in another situation where I had autonumberin as a primary key and I used this as an index. In this case I use platesno as an index and it's not working.
View 3 RepliesMy program in VB.net has been using in 4 years already. I coded it in my computer and run in other computer. It's modified several times and it still woked fine. Today, I modified it again. It works well in my computer, but when I run it in other computers, I got an error:
" Failed to decrypt using provider 'RsaProtedtedConfigurationProvider'. Error messsage from the provider: Bad Data."
Error "there is no row at position 1" when saving data from datatable to database. I have two relational tables like "tbleInvoice" and "tblInoiceDetail" .
tblInvoice is a Parent table and tblInvoiceDetail
is a child table where InvoiceID is a primary key of tblInvoice & foreign key of tblInvoiceDetail in the database.The problem is that when i click the save button the data will be saved into database but also showing Error "there is no row at position 1".my coding structure is an under
Try
Dim com As new OleDBConnection
com.Connection= DBConn[code].....
Actually in our project we create different database using vb form code..so this database is a chance of transferring to other users to use others database. so when we create the database it will insert the database name into the main database. Problem: One user who is accessing MS 2010 ACCESS has created a database and transferred into other PC where MS 2003 access available..when he is going to insert database name into main database which is transferred it is not inserting into main database exception is occured..
[Code]...
debug this code(especially on the highlighted one, it is where the bug occur)
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim myConnection As SqlConnection
Dim myCommand As New SqlCommand
Dim ra As String
[code].....