|
Dear members,
This is not a specific tec doubts. This all about your experience and your way of dealing the issue.
Brief idea:
We have an application which uses Sybase database as Backend and Dotnet( C# Lan) as Front-End. This application uses IAnywhere.Data.AsaClient.dll (managed provider for Sybase db). This application is a small supporting module for our ERP which is developed using Power Builder.
Real requirement.
Now we are deciding to make this application as a pluggable for our ERP and also can plugged into other ERPS or applications, which have raw data needed to run our pluggable application.
Here the raw data ( data required to run this pluggable application ) may be in different database ( Db2,Sql Server,Oracle,Sybase etc). But now we don't have any interface or mechanism to pull the data from other Databases into my data base with required form (field name and data types).
What will be the better solution to make my product as pluggable for other application. ?
What is the real industry standard to tackle this sort of scenarios. ?
If you need to face this issue, what you will prefer to get out of this ?
How will i make a Data Pipe kind of mechanism to get required data in required form from other databases ?
Please do comment for this query. Your post will be most appreciable.
Sreejith Nair
[ My Articles ]
|
|
|
|
|
for data migration from one DB to another, there is a DTS package which you can automate via SQL DMO. another solution is make an intermediate flat file to transfer the data between different databases. you must write one tool to export the data from different Databases in to a flat file(xml is a better choice), and after that you can parse that File and you can update your database.
Ninety-eight percent of the thrill comes from knowing that the thing you designed works, and works almost the way you expected it would. If that happens, part of you is in that machine.
|
|
|
|
|
how can i connect in to a database without specifying the DSN name in the connection string ?, i heard some string with the combination of SERVER ; DATABASE and DRIVER can do that ! i tried but i couldnt.. any idea?
thanks in advance
Situation : my program uses SQL server as database( local / remote ). user can add multiple companies( each company creates as seperate database), and i connects them via DSN , the problem is the DSN is creating in local machine. but the company details keeps in remote machine, any user connects to the remote machine can view the companies but he couldnot connect to that bcz the DSN resides in local machine from where the company was creted.
if there is any machanism to represent the DSN detailes in remote machine ( Table entries), i can connect into companies by using those info without depending the local DSN
Ninety-eight percent of the thrill comes from knowing that the thing you designed works, and works almost the way you expected it would. If that happens, part of you is in that machine.
|
|
|
|
|
<br />
string connectionString = "DRIVER={SQL Server};SERVER=ServerName;DATABASE=DatabaseName;UID=User; PWD=Password";<br />
Jeff Martin
My Blog
|
|
|
|
|
yes i tried this , but the problem is the database is not changing..
always i gets the database which one i connects first..
Ninety-eight percent of the thrill comes from knowing that the thing you designed works, and works almost the way you expected it would. If that happens, part of you is in that machine.
|
|
|
|
|
I'd have to see some code and this is not the correct forum for a discussion of database issues, this is for article ideas.
Jeff Martin
My Blog
|
|
|
|
|
 i'm working in a project of computer vision and control fuzzy, i will like to know how can i call a variable in a library *.dll for work in matlab, thank you
Marc Planells smith
|
|
|
|
|
|
First I will give the url to where the editor is at:
http://www.world4christ.com/messenger/sermonapp.html
Here is the problem: Everything works fine until I try to insert a tag, i.e.,
When I do this it makes the review page print where its not supposed to and the same with the final copy. I have disabled any required fields to make it easier. When I start to create something I start out with a paragraph tag followed by an image tag for some fancy lettering(currently the fancy letters only go up to J--they must be uppercase-it is described in the help file I'm putting together for the script. Any way-as I'm going on and then I'll try to insert a
followed by a couple spaces for neat looking paragraphs but what happens on the review page tells the rest. I love the article helper to death and have had a few minor issues with it which have all been resolved(many thanks to this forum and Jason. Any way, any leads to helping get this fixed would really be greatly appreciated-would put me yet one step closer to entering the promotion phase of the site project.
|
|
|
|
|
I installed Seamless Windows designed by Martin Wickett on a XP workstation and a Terminal Server Windows 2003. When I ran Remote Desktop Connection to
connect to the Terminal Server, I received the following error message:
"This application has failed to start because MSVCR70D.DLL has not found.
Re-installing the application may fix this problem"
I could not find MSVCR70D.DLL on my server. I reinstalled the Clipper on the server but I still got the same error.
Where can I find this file? What other software do I need to install on the server to make this works?
Please help!
Thank you.
Van Du
|
|
|
|
|
I am doing my final year project now. My project is build a system that calculate the shortest distance between two places. The problem is I must understand the Floyd Warshall algorithm to proceed. This is becase I use that algorithm to calculate the shortest distance. But I cant understand.
Can you all help me??? Please explain in the simplest way. I really feel very hard to understand the algorithm. Please help me!!! I am running out of time! Thank you!
|
|
|
|
|
hi,
Flora81 wrote:
I am doing my final year project now.
Flora81 wrote:
I am running out of time!
What were you doing all year(s)??
would this[^] help? Google shows lots of texts about this algorithm... Implementation seems to be VERY short... Read the text, and THAN say what exactly you don't understand... Than, maybe, I'll look into it, ok?
best regards,
David 'DNH' Nohejl
Never forget: "Stay kul and happy" (I.A.)
|
|
|
|
|
I'm in a situation where i need create 2 virtual ports which will be interchangeably switched to connect to a physical com port(exp: COM1, COM2). My question is, how do i create/map virtual ports to a physical com port? Can anybody point me on the right direction? Thanks a lot
|
|
|
|
|
Is there a way to monitor and log the users accessing a network share. Are there any specific APIs available. Thanks in advance.
|
|
|
|
|
Hi All,
I am planning of designing a knowledge base.I want to design in such a way that this knowledge base can import and export artices(txt,doc,pdf..)sepatate and store the articles according to different categories(C++,linux...),support search based on category,keyword..
Can someone suggest some ideas in developing such a system,or are there already available free softwares for this purpose.I wa planning to develop using C++.
Any suggestions is appreciated,
Thanks in advance
Raghu
|
|
|
|
|
|
I have applications, which need to dial-up to the bank for money transaction. I have asked to the bank to give me a some information about their protocol, but I received only one answer that your software should be compatible with VITAL slandered. Does anyone know how to make or send information to a bank for bank transaction. 
Agha khan
|
|
|
|
|
|
Although it may further the lack of productivity in offices everywhere, I would love to have a WMP plug-in for Visual Studio 2003. A nice pin-able tab where Family Guy, Simpsons, or music can play with out getting in the way all the time is what I would like. I got as far as getting Windows Media Player 9 to show up in a tab, but not actually functioning before I gave up for lack of time to figure the rest out . So, if anyone is feeling ambitious, I would love to add this to my development environment.
|
|
|
|
|
|
I'm guessing I need Windows 2003 to take advantage of that... I do some server programming so I have found it is just best to run server all the time rather then dual booting, especially since I reboot about once a month..
|
|
|
|
|
|
Hi all,
Does anyone know how to access the hard disk S.M.A.R.T. info under windows? I cant seem to find any info on it at all!
I'm guessing it may be something to do with low level IO requests.
Many thanks
Stu
|
|
|
|
|
|
Hi, i will be launching a site on which i will have a birthday reminder service along with some other features. Site is being made with the help of ASP and MSAccess. its birthday reminder service is a bit similar to that of birthdayalarm.com. Now if you go to www.birthdayalarm.com you will notice that when it gives you an option to add birthdays to your list, it allows you to get access to your msn list on that very site..a user just has to enter his msn/yahoo id and password on that site and then it shows his full contact list, and then with just one click it can e-mail all those users in the contact list. I want that kind of a system with which users on my site can have access to their msn and yahoo contact list...after they provide their user id and password. Does someone has any idea on how that thing can be made available on my site...any help would be greatly appreciated as its a really important part of my site. Any help (specially with some detailed instructions) would be greatly appreciated.
thnx
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
