VB/Web Programmer & dB implementor
I am working in a major bank, and implementing an internal intranet site for our department. i just started learning VB and will use that to leverage my learning for ASP/COM/etc.
VB will be useful for connecting the employee database from a client/server perspective, and ASP will be used to connect the database on the web site.
Databases, Databases, Databases!
I do almost all database work.
My job descript/function is reporting I suppose.
I'm the "guru" when it comes to what is/isn't available in our Oracle Datawarehouse, and I work on applications to extract business-specific information.
I use a whole slew of tools, since I'm no VB expert in any shape or form.
Data extracts come from:
SAP
Oracle
Access 97 (soon to be 2k) networked apps.
Manipulation performed by:
VB
Access 97/VBA
Monarch
Outputs into:
However they want it. Delimited text, Excel format, hard copy reports (whee the report builder sucks in Access?)
I want to shed Access as much as possible, and move it to a VB --> Oracle environment.
I'm getting resistance from the higher-ups since they've got no one other than me to maintain the stuff =[
So maybe it won't happen; but once they see some of the performance improvements I'll more than likely get the green light.
Yay I get to learn ADO!
Also Databases, Databases, Databases
Hey JohnAtWork,
You and I are kindred-spirits. I do the same thing. I was beginning to think that I was the only one who did this kind of thing.
Instead of SAP my company went with BaaN. BaaN has an OLE interface whereas you can send BaaN-SQL commands directly to the program and pull the data directly from the databases to your PC. I learned VB just to do this. I have been doing this type of thing with DOS based systems since 1984.
The company's managers come to me for their information rather then going to IT or MIS or whatever they call themselves these days. My exprience with IT is that when they do supply you the data it's on piles of paper, or they ask "Why do you need that?" or they say "That can't be done."
Most managers prefer their data in Excel so they can do their own analysis but I have supplied data in delimited or fixed-field ASCII files, Access, or whatever the customer wants all using VB. I also use VB to strip the data from reports as I've found Monarch cumbersome.
Al.