Where to start? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Where to start?

Author

Topic

JapanDave
Starting Member

10 Posts

Posted - 2012-07-04 : 08:34:14

Hey all. I tried to find forum rules on posting titles and etiquette, but could not find any, so please let me know if I need to amend the title etc.

I need to create a database for a hospital and the only experience I have had is with using Excel and Access on the back end, using ADO VBA to retrieve sql strings. I know my way around VBA , but I have no clue where to start with SQLServer.

My first instinct was to use Excel as a front end with SQLServer as a back end, but after a fair bit of research, the general consensus is this is not a good idea.

So , doing everything from SQLServer, where do I start? I have briefly perused the FAQ's, but I was hoping someone could point in the right direction for database setup and creating a user interface.

Cheers

Dave

Grifter
Constraint Violating Yak Guru

274 Posts

Posted - 2012-07-04 : 08:51:19

I would have thought a Windows Form interface would be easiest linked to SQL Server tables for data. I worked in healthcare job and this is what they used.

G

JapanDave
Starting Member

10 Posts

Posted - 2012-07-04 : 09:11:43

I would have to agree with you there. But , I am new to SQL Server and to Windows Form interface. I am looking for a place to start, tutorials,web sites, links etc to get started on building this. Thanks for the reply.

Grifter
Constraint Violating Yak Guru

274 Posts

Posted - 2012-07-04 : 11:38:47

You can reference a connection in VB then start building data from that:

Dim cnn As New ADODB.Connection
Dim strConnect As String, strSQL As String
strConnect = "Provider=SQLOLEDB;Data Source=ST01;Initial Catalog=MyDatabase;User Id=myuserid;Password=mypass;"
cnn.Open strConnect
'SELECT
cnn.Close

Hope that gives you a few ideas to start

G

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-07-04 : 17:32:12

quote:
Originally posted by JapanDave

I would have to agree with you there. But , I am new to SQL Server and to Windows Form interface. I am looking for a place to start, tutorials,web sites, links etc to get started on building this. Thanks for the reply.

you can use any of application languages for your front end like VB,.NET,Java etc. Or even Access forms is ok if front end you're building is light weight. then use db connections to connect to sql database.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

JapanDave
Starting Member

10 Posts

Posted - 2012-07-04 : 18:17:07

quote:
Originally posted by Grifter

You can reference a connection in VB then start building data from that:

Dim cnn As New ADODB.Connection
Dim strConnect As String, strSQL As String
strConnect = "Provider=SQLOLEDB;Data Source=ST01;Initial Catalog=MyDatabase;User Id=myuserid;Password=mypass;"
cnn.Open strConnect
'SELECT
cnn.Close

Hope that gives you a few ideas to start

G

That is a relief, I can understand this. The problem I am encountering is the user interface. Although I have used Access quite a lot and would be the easiest to get a user interface set up and connected, I feel that it may not be quite enough for what I am thinking of doing.

Although I am pretty well versed in VBA, I have not done anything in VB. Of coarse I am willing learn.

Is there a template tutorial for other user interfaces like there is for access with the northwind tutorial?
[url]http://office.microsoft.com/en-us/templates/desktop-northwind-2007-sample-database-TC001228997.aspx[/url]

Thanks for everyone's help. I feel like I did when I first started in VBA, overwhelmed.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources