Writting to same Database(SQL Server) via Front-end(VB 2005) and Web(ASP)

[Luzuko]

HI,

Im doing a project and the basic requirements of the project is that my Front-end application (VB 2005) and Web application(VB Scripting and ASP) should write and retrieve from the SAME database- Sql Server 2005.

Now im having trouble to even understand how these applications can share the same database. Can someone tell me how this is done. Code Snippets would help a lot.

Kind Regards

[ck9663]

HI,

Im doing a project and the basic requirements of the project is that my Front-end application (VB 2005) and Web application(VB Scripting and ASP) should write and retrieve from the SAME database- Sql Server 2005.

Now im having trouble to even understand how these applications can share the same database. Can someone tell me how this is done. Code Snippets would help a lot.

Kind Regards

some of the expert here will disagree with me...but for simple discussion, let's not call your front-end tools an application for now...

you will mostly use front-end tool to create the GUI for your users. in some part of this GUI, you're going to attempt to connect to your database to grab some data, authenticate users, among others....these data could be coming from single or multiple database or even multiple servers. your connection could also vary depending on what kind of data you are connecting into

after a successful connection to the database, you might want to either reflect changes on your data in the database or present the returning result set to your user in a "presentabl e-user requested-user understandable" way.

hope this helps a bit

[iburyak]

It is easily done because database is the same and you just have to connect to it and use data as desired. It is like you ask if you will call from a cell phone or home phone or work phone to the same number who I reach.
The phone number is the same so you will reach the same person or in your case if connect information is the same you will get to the same data.

For code samples on how to access database from VB6 or ASP go to respective forums.

Thank you and good luck.