New Posts New Posts RSS Feed: Suggestions for Multi-Database Solution
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Suggestions for Multi-Database Solution
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
iDave View Drop Down
Newbie
Newbie
Avatar

Joined: 27-Jun-2011
Location: België
Posts: 11 		Post Options Post Options   Quote iDave Quote  Post ReplyReply Direct Link To This Post Topic: Suggestions for Multi-Database Solution
    Posted: 27-Jun-2011 at 11:22am
Hello to everyone,

We are just starting with DevForce 2010 and would like to know how should we implement the Multi-Database approach to our solutions using your technology.

We came from another technology, LLBLGen Pro. In our solutions, we offer to our clients the freedom to choose from some variety of databases, which are: MySQL, PostgreSQL, Oracle, MS SQL Server, ...
To make things easy to our customers, we created a Wizard, using this, they can choose the database, and type the requiered fields (user, passowrd, ip/host, ports, etc), make connectivity tests, and if all is correct, save the fields (encrypted) in the local machine.

Later in the application, if they call for example, to show a list of... I don't know.. products, we pass the connection string (which is decrypted) to the constructor. And the list is shown.

Thanks in advance.
Dave
Back to Top
iDave View Drop Down
Newbie
Newbie
Avatar

Joined: 27-Jun-2011
Location: België
Posts: 11 		Post Options Post Options   Quote iDave Quote  Post ReplyReply Direct Link To This Post Posted: 04-Jul-2011 at 6:52pm
Is this the appropiate section for my question? Or is this not related to DevForce produkt?

Regards,
Dave
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 786 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post Posted: 05-Jul-2011 at 8:43am
Hi iDave,
I apologize for the delayed response.
 
DevForce will work with all the DBs you mentioned above. (and others too)
 
Also, you can indeed specify the connection programmatically. There is a topic in the DevForce Resouce Center explaining the process.
 
Kind regards,
   Silvio.
Back to Top
iDave View Drop Down
Newbie
Newbie
Avatar

Joined: 27-Jun-2011
Location: België
Posts: 11 		Post Options Post Options   Quote iDave Quote  Post ReplyReply Direct Link To This Post Posted: 08-Jul-2011 at 12:16pm
Hallo Silvio,

Thanks for your kind reply. For a minute I though I posted in the wrong section...
Anyway, one last question, does DevForce 2010 works with Devart data providers?
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down