SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Running
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kulfi
Starting Member

Saudi Arabia
33 Posts

Posted - 01/30/2011 :  23:39:29  Show Profile  Reply with Quote
Hi,
I am trying to connect the sql databse but can any one tell me that is it neccassary that the sql server should be installed on the same computer where the file is kept.
thanks

Edited by - kulfi on 01/31/2011 05:11:00

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/31/2011 :  05:21:35  Show Profile  Reply with Quote
Which file are you talking about? What are you trying to do?

- Lumbago

My blog-> www.thefirstsql.com
Go to Top of Page

kulfi
Starting Member

Saudi Arabia
33 Posts

Posted - 01/31/2011 :  08:00:30  Show Profile  Reply with Quote
Actually i am new to Visual Studio 2010 and SQL Server Please if my question is not clear i will try to make more clear

i have one file which is located at \\10.0.0.155\V-schedule\CAD_Data_Base.mdf and i want attach this databse to my vb.net program i have two questions here.
1. Is it necassary that where ever the file reside sql server has to be installed there.
2. i am trying to attach the datbase file but i get a message that it is located at UNC Share how can i clear this message and attach the file.
thanks


Edited by - kulfi on 01/31/2011 08:04:50
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/31/2011 :  08:18:09  Show Profile  Reply with Quote
I'm still confused. If you want to get data from a sql server you don't connect to a *file* but to a *server*. So when you connect you basically only specify the server name/ip, username and password... But you are also saying that you are trying to attach the file; isn't this file/database attached to a server already?

- Lumbago

My blog-> www.thefirstsql.com
Go to Top of Page

kulfi
Starting Member

Saudi Arabia
33 Posts

Posted - 01/31/2011 :  08:54:13  Show Profile  Reply with Quote
Hi, U mean that if i keep *.dbf file in the domain server , the SQL Server should be running or not as we know that for MS access we do not need access to be running on the same system where the file is kept.thanks

Edited by - kulfi on 02/01/2011 06:15:22
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 02/01/2011 :  09:32:42  Show Profile  Reply with Quote
SQL server is different than Access...with sql server the database in on the server, not the file. It's like getting a recipe from you mother ->

The Access way:
1. Go to her house (using the unc-path),
2. bring the cookbook home (copying the file)
3. read the recipe yourself

The SQL Server way:
1. Call her on the phone (using her ip address)
2. tell her that you are her son (give her your username/password)
3. ask her to tell you the recipe (write a select)
4. she will read it to you out loud (transfer the data)

- Lumbago
My blog-> www.thefirstsql.com
Go to Top of Page

kulfi
Starting Member

Saudi Arabia
33 Posts

Posted - 02/01/2011 :  23:43:42  Show Profile  Reply with Quote
Very Good Practical Answer Thanks a lot
ok now i want a advice we have 6000 Employees in our company and i am preparing the database for them and than ofcourse i will use it for a Vb.net Program, i am learner of SQL Server and i want a way where i can learn also and similarly work with this project.
Thanks

Ehsan
Go to Top of Page

Sachin.Nand
Flowing Fount of Yak Knowledge

2937 Posts

Posted - 02/02/2011 :  07:32:29  Show Profile  Reply with Quote
quote:
Originally posted by kulfi

Very Good Practical Answer Thanks a lot
ok now i want a advice we have 6000 Employees in our company and i am preparing the database for them and than ofcourse i will use it for a Vb.net Program, i am learner of SQL Server and i want a way where i can learn also and similarly work with this project.
Thanks

Ehsan



Wow...You are a learner of SQL Server and you have been assigned the task of designing a database for 6000 Employees.

I sincerely hope from my heart it is not a payroll system or something like that ...

PBUH

Go to Top of Page

kulfi
Starting Member

Saudi Arabia
33 Posts

Posted - 02/02/2011 :  08:56:07  Show Profile  Reply with Quote
Thanks I have already finished the program and it is about the Vacation Schedule of the Employees, today it is running with all the queries. thanks for that comments, also forget to advice me.
thanks

Ehsan

Edited by - kulfi on 02/02/2011 08:57:40
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 02/03/2011 :  05:07:54  Show Profile  Reply with Quote
quote:
Originally posted by kulfi

Thanks I have already finished the program and it is about the Vacation Schedule of the Employees, today it is running with all the queries. thanks for that comments, also forget to advice me.
thanks

Ehsan


Don't take things the wrong way, but from the questions you are asking about SQL Server, I seriously doubt that it is all working without a glitch. You came here asking for help and people have supplied that help.

From your original question, if you want my advice, I think you may need to at least read up on or take a beginners course in SQL Server.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000