Showing posts with label databases. Show all posts
Showing posts with label databases. Show all posts

Wednesday, March 28, 2012

Need Help

I have inbuilt SQL server express database with VS 2005. I can able to create the databases but i don't know how to use those databases in my application.

That's a pretty big question without some context!

Let's start out with some basics:

SQL Express learning videos: http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx VS 2005 training for database usage: http://msdn.microsoft.com/vstudio/express/beginner/windows/tier3/

Need Help

I have inbuilt SQL server express database with VS 2005. I can able to create the databases but i don't know how to use those databases in my application.

That's a pretty big question without some context!

Let's start out with some basics:

SQL Express learning videos: http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx VS 2005 training for database usage: http://msdn.microsoft.com/vstudio/express/beginner/windows/tier3/

Monday, March 19, 2012

Need assistance restoring MS SQL 6.5 databases

We had a server running NT 4 and SQL 6.5, it was running an RMS database. We
attempted to move the databases to SQL 7.0 using the upgrade wizard and then
move them to SQL 2000 on another server. This all worked correctly, however
the client app that accesses the data cannot do so on the SQL 2000 box
(probably not compatible). So now we want to revert back to the old SQL 6.5
box however we can longer get SQL 6.5 to start, it is giving the error "
Cannot start SQL, cannot find the path specified'. Our next move was to build
a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
What we need is step by step instructions on how to accomplish this.
Alternatively, our first choice would be to restore the original server
however as stated we cannot get SQL 6.5 to start. Any assistance would be
appreciated
Hi,
With SQL 2000, set the database compatibility mode to SQL 6.5 and try your
application.
Execute the below command from query analyzer
sp_dbcmptlevel 'DBNAME',65
replace the dbname with actual.
If you still have issues then you can Install sql6.5 in Winnt and restore
from backup.
If you do not have backup then With DAT files you have use :-
Use the DISK REINIT and DISK REFIT commands.
Steps:-
1. Restart in Single-user mode
2. DISK REINIT and DISK REFIT against each device
3. Restart in normal mode
See books onlne for command syntax
Thanks
Hari
SQL Server MVP
"webby" <webby@.discussions.microsoft.com> wrote in message
news:6B14351A-B3E5-4130-8CBD-C16A5B80240A@.microsoft.com...
> We had a server running NT 4 and SQL 6.5, it was running an RMS database.
> We
> attempted to move the databases to SQL 7.0 using the upgrade wizard and
> then
> move them to SQL 2000 on another server. This all worked correctly,
> however
> the client app that accesses the data cannot do so on the SQL 2000 box
> (probably not compatible). So now we want to revert back to the old SQL
> 6.5
> box however we can longer get SQL 6.5 to start, it is giving the error "
> Cannot start SQL, cannot find the path specified'. Our next move was to
> build
> a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
> What we need is step by step instructions on how to accomplish this.
> Alternatively, our first choice would be to restore the original server
> however as stated we cannot get SQL 6.5 to start. Any assistance would be
> appreciated

Need assistance restoring MS SQL 6.5 databases

We had a server running NT 4 and SQL 6.5, it was running an RMS database. We
attempted to move the databases to SQL 7.0 using the upgrade wizard and then
move them to SQL 2000 on another server. This all worked correctly, however
the client app that accesses the data cannot do so on the SQL 2000 box
(probably not compatible). So now we want to revert back to the old SQL 6.5
box however we can longer get SQL 6.5 to start, it is giving the error "
Cannot start SQL, cannot find the path specified'. Our next move was to build
a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
What we need is step by step instructions on how to accomplish this.
Alternatively, our first choice would be to restore the original server
however as stated we cannot get SQL 6.5 to start. Any assistance would be
appreciated :)Hi,
With SQL 2000, set the database compatibility mode to SQL 6.5 and try your
application.
Execute the below command from query analyzer
sp_dbcmptlevel 'DBNAME',65
replace the dbname with actual.
If you still have issues then you can Install sql6.5 in Winnt and restore
from backup.
If you do not have backup then With DAT files you have use :-
Use the DISK REINIT and DISK REFIT commands.
Steps:-
1. Restart in Single-user mode
2. DISK REINIT and DISK REFIT against each device
3. Restart in normal mode
See books onlne for command syntax
Thanks
Hari
SQL Server MVP
"webby" <webby@.discussions.microsoft.com> wrote in message
news:6B14351A-B3E5-4130-8CBD-C16A5B80240A@.microsoft.com...
> We had a server running NT 4 and SQL 6.5, it was running an RMS database.
> We
> attempted to move the databases to SQL 7.0 using the upgrade wizard and
> then
> move them to SQL 2000 on another server. This all worked correctly,
> however
> the client app that accesses the data cannot do so on the SQL 2000 box
> (probably not compatible). So now we want to revert back to the old SQL
> 6.5
> box however we can longer get SQL 6.5 to start, it is giving the error "
> Cannot start SQL, cannot find the path specified'. Our next move was to
> build
> a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
> What we need is step by step instructions on how to accomplish this.
> Alternatively, our first choice would be to restore the original server
> however as stated we cannot get SQL 6.5 to start. Any assistance would be
> appreciated :)

Need assistance restoring MS SQL 6.5 databases

We had a server running NT 4 and SQL 6.5, it was running an RMS database. W
e
attempted to move the databases to SQL 7.0 using the upgrade wizard and then
move them to SQL 2000 on another server. This all worked correctly, however
the client app that accesses the data cannot do so on the SQL 2000 box
(probably not compatible). So now we want to revert back to the old SQL 6.5
box however we can longer get SQL 6.5 to start, it is giving the error "
Cannot start SQL, cannot find the path specified'. Our next move was to buil
d
a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
What we need is step by step instructions on how to accomplish this.
Alternatively, our first choice would be to restore the original server
however as stated we cannot get SQL 6.5 to start. Any assistance would be
appreciated Hi,
With SQL 2000, set the database compatibility mode to SQL 6.5 and try your
application.
Execute the below command from query analyzer
sp_dbcmptlevel 'DBNAME',65
replace the dbname with actual.
If you still have issues then you can Install sql6.5 in Winnt and restore
from backup.
If you do not have backup then With DAT files you have use :-
Use the DISK REINIT and DISK REFIT commands.
Steps:-
1. Restart in Single-user mode
2. DISK REINIT and DISK REFIT against each device
3. Restart in normal mode
See books onlne for command syntax
Thanks
Hari
SQL Server MVP
"webby" <webby@.discussions.microsoft.com> wrote in message
news:6B14351A-B3E5-4130-8CBD-C16A5B80240A@.microsoft.com...
> We had a server running NT 4 and SQL 6.5, it was running an RMS database.
> We
> attempted to move the databases to SQL 7.0 using the upgrade wizard and
> then
> move them to SQL 2000 on another server. This all worked correctly,
> however
> the client app that accesses the data cannot do so on the SQL 2000 box
> (probably not compatible). So now we want to revert back to the old SQL
> 6.5
> box however we can longer get SQL 6.5 to start, it is giving the error "
> Cannot start SQL, cannot find the path specified'. Our next move was to
> build
> a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
> What we need is step by step instructions on how to accomplish this.
> Alternatively, our first choice would be to restore the original server
> however as stated we cannot get SQL 6.5 to start. Any assistance would be
> appreciated

Need Article/Information - 2 databases 1 report

Hi All,

I need to find information on how to get two oracle databases data into one report. The two databases are not really a like, althought they do "talk" to each other and pass data to each other, and their tables are not the same. One is a manufacturing database, the other financial. If anyone can point me in the right direction, that would be great.

I am working with the newer 2005 products.

Thanks in advanced,

Kerrie

Kerrie,

i can't tell you how to collect data from Oracle, but i can tell you how to combine two streams of data. You need to create two reports - one being the main report, the other being a simple one, the simple one then serves as a sub report inside the main report. For instance, if you are showing the data in a table in the main report, then you can embed the subreport in a table cell, and pass values into it as parameters.

Or you can use the existing database link between the two databases (you said they are talking already), and just return all the data in one query. This will make the query slower, but the report will be way easier.

|||

Sluggy,

Thanks for the reply, Thats what I will do!

Thanks again,

Kerrie

Need an opinion: Access vs. SQL Server Express or another alternative?

I inherited this website from a previous developer that uses an Access DB as a backend. Ugh. Apparently, he was extremely limited in what databases he could use. The website is filled with problems related to connecting to this database, which is no surprise. Most of them are related to permissions to the database file, multiple user access, etc.

I am thinking about moving this to a SQL Server Express DB and upgrading the site to the 2.0 framework. Most of my experience is in SQL Server, but since they can't, or won't, pay for the SQL Server Database, is this a good solution? I've considered using MySQL as well, but their host won't provide support for this. Are there any other recommended alternatives?

I would go for SQL Express out of any of those alternatives... and I've done a lot of alternatives. SQL Express is actually very nice, and if you are already farmiliar with SQL Server, then a lot of the syntax will still make sense.

Actually,www.SingingEels.com was running on SQL Express for a while, but when I put it on my shared hosting environment, they have SQL Server 2005, and don't support SQL Express, so I moved it to that.

|||

I suggest that you move toSQL Server 2005 Express Edition which is completely free (though it has less features than the commercial full edition) and good to use for small-medium websites. It is a much better alternative than MS Access, besides its free for commercial use too.

Hope this helps,

Vivek

Monday, March 12, 2012

Need Advice on Really Big Databases

I have 2000 tables to put in databases. Should I put them all in one database with multiple schemas, or should I put them in multiple databases (one per schema)?

I'm concerned about these issues:

Size of files for system admin tasks

Efficiency (developer and run time)

Foreign keys and adhoc query tool accesstesting to see if this reply works

Friday, March 9, 2012

Need Advice (pulling my hair out)

I am the only DBA for a company of about 200 employees which makes about 100 million a year; I have 8 SQL servers some with over 70 databases on them that feed our web sites and educational web sites. I also have a few databases that are between 75 and 120 Gig that is for our circulation system. I am the Systems admin for all of the systems that run of my SQL server, so that makes our circ system, tradeshow system, accounting system, web sites there are about 90 of them or so. I also do programming for our IT department and some web site stuff as well as for our tradeshow dept. I am the answer man for our sales people and programmers, I also have the knowledge to build by own servers and run a network. So that’s over 200 databases plus all the other *** that I do. Oh and by the way I'm supposed to help out and cover for our Tec support guys, witch there are 2 of them by the way. I can never take any more than 3 days off at a time; I have a month’s vacation. I do all this for under $55,000 a year. I am never included in any decisions on software that runs on SQL nor am I consulted on any thing having to do with SQL. I work for a director who knows nothing about SQL server. There are 2 JR data guys and they do just data queries and deal with the day to day circ requests. These guys both have an office not to mention the tech guys have an office and guess what I am in a cube. I asked my boss for a laptop with a Verizon air card so when I’m not at work if something happens that needs my attention I do have to drive to work or go home and remote in, here is the best part he looked at me and asked if I was high. I am on call 24/7 365. I have over 10 years experience working with SQL. I’m I crazy for staying? I have been with this company for almost 8 years; I am the one who started them out on SQL server. I have converted every thing over to SQL 98.5% of all the company data I am in charge of. What would you do?

In a nutshell...

You're in a toxic environment that will not improve. You've heard of the saying "A prophet is never welcomed in his own home country", right? This applies to you in this situation because, in your own words, you have 10 years of experience but have been with the same company for 8 of those 10 years. You are at a stage in your current employment situation where you are being taken for granted. And the salary you mentioned...I'd have to know what area of the country you're working in to know what is reasonable, but $55k with 10 years of experience is damned-near insulting. To put it in perspective, I too have 10 years of experience. I have changed companies every 2-3 years and now earn more than twice the figure you quoted (in Austin, Texas).

Do yourself a favor: Go to http://www.careerbuilder.com and be prepared for an eye-opening experience. Upload your resume and be prepared to field a ton of phone calls. A person with 10 years of experience is always a hot catch for a company, and you can rest assured you'll find one that will make you happy.

To answer your final question: I would leave. Pure and simple.

|||

In the US, $50K is marginally entry level for DBA.

It is really time to do some 'soul-searching', and plan your future.

Just like employers conduct 'annual reviews', employees should also do their own 'annual review'. It may be the 'right' position for you, only you know all of the details.

|||Thanks for your response. I live in Phoenix Az and I found out that DBA's with my experience level range from 75 to 92 k a year. I am so outta here. Careerbuilder and monster have lots of possibilities.|||My employers annual review was poor. According to salary.com entry level DBA's range from 60k to 68,500. Needles to say I'm getting used and insulted. Just one other thing with my company for myself and my family to get med insurance with the company is 685.00 a month.

Saturday, February 25, 2012

Nebie connection problems with SQL Server 2005 Express and VS 2005

I downloaded SQL Server 2005 Express and some sample databases (incl. Adventureworks_data.mdf), but when I try to Add Connection in VS 2005 to point to this db and use the Test Connection button, it gives the error:


Microsoft Visual Studio

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I've tried setting the data source as either "Microsoft SQL Server Database File" or "Microsoft SQL Server", but get the same error.

Any tips on verifying SQL Srv Express is installed correctly? Any ideas on how to solve this problem?

Thanks in advance.

What happens if you set the source=(local)?