How do I interface VB6 with Banking application

[prettyangel]

A payroll software was designed with VB6 as the front end and MSSQLServer 7.0 as the back end. Now I'm being asked to interface it with a banking application such that employee/Client bank account will be automatically credited once the software is run.
How do I go about it? Code snippets will be appreciated.

 

[fredericofonseca]

Code snippets for what?
SQL Updates inserts? you surely already have that to update your SQL Server.

To apply business rules? why would any code we could show be any different of what you have already? and how would we know the rules?

What you need to do is ask the developers of the OTHER banking application and see how they allow their database to be updated by yours.

This varies a lot and there is nothing we can say that will help you until we know how the updates can be done.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[prettyangel]

Fred thank you so much. I will do just that and hope you will still be available when I'm done.

 

[prettyangel]

Please Help!!!

The banking application will only take ASCII formats.
And there is an opportunity to upload from the banking application. Problem is I don't have much knowledge of Servers.
This banking application is in MSSQL Server format on the branches and in Oracle format on the Head office server, how do I reconcile the two?

I need to generate code to credit staff account once payroll software is run.

 

[chiph]

You need to talk to the developers at the other company. They will *NOT* let you have direct access to their database, so forget about doing a simple Update or Insert command.

But they will likely have a way for you to upload files to a FTP site, call a webservice, or post to a web form in order for you to send them data. Talk to them and see what they support.

Chip H.


____________________________________________________________________
Donate to Katrina relief:

http://s1.amazon.com/paypage/PELYGQVJ8Q7IB/103-6821258-5919825

If you want to get the best response to a question, please read FAQ222-2244 first

 

[prettyangel]

chip H,
thanks I'm on it, will get back to you.

 

[prettyangel]

Hi all,
please I'm back. You asked me to get some things which i've done. Like I said earlier I need to interface the payroll application with a third party banking application such that staffs account will be automatically credited with their salary.

The format required by the external application is ASCII file format. This format will have a header row,

Header row should contain 49 blank spaces followed by a carriage control (enter key)

BIG QUESTION:
HOW DO I INSERT 49 BLANK SPACES PLUS A CARRIAGE CONTROL INTO AN OUTPUT FILE USING VB6 AS MY BACKEND?

 

[Swi]

Open "C:\YOURFILENAME.TXT" For Output as #1
Print #1, Space(49)
Close #1

Swi