sql server 2005

  1. E

    Question primary key, how to generate custom value

    hi there, i have a SQL SERVER 2008 table with 3 columns(P_ID(Primary key), PRODUCT_NAME, DESCRIPTION), now, how can i generate a custom and unique(ofcourse) value for my primary key, for example: sc00001 in the 1st row, and when i enter another data it will generate sc00002 something like that...
  2. E

    Question How to access my database even if im in another location

    hi, im currently developing a win. form apps. system using vb.net and SQL server 2005 as back end database, in our workplace, we have a computer domain(server) with group policy applied(all computers are joined to this domain including mine)., and were SQL server software is...
  3. A

    Question forms loop

    Hi, in my project I have 4 forms (connected to sql server 2005 database) in which I run heavy sql request so my program loses huge amounts of time when loading the forms especially since I made ​​a loop between the forms using timers. Private Sub Timer1_Tick(ByVal sender As System.Object...
  4. S

    Question Error upon filling dataAdapter (SQL2005)

    Hi all, I'm trying to fill a dataadapter from my sql2005 server. After filling i'm planning on generating a chart (VS2008) from the datarows. But upon filling the data adapter I'm getting: "A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll" in...
  5. L

    Cannot add new database connection....

    I have created a database in Microsoft SQL SERVER 2005 When I Start with my Microsoft Visual Basics 2008 Where I create a new project using Windows Form and after that Add Data Source -->Database-->New Connection I want to change my data source to Ms SQL SERVER 2005 but it is not showing in...
  6. L

    The cell is modified .The cell haas not been committed to the database(error in SQL)

    I have created a database in SQL server 2005 , after creating I went to tables and created new table. Then I right click on the table and open table to enter some values but I cannot enter any values in rows its it showing The cell is modified .The cell has not been committed to the database...
  7. ashahmy

    Question create a setup file (with sql server express 2005)

    Hi to all, I was created one of project using vb.net with sql server 2005. I want to create a setup file for that project. In my client pc contain sql server express 2005. how can I restore my database file to that sql server express 2005. it want to restore when the setup file was run. If any...
  8. A

    SQL Server, Password changing and Session timeouts

    First post on here, hello everyone; hopefully I am in the right place to find some help. I have an issue relating somewhat to sessions, password management and SQL Server database using a ASP.NET & VB.NET. The problem is as follows... I want to change my password to my SQL database...
  9. B

    Stored Procedure Problem

    First post here.. So here is the thing, I'm working on a school project which is a fleet-management system with GPS-devices. No problems so far, the GPS etc is working like a charm. I'm currently working on charts, to which i need to fill a xml file from a datatable. The chart I want to make...
  10. F

    Connection Pooling Issues

    Hello everyone, I have a data driven application in VB which works with an SQL Server 05 Database. Since this app makes use of many queries and commands, occasionally i'me getting a timeout error as the connection pool is full. So i figured that at a specifc point in time within the app, i'll...
  11. A

    Export Excel reports in Microsoft SQL Server 2000, 2005 & 2008

    What's new in this release? Aspose.Cells for Reporting Services is already providing comprehensive supports for SQL Server 2005 Reporting Services but this new version 1.4.0 enhances its features set and announces support for SQL Server 2000 and 2008 Reporting Services too. You can also...
Top Bottom