Help Again Edit Parameters From MDB To ADP

Jan 31, 2006

I need to convert this from Jet SqL to SQL Server. Moving out of an MDB to an ADP some of the queries I need to change over, I inherited this database and the bosses want all databases moved over from MDB to ADP.


SELECT Format$([Main Table].Date,'mmmm yyyy') AS [Date By Month], [Main Table].[Action Type], Count([Main Table].[Action Type]) AS [CountOfAction Type]
FROM [Main Table]
GROUP BY Format$([Main Table].Date,'mmmm yyyy'), [Main Table].[Action Type]
HAVING (((Format$([Main Table].[Date],'mmmm yyyy'))=[Enter the Month and the Year]));

View 1 Replies


ADVERTISEMENT

Look Up Renewals Dates In An Edit Parameters Form

Dec 8, 2006

Hello Everyone and Merry Christmas

I have a question I need my users to be able to enter a between statement into an Edit Parameters form I have created for them. The reason being is so that they can find out when employees are due for a renewal (which is every two years from their final suit date..for example if their final was done on 12/01/2006 then they would be due to renew 12/31/2008).
The code below allows them to look up final suit dates of individuals. I would like them to look up Renewals based on final suits. like: BETWEEN 12/01/2006 AND 12/31/2006. and get the results, does that make sense???



SELECT TM#, LASTNAME, FIRSTNAME, CONDITIONAL, DATEOFCONDITIONAL, FINALSUITDONE
FROM dbo.EmployeeGamingLicense
WHERE (FINALSUITDONE = @Enter_FINALSUITDONE)

View 2 Replies View Related

ADO.NET 2-VB 2005 Express Form1:Printing Output Of Returned Data/Parameters From The Parameters Collection Of A Stored Procedure

Mar 12, 2008

Hi all,
From the "How to Call a Parameterized Stored Procedure by Using ADO.NET and Visual Basic.NET" in http://support.microsft.com/kb/308049, I copied the following code to a project "pubsTestProc1.vb" of my VB 2005 Express Windows Application:


Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlDbType

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim PubsConn As SqlConnection = New SqlConnection("Data Source=.SQLEXPRESS;integrated security=sspi;" & "initial Catalog=pubs;")

Dim testCMD As SqlCommand = New SqlCommand("TestProcedure", PubsConn)

testCMD.CommandType = CommandType.StoredProcedure

Dim RetValue As SqlParameter = testCMD.Parameters.Add("RetValue", SqlDbType.Int)

RetValue.Direction = ParameterDirection.ReturnValue

Dim auIDIN As SqlParameter = testCMD.Parameters.Add("@au_idIN", SqlDbType.VarChar, 11)

auIDIN.Direction = ParameterDirection.Input

Dim NumTitles As SqlParameter = testCMD.Parameters.Add("@numtitlesout", SqlDbType.Int)

NumTitles.Direction = ParameterDirection.Output

auIDIN.Value = "213-46-8915"

PubsConn.Open()

Dim myReader As SqlDataReader = testCMD.ExecuteReader()

Console.WriteLine("Book Titles for this Author:")

Do While myReader.Read

Console.WriteLine("{0}", myReader.GetString(2))

Loop

myReader.Close()

Console.WriteLine("Return Value: " & (RetValue.Value))

Console.WriteLine("Number of Records: " & (NumTitles.Value))

End Sub

End Class

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
The original article uses the code statements in pink for the Console Applcation of VB.NET. I do not know how to print out the output of ("Book Titles for this Author:"), ("{0}", myReader.GetString(2)), ("Return Value: " & (RetValue.Value)) and ("Number of Records: " & (NumTitles.Value)) in the Windows Application Form1 of my VB 2005 Express. Please help and advise.

Thanks in advance,
Scott Chang

View 29 Replies View Related

Run Report By Different Parameters Without Having To Enter Information For All Parameters At Same Time

Oct 29, 2013

I have a SSRS report with four parameters,and I want to be able to enter information for two of the parameters and run the report opposed to all four of them. However, when I select allow blanks and only select the parameters that I want to run the report by, the report come back blank..Essentially, I want to be able to the run report by different parameters without having to enter information for all parameters at the same time.

View 2 Replies View Related

Edit Sql

Dec 7, 2006

Edski writes "Help please,
below is my sql query, when I run it, I get the right result with one problem. I get same customers with same email many times. I would only like the same customer shown one time. Checking it by email.


SELECT od.pName, od.dIndx AS dindx, od.pIndx AS pindx, od.device AS device, c.Cust_Id AS cust_id,

c.First_Name AS First_name,

c.Last_Name AS last_name, c.Email AS Email, c.Phone AS phone,c.company, h.productCode AS

product_code, DATEDIFF(dd, GETDATE(), h.expirationDate)

AS Difference, h.hotSyncId AS regcode, od.autorenewal AS autorenewal, od.installment AS

installment

FROM Orders_Detail od INNER JOIN

Hot_Sync_ID h ON od.dIndx = h.dIndx INNER JOIN

Customers c ON c.Cust_Id = h.cust_id

WHERE (od.prenewal ='False') and (od.autorenewal = 'no') and (c.newsletter <> 0) AND

(DATEDIFF(dd, GETDATE(), h.expirationDate) = '27') AND (c.company <> 'University of Alberta')

ORDER BY difference, c.Last_Name, h.productCode"

View 2 Replies View Related

How Can I Edit An SQL Database?

Oct 9, 2004

Hello,

I have been working in ASP.Net web sites with Access database.

Now I want to create a web site using an MS SQL database.

What software or softwares can I use to create and edit MS SQL databases?

I am using Windows XP Professional SP2.

Thank You,
Miguel

View 5 Replies View Related

Pb To Edit A Recordset With VB In A DTS

Nov 24, 2001

Hello,

I have some problems to edit a recordset in an ActiveX DTS using Vbscript.
Here is an example of the script :

dim varsql, varset, varconn
set varconn = CreateObject("ADODB.Connection")
set varset = CreateObject("ADODB.Recordset")
varconn.Open = "Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=Enregistrement3;user id = 'sa';password=''"

varsql = "SELECT * "
varsql = varsql & "FROM mytable "
varset.Open varsql, varconn, 3,3

msgbox "How much : " & varset.recordcount

if varset.recordcount >0 then
do while varset.eof
varset.edit
.........................
varset.update
varset.movenext
loop
end if
varset.close
varconn.close

Does someone see what is wrong ?
I allways get -1 for the varset.recordcount ! (I checked there are some records into the table).
I don't think it is a problem of user's right as it works with the same user configuration using a SQL action requery.
If I modify the open statement like this :
varset.Open varsql, varconn, 1
varset.recordcount contains the good number of records but the recordset is read noly and can't be modified...

Any Help will be very wellcome !
TIA

View 1 Replies View Related

How To Edit A SQL DB Via MS Access?

Aug 23, 2000

This is a basic, remedial question, but I've no experience whatsoever with SQL server or Access (although I'm familiar with basic DB concepts). Even so, I have inherited this project because no one else will take it (besides, I like the challenge of learning something new :-). If I understand correctly, I can use Access 2000 to create and edit DBs on my SQL 7 server, and to run queries. This is done by creating a WBEM ODBC connector (I have no idea how this is done). I'm pretty good at figuring things out on my own, but I sure would appreciate being pointed in the right direction. What I'd like to know is first of all, am I on the right track, and secondly, what do you all recommend as a good source of info on this topic (the Microsoft web site, technet, manuals?).

All info is greatly appreciated.

thanx,
-scott

View 3 Replies View Related

Edit Web Assistant Job

Oct 25, 2005

Where do I go to modify the T-SQL statement I entered while creating a job with the web assistant wizard?

View 1 Replies View Related

Last Edit Time?

Jul 23, 2005

How can i mark a row with its last edit time?With access it was obvious, in sqlserver?

View 1 Replies View Related

Edit .mdf Database

Jul 23, 2005

Greetings,Are there any tools freely available to modify or edit a .mdf databasefile? As far as seeing the actual tables?Regards,cd

View 6 Replies View Related

Edit Distance

Mar 18, 2008

Hi,
please, it is possible to know the edit distance used in the fuzzy lookup/grouping.
On this forum I read fuzzy lookup use 4-gram with fix size.
Does exist any document explaining how fuzzy lookup calculate the similarity? In other word, what kind of edit distance, algorithm is used by fuzzy lookup/grouping?
I hope I was enough clear with my poor english.
Thanks All

View 1 Replies View Related

Cannot Edit Jobs

Sep 3, 2007



Two days back we have installed SP2 on SQLServer2005 Active/Active Cluster which result in failure.

Only Database Services and Analysis Services where not updated and rest of the services got updated.

After a restart , the behaviour of SQLServer is helarious.

We got into lot of problem so we opened support from Microsoft.

One of the problem i forgot to mentioed to Microsoft was on editing the Job i cannot see anything inside,all the entries where empty closing the job window and opening it again i got all my entries back but on editing i got the below mentioned Error.
Error:
Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error:c001f011(Microsoft.SqlServer.ManagedDTS)

If anyone faced the same problem and got any resolution please let me know.

Anyhelp will be appriciated.



View 2 Replies View Related

Many To Many Relationship - What's Best Way To Add/edit/delete

Aug 3, 2006

I have a many to many relationship I can design the table 2 ways:1) Category table (cat_id, cat_name, active) - cat_id as PKCategoryReq (cat_id, req_name) - cat_id & req_name as PK2)CategoryReq (req_name, cat_name) - req_name & cat_name as PKIf
I design 1st way. Then when they want to add and delete from the
CategoryRequest table, they would have to add to the category table
first. Then maybe build a list of checkboxes to select from. The one's
they check insert into the CategoryRequest table.Drawback of
this is that they can't edit the list on the fly. Since it may be used
by other request (since cat_id CategoryReq is fk into Category table)If I design it the 2nd way. Then they can edit, delete, add on the fly. But there won't be a master category list.Which way is better?

View 1 Replies View Related

How To Edit Stored Procedures ?

Apr 27, 2007

I have two questions:
 
1) Is it possible to rename a SQL table –or- copy the content of a table into a new table ?
 
2) How to replace the renamed or replaced table name inside the code of Stored Procedures that references it ?

View 2 Replies View Related

Edit SQL Identity Seed

Jan 9, 2004

Because of testing and deletion, my table of user groups starts at 15 or so. Now I want to insert a group for administrators but I would like to have the groupID be 1. I tried to turn off the identity seed property and insert it manually but that didn't work.

Is there any way to do this?

Thanks, Dave

View 3 Replies View Related

Sql MSDE Table Edit

Oct 23, 2004

I have a table with data in it. Now I want to change the Data Type from int to varchar. Is there anyway to do this because I don't want to delete all the data and re-enter it. That seems to be the only way I can see to change the data type. I would appreciate some help. thanks.

View 10 Replies View Related

Edit Function In DetailsView

May 1, 2006

Hello
Am developing a web site using ASP.net 2.0. I have page to manage the employees information in term of viewing, inserting and updating. The problem is that the updating part doesn't work and it didn't give me any error messages.
My code is as following:
<%@ Page Language="VB" AutoEventWireup="false"%>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<script runat="server" >
   
    Protected Sub DetailsView1_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewInsertedEventArgs)
   
        If (Not e.Exception Is Nothing) Then
 
            ErrorMessageLabel.Text = "An error occured while entering this record.  Please verify you have entered data in the correct format."
            e.ExceptionHandled = True
        End If
        GridView1.DataBind()
    End Sub
 
    Protected Sub DetailsView1_ItemUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewUpdatedEventArgs)
   
        GridView1.DataBind()
    End Sub
 
    Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
    
        DetailsView1.ChangeMode(DetailsViewMode.ReadOnly)
    End Sub
 
    Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
   
        DetailsView1.ChangeMode(DetailsViewMode.ReadOnly)
    End Sub
 
    Protected Sub GridView1_PageIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
   
        DetailsView1.ChangeMode(DetailsViewMode.ReadOnly)
    End Sub
 
    Protected Sub GridView1_Sorted(ByVal sender As Object, ByVal e As System.EventArgs)
        DetailsView1.ChangeMode(DetailsViewMode.ReadOnly)
    End Sub
   
</script>
<body dir="rtl">
    <form id="form1" runat="server">
        <br />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:warehouse DBConnectionString2 %>"
            ProviderName="<%$ ConnectionStrings:warehouse DBConnectionString2.ProviderName %>"
            SelectCommand="SELECT DISTINCT [dep_Code], [dep_Name], [BRN_Code] FROM [Departments]"></asp:SqlDataSource>
       
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:warehouse DBConnectionString2 %>"
            ProviderName="<%$ ConnectionStrings:warehouse DBConnectionString2.ProviderName %>"
            SelectCommand="SELECT DISTINCT [ID], [Name],[Position], [DEPT_Code] FROM [Employees]
            where [DEPT_Code]=@dep_Name">
        <SelectParameters>
        <asp:ControlParameter ControlID="DropDownList1" Name="dep_Name" Type="Int32" />
        </SelectParameters>
        </asp:SqlDataSource>
       
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:warehouse DBConnectionString2 %>"
            ProviderName="<%$ ConnectionStrings:warehouse DBConnectionString2.ProviderName %>"
            SelectCommand="SELECT DISTINCT [ID], [Authentication], [Name], [Password], [Position], [DEPT_Code], [Contact] FROM [Employees]
            where [ID]=@ID "
           
            UpdateCommand="UPDATE [Employees]
                           SET
                           [ID] = @ID,
                             [Authentication]=@Authentication,
                             [Name]=@Name,
                             [Password]=@Password,
                           [Position]=@Position,
                             [DEPT_Code]=@DEPT_Code,
                             [Contact]=@Contact
                           WHERE [ID] = @ID  "
                           
            InsertCommand="INSERT INTO [Employees]
                   ([ID], [Authentication], [Name], [Password], [Position], [DEPT_Code], [Contact])
            Values (@ID, @Authentication, @Name, @Password, @Position, @DEPT_Code, @Contact) "
            >
        <SelectParameters>
        <asp:ControlParameter ControlID="GridView1" Name="ID" Type="Int32"  PropertyName="SelectedValue" />
        </SelectParameters>
       
        <UpdateParameters>
        <asp:Parameter Name="ID" Type="Int32" />
        <asp:Parameter Name="Authentication" Type="Int16" />
        <asp:Parameter Name="Name" Type="String" />
        <asp:Parameter Name="Password" Type="String" />
        <asp:Parameter Name="Position" Type="String" />
        <asp:Parameter Name="DEPT_Code" Type="Int32" />
        <asp:Parameter Name="Contact" Type="String" />
        </UpdateParameters>
       
        <InsertParameters>
        <asp:Parameter Name="ID" Type="Int32" />
        <asp:Parameter Name="Authentication" Type="Int16" />
        <asp:Parameter Name="Name" Type="String" />
        <asp:Parameter Name="Password" Type="String" />
        <asp:Parameter Name="Position" Type="String" />
        <asp:Parameter Name="DEPT_Code" Type="Int32" />
        <asp:Parameter Name="Contact" Type="String" />
        </InsertParameters>
        </asp:SqlDataSource>
        &nbsp;
        <br />
        <br />
        أختر القسم :&nbsp;
        <asp:DropDownList ID="DropDownList1" DataSourceID="SqlDataSource1" AutoPostBack="True"
      DataTextField="dep_Name" runat="server" DataValueField="dep_Code" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" >
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList>
        <table >
            <tr>
                <td style="width: 100px">
                </td>
                <td style="width: 100px">
                </td>
            </tr>
            <tr>
                <td style="width: 100px; height: 154px" valign="top">
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
                        DataSourceID="SqlDataSource2" AllowPaging="True" AllowSorting="True" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnPageIndexChanged="GridView1_PageIndexChanged">
                        <Columns>
                            <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
                           
                            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                            <asp:BoundField DataField="Position" HeaderText="Position" SortExpression="Position" />
                            <asp:BoundField DataField="DEPT_Code" HeaderText="DEPT_Code" SortExpression="DEPT_Code" Visible="False" />
                           
                            <asp:CommandField ShowSelectButton="True" />
                        </Columns>
                    </asp:GridView>
                </td>
                <td style="width: 100px; height: 154px" valign="top">
                    <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="ID" OnItemUpdated="DetailsView1_ItemUpdated"
                        DataSourceID="SqlDataSource3" Height="50px" Width="125px" AllowPaging="True" OnItemInserted="DetailsView1_ItemInserted">
                        <Fields>
                            <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
                            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                            <asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />
                            <asp:BoundField DataField="Position" HeaderText="Position" SortExpression="Position" />
                            <asp:BoundField DataField="Contact" HeaderText="Contact" SortExpression="Contact" />
                            <asp:TemplateField HeaderText="Department" SortExpression="DEPT_Code" >
                                <ItemTemplate>
                                    <asp:Label ID="Label1" runat="server" Text='<%#Eval("DEPT_Code") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource1"
                                    DataTextField="dep_Name" DataValueField="dep_Code" SelectedValue='<%# Bind("DEPT_Code") %>'>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                <asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="SqlDataSource1"
                                DataTextField="dep_Name" DataValueField="dep_Code" SelectedValue='<%# Bind("DEPT_Code") %>'>
                                </asp:DropDownList>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Authentication" SortExpression="Authentication">
                            <ItemTemplate>
                                <asp:Label ID="Label2" runat="server" Text='<%#Eval("Authentication") %>'></asp:Label>
                            </ItemTemplate>
                            <EditItemTemplate>
                                <asp:DropDownList ID="DropDownList4" runat="server" SelectedValue='<%# Bind("Authentication") %>'>
                                <asp:ListItem Text="Admin_User" Value="1" />
                                <asp:ListItem Text="Super_User" Value="2" />
                                <asp:ListItem Text="Normal_User" Value="3" />
                                </asp:DropDownList>
                            </EditItemTemplate>
                            <InsertItemTemplate>
                            <asp:DropDownList ID="DropDownList5" runat="server" SelectedValue='<%# Bind("Authentication") %>'>
                                <asp:ListItem Text="Admin_User" Value="1" />
                                <asp:ListItem Text="Super_User" Value="2" />
                                <asp:ListItem Text="Normal_User" Value="3" />
                                </asp:DropDownList>
                            </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:CommandField ShowInsertButton="True" />
                            <asp:CommandField ShowEditButton="True" />
                        </Fields>
                    </asp:DetailsView>
                </td>
            </tr>
        </table>
      
       <asp:Label ID="ErrorMessageLabel" EnableViewState="false" runat="server" />
    </form>
</body>
</html>
  

View 4 Replies View Related

Cannot Edit My Dts Package (Urgent Please)

Mar 11, 2002

HI,
I created a dts package using my Windows NT authentication. One of my colleague edited that package last week and when I tried to open it now, it gives me an error message "The system cannot find the file specified". The package still has my NT id as the owner. Could anyone please let me know why is this happening ???
My colleague is still able to edit my package. My NT id and my colleague NT id both are setup as administrators on the sql server. Any help is greatly appreciated.

Thanks
Ramesh

View 1 Replies View Related

Edit/Update Problem

Aug 12, 1999

I'm working in Visual Basic 6 using SQL Server 6.5 connecting through a DSN (using ODBC)

I have a query "object.OpenRecordset("SELECT * FROM table", dbOpenDynamic, 0, dbOptimistic" returning a recordset. I loop through the recordset, edit a char field for each record and update it.

The first update works fine but the second update (and then on) fails returning an error message ODBC call failed and I also get an error S1106.

I ran the code in debugger mode and noticed that as soon as it updates the first record, the pointer seems to move to the next record before even doing the "MoveNext" (based on the field contents), but the AbsolutePosition remains fixed until MoveNext is executed. At that point, if I do a "MovePrevious", the record is not there anymore and has totally
disappeared from the recordset. What is happening and how do I get around that????

View 1 Replies View Related

How Can I Edit Sysdevices Table?

Jul 21, 1999

I read on this forum that it is possible to move a device by:

Update the sysdevices table to point to the new location (ex: D:SQLTESTDB.DAT)
Stop the SQL Server
Physically move the file to the new location
Restart the SQL Server.

How can I update sysdevices table?

View 1 Replies View Related

Cannot Edit SQLServer Using MS ACCESS

Mar 31, 1999

We are using MS Access as a front end to a SQL Server 6.5
Database using ODBC & linking tables in Access.


We are unable to edit certain records using access. We
get the following error message:

"This record has been changed by another user since you started
editing it. If you save the record, you will overwrite the changes
the other user made.

Copying the changes to the clipboard will let you look at the values
the other user entered, and then paste your changes back in if you
decide to make changes."

What the message says is untrue in our case. Worse, there is
no way to recover and have the desired change posted. This error
occurs only with certain records. This error occurs when there are
no locks active (and only 1 client logged in).

I am inclined to think that this error may be the fault of ODBC.

Updating the same change directly into ISQL works fine. SQL Server Permissions
have beeen checked & double checked.

If you have suggestions as to how this error can be rectified, please contact
me:
Mark Blackburn
mark@mbari.org
http://www.mbari.org/~mark

View 3 Replies View Related

Can't Edit Table Designer

Dec 5, 2005

Hi. I am not sure why, but i can't change any of the values in my Table Designer. I want to change my primary key's "IsIdentity" value to "yes" and the Identity Increment to "1" but everything is greyed out and nothing is editable. Please help! I am not in debug/run mode when i am editing these values. I have a feeling that I am going to feel stupid when somebody points out what i am (not) doing. So, any takers?

View 7 Replies View Related

Please Help ! - Can't Edit Any Data In Any Table !?

Apr 26, 2005

Hi guys,

I'm having a bit of a nightmare with MS SQL Server 2000 Enterprise Manager(running on XP Pro SP2).

Basically I've been running it on my laptop and my desktop with no problems for months and suddenly I can't seem to edit any data in any table?

Basically I'm using Enterprise manager to connect the database which is hosted externally by Fasthosts. I've called them and explain the problem, they told me to increase my Query Timeout to 300 seconds, which I have done but still no joy.

I can open and query tables but when i simply open a table and return all rows, even the smallest of tables (i.e. just 2 rows) as soon as I try and edit even just a field containing a bit of data is just hangs for about a minute until I get the following error;

[Microsoft][ODBC SQL Server Driver]Communication link failure

I've again called Fasthosts who assure me that it was working at their end etc and that was about all they could do !! very helpful...

Anyways, does anyone have any ideas ? As I really need to edit some data in the tables for a deadline and this is extremely frustating as it was working just a few days before. I've tried removing SQL server and re-installing but I'm still getting the same problem.

Any help/ideas would be massively appreciated !!

Many thanks


Jon

View 4 Replies View Related

Edit Live Sql Data?

Mar 31, 2006

I have a sql express database with a couple tables of information. I have a user modifying one of these tables with a data access page using Office Web Controls.

To backtrack a bit, the sql db used to be an access db. The same user modifying the data the same way. I also had a asp page making odbc calls to the access db to lookup information. But if the data access page was open, the odbc page would error. So i moved the data to sql.

Now, I'm getting ready to setup an application to make odbc calls to the sql db. I still want the user to modify the data using the DAP. Should I allow the user to modify the live data used for the app or should I make a copy of the data everytime its updated?

View 2 Replies View Related

Trigger View/Edit

May 21, 2008

Hi all!

How do u view the triggers in sql 2000 qry analyzer. I know you can use sp_helptrigger-- which will give the list of triggers-- -- But, I need to be able to run command from qry analyze and see the script used to create triggers
Having limited access to the design tables-- wont be able to see trigger from sql design table


Thank you


Josephine

View 2 Replies View Related

Edit View In SSMS

May 22, 2014

I have several views in a database that I need to edit in SSMS 2008.

If I right click on a view, I can select "Design" and do the changes and save. Everything saves ok.

However, I cannot enter comments that way. I have tried View Script As -> ALTER To -> New Query Editor Window but this method creates a new view e.g. SQLQuery1 i.e. I can't save the origial view name.

Is there a way to alter views in code and save them back into the database under their original view name?

View 3 Replies View Related

How To Edit Query For Bonus

Jan 23, 2015

When I am run this query the bonus is wrong. how to edit it and make it work ?

SELECT salesman_code,user_group,user_name,trx_acc_amt,trx_date,trx_no,sh_code,salesman_code4,salesman_code5,salesman_code6,
Sum(case when salesman_code4 is null then 0 else 1 end +
case when salesman_code5 is null then 0 else 1 end +
case when salesman_code6 is null then 0 else 1 end) as total_counter,

[code]....

View 2 Replies View Related

Edit Foreign Key Relationships

Feb 5, 2007

Hi,

I'm using SQL Server 2005 Management Studio. I've created several Foreign Key Relationships using Database Diagrams. Now I'm trying to edit the constraints on the relationships, but when I right click on the relationship, the only option available is "Delete Relationships from Database". But I am not able to edit the relationship. Does anyone know how to do this?

Thanks for the help.

View 1 Replies View Related

Edit Scheduled Job RESOLVED

Jun 6, 2007

Sorry if this sounds dumb but I can't find the answer . I have created a scheduled job on my test database using the wizard. How do I edit it or delete it ? Step by step instructions please

I have never done this before so am just experimenting at the moment.

View 1 Replies View Related

How Can I Edit A SSIS Package

Feb 20, 2008

OK, I've figured out how to create and schedule my packages.
now I want to go back in and redefine some of the options.
How can I get at it so i can edit it.

thanks
ICW

View 6 Replies View Related

Cannot Edit Text Cell

Jul 23, 2005

I am trying to edit a long text cell in Enterprise Manager but when I select"<long text>" and try to delete it, I get an error saying "cannot edit thiscell".Could anyone tell me how to edit this cell?Thanks, Amanda

View 2 Replies View Related

Edit Sdf Database On Desktop From Pda

Mar 27, 2008

Hi, I would create a vb2005 application that allow me to edit a sdf database stored into a pda connected at pc with activesyn directly on my desktop as well as "SQLCE Database View".
How can i do it??


Please help me

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved