vb helpdesk connect to sql server?

[thexero]

hey

in my organisation we are creating a new helpdesk, another guy has the task of creating the database etc using sql server and my task is to build the client side application

the interfaces are all built but how would i access the sql server? it is stored on a remote system so would that mean i would have to use the tcp client to connect to taht machine first or is sql server broadcast out anyway?

i'm using vb.net 2008 express for this but i didn't install the sql server express that comes with it because i wouldn't be using it but a remote sql server

any ideas

cheers

 

[team929]

just curious, what project are you using? I just finished a helpdesk system of our own and we used asp.net for this since rollout just means to the web server as everyone already has a web browser installed.

I think connections would be slightly different depending on the project type.

 

[thexero]

well the primary interface is aspx and is nearly complete, but i am creating a standalone application for my personal use, i like to set myself projects for everything i do