VB 2010 Express and mssql server managament studio 2012

Solution 2

Hi,

Please go through with the following video, This video walks you through how to create a database in SQL Server 2012

http://www.youtube.com/watch?v=WKWZZcrin5I

it ll help you if it helps you mark it as answer else let me know for the issues.

Thanks.

Permalink

Posted 2 Jan '13 - 19:59

nehas1jan2.2K

Comments

Jacqueline Kuan - 3 Jan '13 - 2:25

Thank you very much. It is a good tutorial. But I have some questions about database if I already created the database. And I want my application on different computers to access my local database through the application. Do you have any idea how to do it? I tried using Access connection but it failed. Thank you again!

nehas1jan - 3 Jan '13 - 2:29

ya sure there are many ways to do this like: 1.if you have intranet or if you are using local network then you can use it on other connected PCs also 2.If you have internet then you can uplod your database on internet 3.if you have not any connecting facilities then you can attach your database on each PCs. but as i consider you need to use intranet or internet. hope you are now clear if not let me know please. Thanks.

Jacqueline Kuan - 3 Jan '13 - 2:43

ya i understand now. but now is how to do it? i tried the online database already but i want to use in local network. I need to deal this with ip address, isn't? Thank you.

nehas1jan - 3 Jan '13 - 2:47

ok that's fine, You can do it by using connection string that you are using there in your application on other PCs. Note PCs need to be connect over LAN.

Jacqueline Kuan - 3 Jan '13 - 2:51

the connection string for connecting the sql database is like this: server=localhost; user id=root; password=; database=custinfo; ?

nehas1jan - 3 Jan '13 - 2:53

No if you are using on all PCs write the IP address there for datasource or server.

Jacqueline Kuan - 3 Jan '13 - 3:11

don't understand. Can give some examples? THANK YOU!!!

nehas1jan - 3 Jan '13 - 3:15

server=localhost; user id=root; password=; database=custinfo; write PC's ip address insted of localhost on which database has been created.

Jacqueline Kuan - 3 Jan '13 - 3:28

the full ip or 192.168.1.%?

nehas1jan - 3 Jan '13 - 3:29

full ip without any symbol

Jacqueline Kuan - 3 Jan '13 - 3:38

i put the ip already and run the app to retrieve data from the database (created by microsoft sql server management) but the data doesn't show out.

nehas1jan - 3 Jan '13 - 4:34

god,u r doing something wrong there in your code.

Jacqueline Kuan - 3 Jan '13 - 4:40

if i used access database? this connection string,ok? myConnection = New System.Data.OleDb.OleDbConnection() myConnection.ConnectionString = "Provider =Microsoft.ACE.OLEDB.12.0; Data Source =mysampledatabase.accdb; Persist Security Info =False;"

Solution 1

I'm sorry, that you're not competent for your job, is not an emergency at all, it's just sad. When you ask for free help because you can't do your own work, you don't have the right to give a time line.

You create a DB by right clicking and choosing 'New Database', from memory. You connect by writing a connection string and then the right code. If you don't know these things, I doubt you know how to write code to connect to a DB. You should stop now, and work through some books so you know how to do the task you've undertaken.

Permalink

Posted 1 Jan '13 - 22:40

Christian Graus604K

Comments

Jacqueline Kuan - 2 Jan '13 - 4:47

Sorry, sir/miss. I doesn't mean that but it's really emergency for me now. I know how to write the codes but not to create database. I know how to create database and using XAMPP but the database is only store in one pc and other pc cn't access to it via application.

0	Sergey Alexandrovich Kryukov	369
1	OriginalGriff	190
2	Tadit Dash	168
3	CPallini	163
4	Aarti Meswania	153

0	Sergey Alexandrovich Kryukov	10,169
1	OriginalGriff	7,749
2	CPallini	4,181
3	Rohan Leuva	3,482
4	Maciej Los	3,089

VB 2010 Express and mssql server managament studio 2012

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

		9,892,249 members (30,390 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Interested
Ignored

VB 2010 Express and mssql server managament studio 2012

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us