 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / General 2 / August 2006Deploying VB application on Intratnet .. with remote locations systems
Hi, i have a application which currenlty runs in a LAN with in same buliding . .. uses a oracle database server.. now the need of the client is to .. have systems at diffrenet locations to access the server .. what steps do i need to do this 1. client has taken new static ip .. so that can be used for oralce db server to be accesed by remote computers can any one let me go thorugh the steps ? i can come on chat at same id on google talk praveen junkpraveen@gmail.com > Hi, i have a application which currenlty runs in a LAN with in same > buliding . .. uses a oracle database server.. now the need of the [quoted text clipped - 7 lines] > > i can come on chat at same id on google talk I think you have to specify your problem a little bit better. Are your VB app today run off a server by all the clients? Is the new requirement such that the client app should now be installed on each workstation instead? (This should make *no* difference) Neither VB nor Oracle cares about the client-machines IP-adress More details on how it is today, what is changing, and what you are unsure about...  SignatureDag. Hi thanks very much for your intrest in my issue Currently the application is running multiple clients that are vb front on multiple machines.. and a these clients access DB server. 1. The need is now that the clients will be put on diffrent geographical locations in city 2. now these clients wil access db from remote location .. using a public IP which will be assigned to the machine running the server 3. what steps do i need to take so that i can run this application from remote locations and access the DB server, 4. also there is a need that we are developing web app based on the DB and we want to host this web app in the same machine running DB and even host a website on that 5. what steps do i need to take so that this machine can be made available on internet too. The things i can make out is that .. the client has 1.5 mbps internet connection and a static IP to use I will install web server on the machine now how can i point my domain name to this IP? and other things .. one by one.. > > Hi, i have a application which currenlty runs in a LAN with in same > > buliding . .. uses a oracle database server.. now the need of the [quoted text clipped - 19 lines] > More details on how it is today, what is changing, and what > you are unsure about... > Hi thanks very much for your intrest in my issue > [quoted text clipped - 5 lines] > 2. now these clients wil access db from remote location .. using a > public IP which will be assigned to the machine running the server Very little of this is a VB or Oracle issue, other than perhaps changing the entry in the tnsnames.ora file for the clients. It is however a fairly large IT issue. Your client needs some IT staff or a good network consulting firm. The server cannot simply be exposed to the Internet; it would be gobbled up by hackers 'n' spammers in minutes. They will probably want something like VPN over SSC, which takes some hardware and serious network engineering. When the dust settles, you then have a server accessible to your client app just as before, with essentially no change on the VB or Oracle end. >> Hi thanks very much for your intrest in my issue >> [quoted text clipped - 18 lines] > server accessible to your client app just as before, with essentially > no change on the VB or Oracle end. Correct! If you instead choose to go the web-app way (I would), rewrite the client-app as asp web-pages instead. If your existing client-app have its business-logic separated into ActiveX dlls already, the asp-pages can use it directly. The asp.pages can access the db directly (ODBC), or you create a data-access layer. SignatureDag. > If you instead choose to go the web-app way (I would), rewrite the > client-app as asp web-pages instead. If your existing client-app > have its business-logic separated into ActiveX dlls already, the > asp-pages can use it directly. I would too, or, if you use .Net (can you say that here?), you can write it as a web service. This lets you put most of the app on the server under ASP, just as with a web app, while still having all the bells and whistles of a client windows app (smoother grids, local data caching, etc). Big install required, but for in-house deployment, thats pretty easy to do. The results, I must say, are quite impressive, even if it is MS and .Net and bloated and all that. >> If you instead choose to go the web-app way (I would), rewrite the >> client-app as asp web-pages instead. If your existing client-app [quoted text clipped - 8 lines] > deployment, thats pretty easy to do. The results, I must say, are > quite impressive, even if it is MS and .Net and bloated and all that. That is also a good idea! I'll just have to add that you don't need .NET to write all the business logic as web services. I have written several in VB6. If you have the core buisiness logic as activeX dlls, it's just a matter of running a Wizard on them to pick the menthods you want to expose as web-services... SignatureDag. > I'll just have to add that you don't need .NET to write all the business > logic as web services. I have written several in VB6. > > If you have the core buisiness logic as activeX dlls, it's just a matter > of running a Wizard on them to pick the menthods you want to expose as > web-services... I agree on the server side, but I am not aware of an easy way to use web services for data in a VB6 client. Using one in a .Net windows client is quite easy. That's where the big install comes in, though. >> I'll just have to add that you don't need .NET to write all the >> business logic as web services. I have written several in VB6. [quoted text clipped - 6 lines] > web services for data in a VB6 client. Using one in a .Net windows > client is quite easy. That's where the big install comes in, though. Complex data-structures like classes are a PITA to marshall in VB6, even with the WSDL file, but discrete datatypes like String, Long, Byte, Boolean, et.c is pretty straightforward. you just add a reference to Microsoft SOAP Type Library (MSSOAP1.dll) to your project, and put this in your code: Dim oSOAPClient As SoapClient Set oSOAPClient = New SoapClient oSOAPClient.mssoapinit _ "http://www.dagsunde.com/soap/urn:dagsunde-quotes.wsdl" MsgBox objSOAPClient.getQuote("IBM") SignatureDag. >> I agree on the server side, but I am not aware of an easy way to use >> web services for data in a VB6 client. Using one in a .Net windows [quoted text clipped - 14 lines] > > MsgBox objSOAPClient.getQuote("IBM") Thanks for the sample, Dag, I will try some things out. There are some places where some simple data transfers would be useful. The big attraction of a .Net client to me was being able to pass an entire data set in one call - a project record, with maybe a dozen related detail records. The client can then mess around on their own, updating several records at once, and save by sending the whole data set back at once. Thanks steve .. yes have to think on security lines also .. > > Hi thanks very much for your intrest in my issue > > [quoted text clipped - 17 lines] > settles, you then have a server accessible to your client app just as before, > with essentially no change on the VB or Oracle end. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.