|
"We can't install lower version of SQL Instance, if we have higher version in it"
its not the case. We can still install lower version, yeah some unexpected problems might happen and sometimes , you have to break head with the nearest wall.
In my case, I installed SQL 2005 Express and then SQL 2000 Enterprise on my machine, When i tried running DotNetNuke there, it said "Failed to generate server instance of SQL Server" something like that.
Recommended: I think you better use only one , or if you want two, go from 2000 to 2005. Btw, 2007 is in line now
|
|
|
|
|
It shouldnt be a problem at all.
Keshav Kamat
India
|
|
|
|
|
hi
i'm trying to connect to the server without giving the static connection string.
i want my application to access the connection string automatically. i'm using the follwoing code, but it doesn't give the connection string
ConnectionString = @"";
conn = new OleDbConnection(ConnectionString);
cmd = conn.CreateCommand();
can u please explain that what am i missing, as i've already used the same code once and it is still working, but now that i am using the same code at some other location in the application it is not working.
thanku for the time
|
|
|
|
|
ConnectionString = ConfigurationManager.ConnectionStrings("YourConnectionString")
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
|
i have two table first table is "book " .that i keep book information in this and the next table is "Translater" that i store name,lname,id of translaters in it.
i want to create a query to see all information of all book with and without translater
such as:
--title -transName---transLastName
..... ...... .......
and if a book has not any translater fill that filed free in query
i use a table to join them to each other "BT"
that contain book.id and trans.id but when execute query i just see the book that have translater
and i can't see all book
how can i see all of my book?
sepel
|
|
|
|
|
Use a LEFT JOIN on the Book table.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
|
Hi:
We are combining alot of old applications which each have their own tables and structures within those tables...not really compatible enough to combine straight out...but they could all use the "text" or similar sql server type and be put into one or two "super" tables with a type to differentiate them.
On one side, this would vastly simplify our schema and allow the data to be centralized. On the other, its not intuitive and could be confusing if we fall behind with our database schema documentation. But more importantly, having all of these applications hitting these one or two tables puts a fair amount of stress on our server.
This table might look something like this:
Application 1 is type 1
Application 2 is type 2
Application n is type n
Text1--Text2--Text3...--Textn--Type
val1 val2 val3 valn 1
val1 val2 val3 valn 2
val1 val2 val3 valn n
Any thoughts of this issue would be appreciated.
Thanks!
|
|
|
|
|
A database should contain data that is related, assuming you are talking about a RDBMS. If the data is not related then putting it all together in a few master tables will be confusing years from now, or even tomorrow if there is enough of it.
You could use master DBs for things like zip code and other common fields but to try to mash everything together would be a big mistake IMHO.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Hi cleako:
This is a very valid point...and it will grow.
Thanks!
|
|
|
|
|
Ok, scrapping this idea and leaving original tables intact...this just ignor every accepted database design practice I have learned...chalk it up to a bad idea
|
|
|
|
|
Was this a boss' idea or yours?
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
the source will remain nameless to protect the innocent...but it wasn't me exactly...more like an interpretation of a conversation I had with him
|
|
|
|
|
Hi,
I have started preparing for SQL Server 2005 certification(Exam 70-431).
Can anyone guide me how to proceed or share his own experiance?
Your help in this regard will be highly appreciative.
Prasad
" Learn, grow, heal,and move forward "
|
|
|
|
|
whenever we connect to sql server it return timeout exception ErrNumber = -2
Query result return in query analyzer it takes 44 seconds and in ADO it returns Connection timeout
what we do?
First we create a datatset and then
create object of dataadaptor and call Fill method after 50 to 60 seconds it returns connection timeout
|
|
|
|
|
44 seconds is a fairly long time for even Query Analyzer. You can extend the DB connection time in the connection string, I think it defaults to 30 seconds.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
CleaKO wrote: I think it defaults to 30 seconds.
You are quite correct. The CommandTimeout defaults to 30 seconds.
|
|
|
|
|
Hi,Thanks
your code supported me very well and now it is successfully working.once again thanks
But i have one more question i have written a query which is of around 11 lines which extracts the record of the employees working for bank they are around more than 10000 employees,for this i have been using stored procedure.so please suggest me how to extract employee information with optimised time.please suggest me how to execute the long querys with out using stored procedures or ...................
|
|
|
|
|
Hi ..
how to find a record on a dataset ...
vb.net 2005
jooooo
|
|
|
|
|
int idx=0;
//this assumes that a DataSet already exists called ds
DataView dv = ds.Tables[idx].defaultView;
//this assumes that the column your are searching is the one
//specfied by the DataView.Sort see msdn2.microsoft.com/en-us/system.data.dataview.sort.aspx
int foundIdx = dv.find(yourSearchTerm);
sacha barber
|
|
|
|
|
i want code to let the user specify their ID and password anf verfiy passwords to enter the application
|
|
|
|
|
Mr.Kode wrote: i want code to let the user specify their ID and password anf verfiy passwords to enter the application
I'm not exactly sure what you are asking.
Are you asking for help with the data model such that you can store this information in the database?
Do you have a data model, but are unsure of how to query it?
Do you need help calling the query from your application?
Can you provide more information, please. It will help us answer your query accurately.
|
|
|
|
|
my application consist of multiple forms and i want to make the first form as log in form , all i want is to let the users assign their log in names and passwords and save these log in details on the log in table , as any application does ..
many thanks
|
|
|
|
|
give me triggers advantages...
|
|
|
|