Why cannot create a Table??

  • Thread starter Thread starter Giuseppe Pezzella
  • Start date Start date
G

Giuseppe Pezzella

Dear friends
After have succesfully create a new account on MSDE using a stored
procedure, I have create a new database:
Dim sql As String = "CREATE DATABASE " & NomeDB & " ON PRIMARY (name=test,
filename = '" & Percorso & "\" & NomeDB & ".mdf')"

Dim ConnessioneDiCreazione As String = "Integrated Security=SSPI; Data
Source=Home\VSdotNET; User ID=mylogin; Password=mypassword;"

When I have try to create a new table with this command:

Dim sql As String = "CREATE TABLE Tabella1 " + "(" + "campo1 int," + "campo2
text" + ")"

Dim ConnessioneDiLavoro As String = "Integrated Security=SSPI;" + "Data
Source=Home\VSdotNET;" + "Initial Catalog=rose.mdf;" + "User ID=mylogin;" +
"Password=mypassword;"

a message box say me that I cannot open a database account rose.mdf

Access denide to Home\Giuseppe where Giuseppe is a my windows account!!!

Questions:

1)If I can create a database rose.mdf by mylogin and mypassword

why cannot reopen it for create a new table??

2)Why messagebox mentioned my windows account

3)Why I must include name=something in a create database string

4)WHERE I CAN FOUND A GOOD TUTORIAL FOR LEARN MSDE OR SQL SERVER??
 
Remove the .mdf from your connection string. You are specifing the file and
not the database.
 
Back
Top