Database

Create Database Ms SQl server

28-Jan-12 5:25

Simple; you ask the database-administrator. He'll know which database-application is installed. Each manufacturer has it's own implementation, and you can find examples for all major vendors on the internet.

Happy searching Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

Mangore7527-Jan-12 10:42

27-Jan-12 10:42

I'm using VB2008 I created a MsAccess 2003 database connection to my project,and make my project exe application. and put it with database Access in one folder and it worked well.
Now I 'm working on the Ms sql server database. I created a DataBase called MyDBs and made connection with it with Vb2008.
My question is can I create Ms Sql database(MyDBs) movable,attachement . means as I did with database access, by put it with application exe in same folder.
I hope I'm clear.

Eddy Vluggen27-Jan-12 23:51

27-Jan-12 23:51

Yes, by changing the connectionstring[^]. Look under the header "Attach a database file on connect to a local SQL Server Express instance". Your customers will still need to have Sql Server installed, regardless.

If your database is local to the app (say, in the same folder) then stick with Access, or go for SqlCe. If your database needs to support more than a single user, you use Sql Server - in a centralized place where everybody who needs to access the database, can access it.

Bastard Programmer from Hell Suspicious | :suss:

Mangore7528-Jan-12 3:25

28-Jan-12 3:25

I made this for dtatbase: Script database as - CREATE TO - File
and took the file Of DataBase(MyDBs) and put it in Debug folder in my project.
then I tried this way but didn't succed with me.

Dim MyConnection As SqlConnection = New SqlConnection("Data Source=.\SQLExpress; Integrated Security=true; AttachDbFilename=|DataDirectory|\MyDBs.sql;") 
Public Sub Load_DB()
        Dim sql As String = " Select Name,Tel,Addr from Table1 "
        Dim dp As New SqlDataAdapter(sql, MyConnection)

        Dim Table1 As New DataTable
        dp.Fill(Table1)
        Form1.DataGridView1.DataSource = Table1
    End Sub

jschell28-Jan-12 4:47

jschell

28-Jan-12 4:47

Mangore75 wrote:
then I tried this way but didn't succed with me.

HOW didn't is succeed? What EXACTLY happened so you know it didn't work?

Mangore7528-Jan-12 4:57

28-Jan-12 4:57

it showed me this error;
An attempt to attach an auto-named database for file C:\Users\Nader\Desktop\OOP- CreatProject\OOP- CreatProject\bin\Debug\MyDBs.sql failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

jschell28-Jan-12 13:58

jschell

28-Jan-12 13:58

Error seems to be specifically telling what the possible problems are.

Eddy Vluggen29-Jan-12 0:16

29-Jan-12 0:16

Only one instance with the name of the database is allowed on the server. Detach the database that's connected, or use an other name.

Bastard Programmer from Hell Suspicious | :suss:

Eddy Vluggen28-Jan-12 5:22

nRe: Create Database Ms SQl server

28-Jan-12 5:22

Why did you expect it too succeed? Smile | :)

Sql isn't the same beast as Access. You'll need to have a server installed, connect to that, and *hope* that you have sufficient rights to create a database on that server.

Is there a server installed? Can you connect to the master-database on "127.0.0.1\SqlExpress"?

Bastard Programmer from Hell Suspicious | :suss:

Mangore7528-Jan-12 5:35

Re: nRe: Create Database Ms SQl server

28-Jan-12 5:35

I ahve a server installed and it succedd with this conetion but the daabase doesn't in the folder debug. but I tried to use the same way as I did with access, by put the file i debug as I said in my first post.

Dim MyConnection As SqlConnection = New SqlConnection("Data Source=Name-PC\SQLEXPRESS;Integrated Security=true;Initial Catalog=MyDBs")

Eddy Vluggen28-Jan-12 5:46

Convert DTS Package to SSIS 2008

28-Jan-12 5:46

It's not Access - Sql databases aren't meant to be portable.

The user that the server is running under needs read/write access on that path. Your connection-string also doesn't mention which db-file to attach. I suggest you use the connection-string that I pointed to.

Bastard Programmer from Hell Suspicious | :suss:

vishnukamath27-Jan-12 1:34

vishnukamath

27-Jan-12 1:34

Hi All,

I want to convert DTS Packages to SSIS 2008.
Please suggest me better way to conversion.

Regards,
Vishnu.

Need suggestion for two database inconsistency

vanillaET26-Jan-12 18:29

vanillaET

26-Jan-12 18:29

I have a problem of inserting a record which includes data type conversion. There are two databases with the same data structure. One database is ok to insert that record, but another is not ok for data type conversion. I've checked all the data fields.Please give me any suggestion to solve it.

Jörgen Andersson26-Jan-12 20:23

Jörgen Andersson

26-Jan-12 20:23

What type is it you're trying to insert, and what type is the field?
What DB are you using?

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

vanillaET26-Jan-12 21:32

vanillaET

26-Jan-12 21:32

I'm using MSSQL2005. Inserting includes code such as 'X001' which is varchar and it needs to be incremented automatically. So that I converted varchar to numeric. It's ok for one database, but it's not ok for another one. I've checked all the data fields. It's all the same. Any solution for this?
Thanks a lot.

Jörgen Andersson26-Jan-12 22:33

Jörgen Andersson

26-Jan-12 22:33

Are both databases having the same globalization settings?

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

vanillaET27-Jan-12 0:14

vanillaET

27-Jan-12 0:14

Do u mean same database property? Actually, the database is restored but some changes had been made. But any changes had not been made to that data table which I'm trying to insert a record.
Thanks for your help..

Eddy Vluggen27-Jan-12 6:24