|
|
SQL Server 2000 Enterprise does not work on Windows XP* because it is a server product designed for use in large companies. It is designed to run on a Server therefore the installer will not permit you to install it on a non-server product.
*I modified this so the sentence would make sense as the OP decided to delete the original message and the context was lost as a result
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
-- modified at 10:04 Saturday 26th November, 2005
|
|
|
|
|
Given your previous question[^] I am now curious as to where you got Enterprise Edition from. If, only a few hours ago, you were desperate for a free version of SQL Server 2000 did you suddenly win the lottery in order to afford the several thousands of pounds/dollars that Enterprise Edition costs?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
nice ))).I have it from one years but the problem is because the comuter of witch i shoot install it has windows xp no some of server version so i can't use it.
-- modified at 7:57 Saturday 26th November, 2005
|
|
|
|
|
hi
clous you give me please url of link for downloading of ms sql server 2000 who is free i don't know the exacly additional name of that product.
thank you
|
|
|
|
|
|
But i need sql 2000 not 2005????
|
|
|
|
|
if i download this free version i will can to add my back up from sql2000
???
|
|
|
|
|
You can try it. I'm guessing that it will probably work, but will be a one way operation, i.e. you won't be able to backup the new database and install it on SQL Server 2000
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
thank you but probabry is not enought???
|
|
|
|
|
I think this just represents a different way of working. If I didn't find the documentation that said one way or the other what the situation was then I'd create a little prototype to see what would happen. In otherwords, I'd have downloaded SQL Server 2005 express and attempted to restore a SQL Server 2000 database to it to see if it would work or not.
I guess I take a more proactive approach to getting things done.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
papa1980 wrote: But i need sql 2000 not 2005????
Search for MSDE. The desktop-edition from SQL-Server 2000 is free, but has some restrictions.
'A programmer ist just a tool which converts caffeine into code'
|
|
|
|
|
Hello I want to insert record in access database using ado.net data adapter , not by command object. by suppling query at run time means Writing Query In a text Box .
Please suggest me.
Manoj
-- modified at 1:45 Saturday 26th November, 2005
|
|
|
|
|
tusar123 wrote: I want to insert record in access database using ado.net data adapter , not by command object.
You do know that the DataAdapter will have a property called InsertCommand that it uses to perform this query. This forms a paradox as it is exactly what you are trying to avoid.
tusar123 wrote: suppling query at run time means Writing Query In a text Box
So, you have a text box on your form. The user will be able to type a query into the text box directly say:
INSERT MyTable(KeyColumn, DataColumn1, DataColumn2) VALUES(1, 'abc', 'def') And then you want a data adapter to run this command?
Why? It would be much more efficient to use a OleDbCommand object instead. You are gaining exactly nothing from the overhead of the DataAdaptor in this instance.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
I'm trying to create a simple contact manager in Visual Studio 2005 in VB .NET. In VS 2003 you could connect to a database with just a filename, meaning the file will be in the same directory as the executable. VS 2005 doesn't seem to do this. Also, in VS 2003 you could add a connection and drag the tables you want and a connection and data adapters would be created and added to the form designer. VS 2005 doesn't seem to do this either. How would I add a connection to a form. I have a listbox that I could databind, but I would rather have "LastName, FirstName" as the format listed in the listbox. I know how to do that with a sorted list and loop through it and add the key to the listbox. But, if I can't get a connection and datadapter where I can access it in code, I can't do anything. I'm fairly ok programming in vb .net and completely new to VS 2005. Is it possible to do what I asked with Visual Studio 2005?
Thanks
|
|
|
|
|
There is a Database Explorer with VS 2005. Have you tried adding a database connection?
|
|
|
|
|
I added a connection using the tab above the toolbox tab to an Access database. But how do I actually add the connection to the form (or whatever else you do for Visual Studio 2005) to use it and create datasets and data adapters?
Thanks
|
|
|
|
|
I am using Visual C# 2005 Express Edition and there is a tab 'Database Explorer'. I right click on the Database Connections and choose Add Connection from the menu. From there, the wizard walks me through connecting to an Access database. I hope this sheds some light for you.
Paul
-- modified
As far as after connection is in place, you need to tie to a dataset, and data adapter. The data adapter connected to the connection and data set get filled by the data adapter.
|
|
|
|
|
Would like someone to assist me with sample codes used to open a file(a Picture in particular) from a drive in the computer so as to display it on an access form.
Thanks in advance.
ffffffffffffffffffff
|
|
|
|
|
Hello all,
Seeing as how I'm not exactly a SQL whiz, I periodically use built in templates to create tables, views, etc. in SQL code. Microsoft's latest iteration of SQL Server (2005) includes a large number of templates. Some of these templates are very unhelpful at best.
For instance, I'm trying to create a constraint between two tables. If I open up Microsoft's handy-dandy template, the code it spits out first tries to DROP the table that the constraint will be on (if the table exists). Obviously, this is not even a halfway useful solution.
I managed to retrieve the code for altering a table and adding a foreign key constraint, but I can't determine if the constraint exists to drop it. Does anyone have any ideas about this one?
Thanks,
Will
|
|
|
|
|
Hello everybody,
I have a little (for me big  ) problem.
I try to insert Data into Access with a DataTable, but everytime it throws an error when I update
System.Data.OleDb.OleDbException was unhandled
Message="Syntaxfehler in der INSERT INTO-Anweisung."
Source="Microsoft JET Database Engine"
ErrorCode=-2147217900
StackTrace:
at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
.....
[CSHARP]
public void InsertArtikelToInventur(string ean, long Menge, string lagerplatz, long Nr_Filiale)
{
string l_krit;
string sql = "";
l_krit = "Artikelnummer=\"" + ean + "\"";
object l_ret = dlookup("Nr", "Artikel", l_krit);
if (l_ret != null)
{
sql = "SELECT INVENTURSTAND.Nr_Artikel, INVENTURSTAND.Datum, INVENTURSTAND.Menge, INVENTURSTAND.aktuell, INVENTURSTAND.Alter, INVENTURSTAND.Nr, INVENTURSTAND.Lager, INVENTURSTAND.Lagerplatz, INVENTURSTAND.Nr_Adresse_Lager FROM INVENTURSTAND";
OleDbCommand myOleDbCommand = new OleDbCommand(sql, connection);
OleDbDataAdapter myOleDbDataAdapter = new OleDbDataAdapter(myOleDbCommand);
DataTable dt = new DataTable();
OleDbCommandBuilder myOleCB = new OleDbCommandBuilder(myOleDbDataAdapter);
// myOleDbDataAdapter.InsertCommand = myOleCB.GetInsertCommand();
myOleDbDataAdapter.Fill(dt);
DataRow dr = dt.NewRow();
dr["Nr_Artikel"] = (int)l_ret;
dr["Datum"] = DateTime.Now;
dr["Menge"] = Menge;
dt.Rows.Add(dr);
myOleDbDataAdapter.Update(dt);
}
}
[/CSHARP]
|
|
|
|
|
hello!
Perhaps you can try with a DataSet object...
VentoEngine corp.
Program your life ^^
|
|
|
|
|
hi ,
when i am trying to connect to a sql server database i'm getting this error:
The user instance login flag is not supported on this version of SQL Server. The connection will be closed.
Do anybody know the reason?
thanks
|
|
|
|
|
Hi there,
Which SQL's version you are using? is it 2005?
<< >>
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
