VB 2010 Express and mssql server managament studio 2012

Question

0.00/5 (No votes)

See more:

Hi!

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 22:35pm

Jacqueline Kuan

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

nehas1jan · Answer 1 · 2013-01-02T19:59:00

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.

Posted 2-Jan-13 19:59pm

nehas1jan

Comments

[no name] 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.

Thanks.

[no name] 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.

[no name] 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.

[no name] 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.

[no name] 3-Jan-13 3:28am

the full ip or 192.168.1.%?

nehas1jan 3-Jan-13 3:29am

full ip without any symbol

[no name] 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.

[no name] 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;"

Christian Graus · Answer 2 · 2013-01-01T22:40:00

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.