C# - Accessing Mainframe Transactions Using .Net 4

Jul 5, 2010

I am looking at re-writing an application (currently in C) which uses HIS 2004 (Could use 2009 if required) to access mainframe transactions. Is there a decent framework which I could use to connect and call mainframe transactions and relay any infromation into the existing system? ( I am developing in a .Net 4 environment) to remove the c coded requirement?

ADVERTISEMENT

Connect To Mainframe DB2 Using OLEDB?

May 17, 2012

I am having connection issue while connecting to using below string
provider=IBMDADB2;Data Source=XXXX.XXXXX.COM:5000;Database=C2RCU0;Uid=s858;Pwd=cccc

Getting error like database not found. But What i found was connection to mainframes it self was not happenning. Do i need to provide any other information or what i am missing here..

sConnection As String = "provider=IBMDADB2;Data Source=XXXX.XXXXX.COM:5000;Database=C2RCU0;Uid=s858;Pwd=cccc"
Dim sql As String = "SELECT COUNT(*) FROM DB2.TEXT_PHRASE WHERE FK_CD = '00078'

[Code].....

I am getting error and showing connection time out in details but exception what i am catching is database name not found

View 9 Replies View Related

Uploading Files To Mainframe?

Nov 5, 2009

I am uploading file to mainframe and before uploading when I open it using notepad I am able to view it.

Once uploaded the administrator is complaining that he is not able to read the data in file and it appears as junk.

Is there anything else I need to do before uploading files to mainframes. I am using Chilkat component to upload the files to mainframes.

View 2 Replies View Related

Upload And Download Files From And To Mainframe?

Sep 1, 2009

How do I upload and download files from and to Mainframe dataset using VB.net

View 2 Replies View Related

.NET : Reading/Editing Mainframe VSAM Files?

Dec 28, 2011

I have seen application that are written in Java that can interface to CICS regions on the Mainframe(haven't seen the source code). I am looking for an alternative to the Java method in VB or C# that I can use to connect to a z/OS Mainframe 3270 to retrieve records in VSAM files.

View 1 Replies View Related

File I/O And Registry :: Using .NET 3.5 To Retrieve Files From IBM Mainframe

Jun 2, 2010

I know how to get a list of files in a local Windows machine's specific directory:

Dim dirInfo As DirectoryInfo = New DirectoryInfo("C:Temp")
Dim fileListing() As FileInfo = dirInfo.GetFiles()

But how do I use this class for a mainframe system where user ID, password and 'change directory' command are needed?

When I attempt to just access the server without credentials and just do the Windows version and use the syntax "\server_nameAUTO:RPTS.", where 'AUTO:RPTS.' is the mainframe directory name I get the following error: "The given path's format is not supported."

When I just use '\server_name' I get: "The UNC path should be of the form \servershare."

View 1 Replies View Related

'kick-start' A Jcl Stream On Mainframe Using FTP Inside 2008

Aug 14, 2009

The following is the code that uploades a bytearray into a file DSN on our mainframe. It works very well.What I want to do is upload the jcl which should then start to execute.I used to be able to do it through WININET, but I want to get away from that and use the better FTP commands in vb.net. [code]

View 1 Replies View Related

Fix 'Conversion From SOAP Failed' Fault While Consuming Mainframe Web Service

Mar 23, 2012

I'm currently working on a VB. Net web service calling another web service running in the mainframe. I was provided with the WSDL file and I generated a proxy class using wsdl.exe. Upon attempting to invoke the method of the mainframe web service using the proxy class, I encountered an exception saying "Conversion from SOAP failed" coming from a line of code in the generated proxy class.

View 1 Replies View Related

Transactions Not Committing To Db

Nov 10, 2010

I have installed SQL Server 2005 Express and VB 2008 Express.

For testing, I created a database with 1 table with 4 columns. I used SQL Server to add 2 records. I then created a new project with 2 forms. On one form, I put a DataGridView control. On the other, I used bound text boxes. Both had a ToolStrip. I made changes to the data through the forms. Both forms seemed to work properly, except when I looked at the data again using SQL Server, the data had not changed. Opening the forms again, the data had reverted to the original data.

I am using the code created by controls, so it should work. When I use the Database Explorer in VB, it shows the table and the data and I can make changes to that data. So why is my code not committing the transactions?[code]...

View 2 Replies View Related

VS 2005 How To Use Transactions

Oct 26, 2010

I am trying to use SqlTransaction object in my vb code for an application to insert vendor info.The code runs till inserting a transaction and then gives following exception:

"Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized."

[code]...

View 3 Replies View Related

Asp.net - SQL Transactions: TSQL Versus .NET?

Nov 19, 2010

I wanted to know what (if any) differences there are to using the SQL Transaction within the application versus written into the stored procedure using TSQL statement. We would need to restructure the stored procs and vb code to get this to work and I'm not sure it would be worth the effort at this time.

Public Sub RetrieveTData(ByVal cID As String, ByVal cnn As SqlConnection) As Boolean
Dim sqlTran As SqlTransaction
cnn.Open()
sqlTran = cnn.BeginTransaction

[code].....

We aren't certain whether the timeout is occurring in DataAlreadyTransferred() or usp_BigNasty_CopyDataFromDB1toDB2 due to how the try/catch is written. We can restructure this code, but will take a week or so to get it to production (no errors occur on test/dev today)

DB1 - permanent storage, used by other applications as well
DB2 - working set, used only by Web App

DataAlreadyTransferred(cID) first checks to see if DB2 has any copies of the records, if DB2 does and those records are clean it deletes them (data could have changed in DB1 and we want the most up-to-date version). If DB2's data is dirty it is left alone and no data is deleted.

usp_BigNasty_CopyDataFromDB1toDB2 copies rows from approximately 20-30 different tables and copies over the perm copies from DB1 into DB2, essentially creating a working set from which the Web App can access

We are aware this is inefficient and are examining ways to improve it, just haven't had time yet... I believe by having the transactions in the app code it's locking many more tables than is really needed. If we move them to the stored procs, less tables will be locked at one time thus improving our chances of removing deadlock conditions/timeout issues we're seeing today. Just not sure on this..

View 2 Replies View Related

DbProviderFactory Class And DB2 Transactions?

Apr 1, 2010

I am using the SQL Server and DB2 in my application. The DB2 transactions do not work with the DBProviderFactory Class but SQL Server work. I have to use to separate DB2 API's to make the transactions work but its very messy and involves a lot of code change.I extend DBProviderFactory class and add the DB2 transactions to it?

View 3 Replies View Related

How To Make Payment/transactions In VB

Feb 15, 2012

Can someone here give me an idea how should I make a transaction form or should we say a payment form.I already have a database with lists of students in it.Also a database with an event in it. Along with a fee on which every student should pay.

The problem is I want to make a form on which if this entry(student)were to make a payment his/her name will be marked as paid in the student database.More like a payroll system.Sorry I am kinda noob when it comes to equations or money matters in Vb.net All I know is add edit delete and search. Can somebody point me to a tutorial or a good idea where to begin?

View 1 Replies View Related

Take The Backup Of Database For After Each And Every Transactions?

May 22, 2009

I am using vb.net and ms access for developing windows applications. I want to know how to take the backup of database for after each and every transactions.

View 2 Replies View Related

TRANSACTIONS RE: Displaying The Total ?

Oct 23, 2009

CODE:

This is my code. I have a problem in displaying the total. Once checkbox is checked it adds the computation to the total. and when it is unchecked, even if the textbox= 0 still, the value of the total is retained.

When you are posting code please use code tags like this.

View 1 Replies View Related

Use One SQL Connection With Multiple Transactions?

Sep 19, 2011

I have a vb.net web app and I am passing a SQL connection and a transaction to a method which writes a single record to the database.

I would like to start and commit a transaction for each record that is written but using the same sql connection until the loop is done.

One method I saw was utilizing a using statement but it didn't work for me.it runs the first time and gives an error on the second that the transaction has already been commited

Using sqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)

[Code]....

View 2 Replies View Related

Asynchronous Transactions With Xml Https Post

Jun 3, 2011

I basically have a few thousand transactions 7,000 - 10,000 transactions to process over a short time. The flow goes like this.

---> ----> ---> ---> receive (1000) as each transaction takes approx 2 seconds so if i were to process synchronously it would take all night......

Now first i would like to ask if i am going about this the right way ? the service i am communicating with is not .net but is built to handle large amounts of requests. I have obtained the following code that suggests it will do what i am after

dim strxmlreq as string = '(this is where i input my xml string)
Dim request As HttpWebRequest

' Create the request

[CODE]...

The problem i have is if the above will work for me where exactly do i catch the returned xml string ? I assumed "result" would be the xml output string.

View 3 Replies View Related

Download Transactions Info From Paypal Using VB?

Sep 5, 2011

How do I download transactions info from Paypal using VB.NET

I want to create an app which when i press a button. It downloads each new Paypal transaction to a textfile. I would like information like purchase item name, item description. And price to be added to textfile.

[code]...Download Transactions Info From Paypal Using VB?

View 4 Replies View Related

Download Transactions Info From Paypal?

Sep 5, 2011

How do I download transactions info from Paypal using VB.NET I want to create an app which when i press a button. It downloads each new Paypal transaction to a textfile. I would like information like purchase item name, item description. And price to be added to textfile. VB.Net in relation to a local computer is something I can work with. Put with intergrating VB.NET with Paypal is alittle out of my depth.

View 3 Replies View Related

One Big Transaction Or Multiple Small Transactions?

Dec 22, 2011

whether is it feasible to commit one huge transaction per time or do it multiple times.Lets say around 1000 - 3000 of mixed updating or inserting rows for per transaction or having a loop to commit every transaction as it loops.Which one is preferred ? will it have any impact ?

View 3 Replies View Related

VS 2010 Atomic Transactions With DataSets?

Apr 18, 2011

So I'm developing a program were, given some data by the user, the prorgam inserts some records into a database. To insert individual records in different tables I use either the standard INSERT method provided by the Table Data Adapter or a custom Insert Method when I want to insert something slightly differently.Sometimes the user would press a button and an operation where different records in different related tables are inserted. Since each Insert is handled individually for by the DataAdapters of each table, how can I manage to bring the whole thing to an atomic transaction way? I mean, let's say for example the User inserts a new Document in the system, the document has one or many Editions. How could i do something like: if the document was not created properly, then do not insert the editions.

View 2 Replies View Related

Embedding BEGIN / COMMIT / ROLLBACK Transactions ?

Nov 24, 2011

I would like to use the transactions commit/rollback against a sql server rdbms within a VB  2010 module.  I understand how these can be executed within a Transact-SQL session, but cannot seem to be able to code them correctly within VB as these are more like DDL statements.

View 4 Replies View Related

VS 2008 - Download Transactions Info From Paypal?

Sep 5, 2011

How do I download transactions info from Paypal using VB.NET I want to create an app which when i press a button. It downloads each new Paypal transaction to a textfile. I would like information like purchase item name, item description. And price to be added to textfile.VB.Net in relation to a local computer is something I can work with. Put with intergrating VB.NET with Paypal is alittle out of my depth.

View 1 Replies View Related

Create A Database Application That Will Keep Records Of All Cash Transactions

Aug 2, 2010

I am trying to create a database application that will keep records of all cash transactions. how to print a cash receipt to give it to the customer?

View 2 Replies View Related

Prevent Data Layer Refactoring Of ODP.NET Code And Transactions?

Aug 27, 2009

I am using Oracle 11g client, with ODP.NET. I am trying to add conditional Transaction handling.

Dim ds As New DataSet()
Dim txn As OracleTransaction
Dim _beginTransaction as Bolean = true
Using conn As New OracleConnection(ConnString)

[Code]...

How do I fix txn being nothing / null? The error is: Variable 'txn' is used before it has been assigned a value. A null reference exception could result at runtime. Edit: to RichardOD for pointing out that you can not explicitly declare that a transaction cannot be opend up on stored procedures via ODP.NET. I have verified that this is an issue. BUT We still haven't figured out why the error is occuring. I understand that txn is initially given a value w/in an if statement, but being defined outside of the try/catch block should make that irrelevant.... right? Or is that bad coding?

View 3 Replies View Related

Transactions - Expose Private Fields Using A Partial Class?

Nov 12, 2010

I am trying to implement transactions across multiple TableAdapters in VB.NET (using Visual Studio 2010) by extending the partial class as described in the following examples:

http://blah.winsmarts.com/2006/06/18/the-definitive-tableadapters--transactions-blog-post.aspx
madprops.org/blog/typed-datasets-and-sqltransaction/
stackoverflow.com/questions/2342289/net-tableadapter-to-dataadapter

However, when I attempt to expose any of the private fields created by the designer they are underlined in the editor with the following error:

'_adapter' is not declared. It may be inaccessible due to its protection
level.

Searching this site as well as google has not revealed anything useful, but perhpas I'm searching the wrong keywords.

Here is the code in MyDataset.vb

Partial Public Class MyTableAdapter
Public Property MyTransaction() As SqlTransaction
Get

[code]....

View 1 Replies View Related

Transactions Approved By Authorize.Net With Incorrect Expiration Date And CVS Number

May 17, 2011

I have currently processed a credit card using Authorize.net with Card Present settings. The great thing is that the card is being transacted but when i use the same card with different expiry date or a different cvs number the card is still being transacted. This shouldnt happen. Here is the code that im using in VB.NET.[code]

View 1 Replies View Related

Transaction Manager Has Disabled Its Support For Remote / Network Transactions.

Apr 12, 2012

I'm using SQL Server and ASP.NET.[code]I have worked this way in another application with the same environment without a problem, but here I have this problem.

View 1 Replies View Related

The Type Initializer For 'System.Transactions.Diagnostics.DiagnosticTrace' Threw An Exception

Feb 9, 2011

an error throws up on the line:

con.open()

it says "The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception."
 
Private Sub BtnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnLoad.Click
Dim Con As New OleDb.OleDbConnection
Dim DbProvider As String

[code]....

View 2 Replies View Related

VS 2008 : Display A List Of "bank Transactions" : What Tool To Use

Jan 10, 2010

I'm trying to display a list of "bank transactions" (these are fake, it's a game) so no need to worry about security but what tool should I use? I've use a Grid view for other parts of the game and don't want to "overuse" this tool.The list may have 2 rows it may have 30 rows although I might limit this? It will need to be able to use a date, a text reason and a value.

View 3 Replies View Related

Accessing Word Tables Created In Word Templates / Accessing Existing Bookmarks In Word Templates?

Jun 30, 2010

Basically in visual basic 6 I could access word tables in existing templates with the code owordactivedoc.tables(1).select()  where owordactivedoc refers to the active word document and tables(1) refers to the first table in the template.Trying the same code in VB 2003 just leads to errors.  Secondly how do I access bookmarks or alternatively word variables.Furthermore how do one deploy web.services.  For example the current program I am building is for another computer. Simply copying the web service to Inetpubwwwroot dont work because it is not picked up by the Internet Information Services program. I have to create the web service in vb2003 on the other computer change msconfig manually. Copy and paste the existing service vb file in the created folder replacing the empty vb file. 

View 3 Replies View Related

Accessing .Net Dll In VB6?

Jul 2, 2009

I am having a .net dll. Now i want to access it in my VB6 project. SO i don't know how to register it and also I am not sure whether the dll has comattribute specified in it or not.

View 1 Replies View Related

.net - Error Accessing MQs From .NET?

Mar 15, 2012

I have a VB.NET console application that must write a message onto a queue (resides on the mainframe). We have all the clustering and everything set-up by our admin. We already have an existing windows service that successfully listens to messages and also writes messages to various queues.I have basically re-used most of my code from the windows service project.But when I try to access the queue manager, I hit the exception "MQRC_HOST_NOT_AVAILABLE". The error log from the Websphere MQ folder says

AMQ9213: A communications error for occurred.

EXPLANATION:An unexpected error occurred in communications.

ACTION:The return code from the call was 0 (X'0'). Record these values and tell the systems administrator.

Here is the complete exception stack.

IBM.WMQ.MQException was unhandled
Message="MQRC_HOST_NOT_AVAILABLE"
Source="amqmdnet"
StackTrace:

[code]....

View 2 Replies View Related

Accessing .NET Code From VB?

Feb 23, 2009

I have an ASP.NET (C# Code-behind) code. I need the very same functionality in one of my VB 6.0 program. As the code is too complex, I don't want to replicate it in VB once again.

Now, is there any way to access my .NET code from VB?

View 5 Replies View Related

Accessing A Rectangle's Value?

Apr 14, 2011

myObject.rect.X = 100

myObject has a property called rect (which is a Rectangle). During runtime I will want to chage the X position of such rectangle, but I am given this error:

Expression is a value and therefore cannot be the target of an assignment.

Then, how am I supposed to change such values?

View 1 Replies View Related

Accessing A Variable In Sub?

Mar 24, 2010

How do I access the sContents variable in loadBoard() sub to LoadTable() sub

Sub loadBoard()
Dim oFile As FileStream
Dim oReader As StreamReader = Nothing
Dim sContents As String

[code]....

View 2 Replies View Related

Accessing An .ini File?

Jul 27, 2011

I have a windows service on a server which accesses a folder and database which is on different server.i was told to create an .ini file and add the settings here. so i have to add the path to the folder and database in .ini file, correct?is there anything else which i should add in .ini file?is it compulsory to give the [section] in the .ini file?

How can i access this .ini file from my vb.net program?can i store this .ini file anywhere on the machine or it should be stored in a particular folder?

View 7 Replies View Related

Accessing Data In Vb?

Aug 14, 2009

i m preparing a project in vs 2008 i m unable to add new row to my database. i have created database in Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5)my problem is the data is updated in dataset but database is not updated.please help me out as i have to submit my project on 20 of aug 2009.

View 6 Replies View Related

Accessing New Cell Value?

Feb 6, 2010

How do I access the new value that a user has entered into a DataGridView cell? I've tried using the "e" parameter in several event types including CellLeave and each time I can only reference the old value.

View 4 Replies View Related

Accessing Services Using WMI

Nov 12, 2009

I am trying to access a remote 2003 server using WMI. I can connect but when I try things like listing the services for that server I get the following: Access is denied. (Exception from HRESULT: 0x80070005(E_ACESSDENIED). Using the same code, I can connect and get a list of services a remote 2008 server. Here is the code to connect to the server (which gets me connected):

[Code]...

View 1 Replies View Related

Accessing The End Of A List?

Sep 19, 2009

what is the quickest/neatest way of accessing the end of a list ? I have been using myvar=me]ylist(mylist.count-1)VB2008 user

View 7 Replies View Related

Accessing USB Port In VB6

Jun 17, 2008

I am new to this forum as will as to VB. I am using VB6. I want to access the USB port in order to read the data at the USB port comming from my Data acquisition card.Or as a matter of fact can I also access the data from my mouse, because it also transmits the signal when ever the mouse is moving.

View 3 Replies View Related

Accessing Variable From Within A Different Sub?

Mar 9, 2012

I have this,

Public Class posData
Public Property strLabel As String
Public Property strX As String

[Code]....

then i want to loop through all the objects within my list so i have a for each position in posList, inside this is where the problem occurs, i want to be able to write something like this, a1.blnavail, this is not happening however, i know i can use position.blnavail but i need to hardcode the position for my logic to work correctly

View 1 Replies View Related

Accessing Variable Through Another One

Mar 4, 2009

I have two variables, X and Y (this is just figurative)
X = 123
Y = X
How can I get that X out of the Y to be able to get the contents of X from the Y? I just want to be able to do something like tell a textbox to display the contents of the variable within the Y variable (thus, the contents of X).

View 4 Replies View Related

Accessing Word Through .net?

Jan 21, 2009

What I want to do is have my vb .net program open ms word and put an address into the envelope wizard this way the user can go from there adjusting the envelope size etc. In ms word 2007 I have found that if you hit alt, then 'm' then 'e' it will open the wizard and put the cursor in the right place to type the 'to:' address.Current I can open word and put the address directly into the new document.Here is what I have so far:

Dim oWord As Word.Application
Dim oDoc As Word.Document
Dim address As String
oWord = CreateObject("Word.Application")

[code]....

View 3 Replies View Related

ADVERTISEMENT