Click here to Skip to main content
11,921,491 members (62,134 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB SQL

I have an application created by VB 2010 Express and I need to store the data from vb application to my local database.

But I don't know how to create a local database in mssql server managament studio 2012.

How to let the vb application connect to local database?

Please help me. It's very emergency right NOW!!! Thank you for answering. ^^
Posted 1-Jan-13 23:35pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 2


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

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

Jacqueline Kuan 3-Jan-13 2:25am
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:29am
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.

Jacqueline Kuan 3-Jan-13 2:43am
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:47am
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:51am
the connection string for connecting the sql database is like this:
server=localhost; user id=root; password=; database=custinfo; ?
nehas1jan 3-Jan-13 2:53am
No if you are using on all PCs write the IP address there for datasource or server.
Jacqueline Kuan 3-Jan-13 3:11am
don't understand. Can give some examples? THANK YOU!!!
nehas1jan 3-Jan-13 3:15am
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:28am
the full ip or 192.168.1.%?
nehas1jan 3-Jan-13 3:29am
full ip without any symbol
Jacqueline Kuan 3-Jan-13 3:38am
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:34am
god,u r doing something wrong there in your code.
Jacqueline Kuan 3-Jan-13 4:40am
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;"
Rate this: bad
Please Sign up or sign in to vote.

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.
Jacqueline Kuan 2-Jan-13 4:47am
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.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 553
1 Dave Kreskowiak 245
2 phil.o 160
3 KrunalRohit 134
4 Sergey Alexandrovich Kryukov 132
0 OriginalGriff 6,951
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,171
3 George Jonsson 2,840
4 Suvendu Shekhar Giri 2,181

Advertise | Privacy | Mobile
Web03 | 2.8.151120.1 | Last Updated 3 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100