|
I'm researching the possibilities of embedding a DB inside a windows form application. I have done this before with a access DB, but not a MS sql db. I noted that this might be possible using ms sql express, but does this create a sql server instance on the client's pc? I just want to be able to install the app on a clients pc without undergoing a sql 2000/2005 server setup.
Is this possible, and how do i go about it?
Thanx ion advance.
Regards,
Tintin
|
|
|
|
|
Sql Server is called 'Server' for a reason
Sql Server Express is just a cut down version, it's still a server though and will install an instance of the server.
If you want a good free embeded databse take a look at SQLite[^]. It's very good although it has nowhere near the functionality of Sql Server.
If you can't do without the features Sql Server provides then you can always do a silent install of Express during your own applications setup. Theres plenty of commandline arguments you can pass to fully automate and customise the installation.
|
|
|
|
|
Thats what I thought, although @ microsoft express website they say:
SQL Server 2005 Express Edition is the next version of MSDE and is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005. Free to download, free to redistribute, free to embed, and easy for new developers to use immediately....
What do they then mean by embeddable?
Will look at Sqlite as well..
Regards,
Tintin
|
|
|
|
|
SQL Server databases are loaded by the SQL Server service. SQL Server Express Edition is no different - it creates an instance by default named SQLEXPRESS. With SQL Server 2005, you can specify a database file to attach in the connection string, so it isn't permanently associated with the SQL Server instance.
Microsoft have now ported SQL Server 2005 Mobile Edition back to the desktop properly and called it SQL Server Compact Edition 3.1. This is an in-process database engine like Access/Jet. Find out more here[^]. However, this does not use the same format data files as the other SQL Server editions. (It's really only branded 'SQL Server', it has nothing in common).
|
|
|
|
|
Hi,
I have to extract a blob field from a sql database.
please help.
Thanks
|
|
|
|
|
|
When I run my program,I get these errors and I don't know how to solve it:
1.A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
2.Cannot open database "NORTHWND.MDF" requested by the login. The login failed.
dataAdapter.Fill(dataset,"Customers"); This is where the exception is thrown
I use windows authentication and the owner of database is current user.
Can anyone please help?
|
|
|
|
|
Try enabling "Named Pipes" and restart SQL.
Regards,
Hulicat
|
|
|
|
|
I tried it but it didn't help.
|
|
|
|
|
For clarity you:
Opened the SQL Server Configuration Manager, expanded the Network configuration and enabled the Shared Memory and Named Pipes?
check if VIA is disabled.
The same needs to be done in Client configuration in client protocol section.
Regards,
Hulicat
|
|
|
|
|
Hi,
try to connect to SQL Authentification.
Can you show the connection string which you use to connect to sql server?
|
|
|
|
|
Hi,
When i set a primary key to a column in a table by default it would create a clustered index for that column.
The question is: Can i set primary key for the column with no index being created.
If yes how can this be achieved?
Gautham
|
|
|
|
|
Please read first what is indexing and
what is primary key
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
What do you want to know abt that?
I know what is a primary key and what does an index do in general
Gautham
|
|
|
|
|
gauthee wrote: Can i set primary key for the column with no index being created.
Then what is the meaning of this line?
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
That is a question iam asking!
Is it possible or not?
There are two questions infact:
1) Can a primary key be set for a column with index being set?
2) Can a primary key be set for a column with a non clustered index?
Hope you understood???
Gautham
|
|
|
|
|
Still you are not understanding what i am trying to tell.
No arguments please.
Kool.... think....ba ...bye
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
No, you can't. SQL Server uses the index to determine whether the key already exists. If it didn't have an index it would have to do a (slow) table scan, i.e. read all the records in the database.
You can create the primary key index non-clustered if you prefer.
|
|
|
|
|
Mike,
Thanks for the reply!
We cannot create primary key without indexes being added to the column now that is answered.
You said a non-clustered index with a primary key, how can it be done?
Gautham
|
|
|
|
|
Primary key with non clustered index ....
ALTER TABLE TableA ADD CONSTRAINT
PK_TableA PRIMARY KEY NONCLUSTERED (ColA)
Primary key with clustered index ....
ALTER TABLE TableA ADD CONSTRAINT
PK_TableA PRIMARY KEY CLUSTERED (ColA)
Regards
KP
|
|
|
|
|
I planned to have insert, update, delete actions in the same procedure by passing a flag. If i have the things like this will it lead to any performance or debug issues
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
I think No.
The name is Sandeep
|
|
|
|
|
I have one table in which the name field is a mandataory field and i can't keep this as null so that While deleting also i have to pass the value unnecessarily.
I got one more clarification, if i have assigning a default value then can i omit the value while passing it from the front end.
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
M. J. Jaya Chitra wrote: if i have assigning a default value then can i omit the value while passing it from the front end.
Yes.
Regards,
Satips.
|
|
|
|
|
Can't you just check the value of the parameter inside the Stored Proc? Just assign it a value if the Parameter is empty. Or you can even assign a default value for the Parameter inside the Proc. Anyway, if the default value is set, then there is no need of this checking.
The name is Sandeep
|
|
|
|