Database

Database

Hi,

I want some details on ENTERPRISE database:

1. How many people can work in this kind of database?

2. Does it use both LANs and WANs?

3. Is it only limited to a city or does it run all over the world?

4. How does it differ from PERSONAL database and GROUPWORK database systems?

5. Is it more efficient than other databases?

  • 879 views
  • 1 answers
  • 20 votes

I own a small business office and deal a lot with SQL servers and exchange servers. I get the following error when I try to use Microsoft Visual Studio 2005 Service Pack 1 design tools to open a database connection with Microsoft SQL Server 2008.

Microsoft Visual Studio

This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.

 

  • 1323 views
  • 1 answers
  • 0 votes

Hi there, I am a designer and I’d like to create a relational database which has a life cycle of many stages.  I understand that the life cycle of relational database is the cycle of changes and development.

Could anyone explain me that several stages of the life cycle so that I could design a good relational database which has some certain problems in that field.

  • 845 views
  • 2 answers
  • 21 votes

Hello to all dbms experts,

I have an issue regarding usage of Interbase. I got a complaint from one of our users that he got an error message, whenever two of them are accessing the same record stored in the database. See the full view of the error below.

There was an unexpected error in the property page:

The transfer syntax is not supported by the RPC server.

(0x800706C2)

Please close the property page and try again.

  • 1550 views
  • 1 answers
  • 1 votes

Hi,

I have faced a strange problem and I cannot solve it. I have an ASP.net application and I have made a setup of the Informix .NET provider.

– When I run my Application with F5 in debug mode, everything works fine, but the same application with the same unchanged mode and on the same machine does not work on IIS7.

– When I run it on IIS7, the connection to the database opens fine, and after executing the IFXDataReader I receive a null value, already the same code, same machine, and same databases! What is the reason behind this?

Thanks in advance.

  • 2238 views
  • 1 answers
  • 20 votes

Hello everybody,

I need your help. I have one table called big _strings, and I created it using the following code:

Create table big_strings (Field_name text)

Then I wrote the following SQL Query:

Select subset (field_name, 1, 3) from big_strings;

But I get an error:

Error: Blobs are not allowed in this expression

Is there another way to select one part of a string in text field?

Thanks.

  • 2664 views
  • 1 answers
  • 21 votes

I have Microsoft Visual Studio 2010 Ultimate installed on Windows Server 2008 (x86 & x64) with Service Pack 2, 1GB RAM, 30GB of HD space, DirectX 9 capable video card running at 1024 x 768 .

While I was trying to debug a stored procedure, I got the following error message

There is no source code available for the current location

I tried logging in as a Sysadmin but it comes up with the same error. I tried performing `Allow SQL/CLR debugging` and restarted MS visual studio but the error persists. Could not find much in the web and this error is quite annoying ….

  • 1736 views
  • 1 answers
  • 0 votes

I have SQL server 2005 installed on my Win XP SP 2 machine. When I try to do a modification on my DataBase, it throws up an error message.

“A bad Database error has occurred “in SQL server.

Upgraded my XP machine to latest SP 3, but the error does come back. It is a fresh installation of SQL and I do not have any previous version installed. Not sure if anyone can help me with this error.

  • 1181 views
  • 1 answers
  • 0 votes

Recently I purchased a new Dell Laptop pre-installed with Windows 7. After finding out that all editions of SQL Server 2005 SP3 and SQL Server 2008 SP1 are supported on Windows 7, I purchased SQL server 2005( SP3) and installed it on my laptop. When I try to open up Visual Studio 2008 and connect to SQL Server database, I get an error message:

Unable to add data connection.
Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

 

  • 1214 views
  • 2 answers
  • 2 votes

Hello,

I am using IDS 11.50.FC71E on RHEL 2.6.18. I have a 4GL function and it calls the C function using this code:
 
CALL c_func(x, y, z) WHERE x, y and z are the parameters.
 
But it gives a fault (core dump). If I do not pass the parameters, then the program is working fine. Even in HP UNIX, the program works fine even with arguments being passed. Only in RHEL am I facing this issue. Can you please let me know what can be the root cause of the problem and how to solve it?
 
Thanks in advance.

 

 

  • 1969 views
  • 2 answers
  • 20 votes

Latest Articles

Free cloud mining is coming! RICH Miner launches mobile mining, everyone can earn cryptocurrencies

RICH Miner officially launches a new mobile cloud mining application, subverting the traditional mining model! No need to buy mining machines, no technical experience required, just a mobile phone, global users can start the...

Rokid Max 2 Review: I Tried AR Glasses So I Could Watch Netflix in...

I’m not a tech geek. I don’t keep up with every new gadget launch. I fly a few times a year, watch many movies on my phone, and live in a small apartment where...

Top 10 Technology Trends For 2025

With 2025 just around the corner, it is time to start thinking about what tech trends will be coming our way. Tech moves at a rapid pace. Some things may pop up next year...

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...

10 Facts About The Dark Web

Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...

Top 10 Latest Steam Cleaner Machines

While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...

Latest Tips

Top 10 Internet Monitoring Software

Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...

Top 10 Best Partition Manager Software

A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software. 1....

Top 10 Best Online Music Production Software

Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...