Cannot Create A Datasource Items

I'm trying to use WSS3 & RS 2005 as Integration Mode.
But i cannot create a data source item on sharepoint site library.

If i go to Central Administration > Configure Reporting Services Integration,

I can see the settings, thats mean that the Report Server is available ( i think so )
And also i can create dataources on Central Administration Web site (//servername:12500)

But from my production server web site ( //servername/ ), i cannot create those items.

I received the message

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.



Can somebody help me to fix that strange behavior.

Thanks.

View Replies


ADVERTISEMENT

SQL Datasource And SelectParameters ALL Items

Hi , I am trying to write a report generator by simply using a form and then a gridview that query's the database based on what the user selects on the form.  Anyways, I update the SQL parameters similar to below code.  I just want to know how i can tell the parameter to get ALL values from the parameter instead of a specific value. For example if the user wanted to see ALL the records for CustomerName what would i set the parameter default value to?  I tried the asterisk but that did not work.  Please guide me....Thanks!  MattSqlDataSource1.SelectParameters["CustomerName"].DefaultValue = "some value";<asp:SqlDataSource ... >   <SelectParameters>      <asp:Parameter Name="CustomerName" />   </SelectParameters></asp:SqlDataSource>

View Replies View Related

How To Create A Datasource Which Is Not Shared

Is it possible to create a datasource, which is not at al shared via vs 2005

View Replies View Related

Cannot Create Connection To Datasource?

 

I've had this datasource set up for awhile now, and i had it runing off of my login and password (with the selection "Credentials stored securely in the report server" selected). and the check box for  "Impersonate the authenticated user after a connection has been made to the data source" checked. But recently my password expired for my domain account, and i changed it, and now, it is not accepting either my old or new password. What is going wrong?
 
Here is the error messege:
 

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'Reporting_FSSRC'. (rsErrorOpeningConnection)


Login failed for user 'TZaccheus'.

View Replies View Related

Cannot Create A Connection To The Datasource 'DataSource1'

Hello, I Created a report with reportbuilder, after clicking on Run Report I got this message,  Its very strange it seems that its trying to generate or create a datasource.

 

Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos
----------------------------
No se puede crear una conexión al origen de datos 'dataSource1'.
----------------------------
Error al procesar el informe.

 

 

View Replies View Related

Create A Table Of Contents Based On Report Items From A List Control

What are the options to create a table of contents based on the report items in a List Control?  Document Mapping works for online viewing.  A table of content would make the report easier to read when it's printed.

 Any help is much appreciated.  Thanks.

View Replies View Related

Unable To Create Datasource In VB 2005 Express

mike writes "Hi
Brand new at SQL and am using VB 2005 express edition with MS SQL 2005 ver 9.00.1116 on windows XP home

Following instructions in the MS free video tutorials lesson 8/9 I created my first database then tried to create a datasource and dataset. The "dataset" appears to create ok but I then get an error message "Could not get type information for ...(mydatabase name) dataset"

I have searched forum and help for some indication why this happens but no luck. Hopefully you maybe able to help.I hope so.Databases are my interest but not skil;led enough to work without an IDE.

Thanks
mike"

View Replies View Related

How To Create Cascading Parameters In A Report With Cube As Datasource

 

I'm trying to create report with datasource as a cube. I'm able to connect to datasource to pull data with a single parameter. But, I'm unable to succeed in creating a cascading parameter.
The following scenario:
 I have a dimension "Period" as Paremeter.
The Period dimension is cascaded to year- quarter- month.
So, I would like to create a cascading parameter for period as year - quarter - month.
 
Please let me know, how to acheive this.
 
thanks,
Naveen.

View Replies View Related

Missing Permission To Create Datasource, New Folder, Add Security..etc

I have windows 2003 reporting services 2005 that has been working fine.  Now all of a sudden when I go to http://localhost/reports I am unable to assign security to folders(the link is hidden) the New data source button is hidden, the new folder button is hidden, upload folder and report builder are also hidden.  I am logged in as aministrator.

 

 

Also when I connect to reporting services through SQL Mgmt Studio I have the same issue, there are no options for permissions only a general option.

 

I'm sure it's a permissions issue but what do i do to resolve?

 

Thx

View Replies View Related

Batch Script To Create ODBC And Update Registry Datasource Key - Help!

 

I have create a batch file, that creates an ODBC then updates the application datasource key in the registry to the new system dsn name.
 
The problem is that the new DSN doesn't work when i try and connect the application...but if i had manually created the odbc source the app connects as expected... i have checked the registry and there is no difference between the two dsns created...but the application throws IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified after i have also changed the applications registry key to point to the new database.
 
Now the interesting things to note are that when i re-create the odbc to the old server and database (sql 2000) by batch file it works fine. The new ODBC is linking to a sql 2005 database, but it is still using the 2000 drivers and when i manually created it, it worked also.
 
Another interesting thing is that if i go into the odbc dsn and click configure, go through and test the connection it works fine... after i close this i then retry the application and it opens correctly...
 
I need this to be automated with no manual intervention, as this will be added to a large group of users login scripts!
 
Any help greatly appreciated.
 
My batch file code is as below:
 
ODBCCONF.exe CONFIGSYSDSN "SQL Server" "DSN=RMS Live 2005 | SERVER=d-db99sql2005| Trusted_Connection=Yes | Database=RMS-Livedb"

View Replies View Related

How To Create A Datasource Which Connection Type Is SQL Server Anlysis Service In Rss Script?

I am making a rss script to deploy the reports and datasources.

View Replies View Related

Trouble Using ADOX To Create Linked Tables In Jet Database From An ODBC Datasource

Hai,

I am using ADOX to create linked tables in a jet database from an ODBC datasource.
The tables in the ODBC data source does not have a primary key.
so I am only able to create read only linked tables.But I want to update the records also.
I tried adding a primary key column to the linked table while creating the link.
but I am getting an error while adding the table to the catalog.

The error message is "Invalid Argument".

I use the following code for creating the linked table

Sub CreateLinkedTable(ByVal strTargetDB As String, ByVal strProviderString As String, ByVal strSourceTbl As String, ByVal strLinkTblName As String)

            Dim catDB As ADOX.Catalog
            Dim tblLink As ADOX._Table

            Dim ADOConnection As New ADODB.Connection

            ADOConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strTargetDB & ";User Id=admin;Password=;")

            catDB = New ADOX.Catalog

            catDB.ActiveConnection = ADOConnection

            tblLink = New ADOX.Table

            With tblLink

                ' Name the new Table and set its ParentCatalog property
                ' to the open Catalog to allow access to the Properties
                ' collection.
                .Name = strLinkTblName
                .ParentCatalog = catDB

                ' Set the properties to create the link.
                Dim adoxPro As ADOX.Property

                adoxPro = .Properties("Jet OLEDB:Create Link")
                adoxPro.Value = True

                adoxPro = .Properties("Jet OLEDB:Link Provider String")
                adoxPro.Value = strProviderString

                adoxPro = .Properties("Jet OLEDB:Remote Table Name")
                adoxPro.Value = strSourceTbl


            End With

           'Adding primary key,
           '***** the source column name is "Code" ******
            tblLink.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "Code")

            'Append the table to the Tables collection.
            '******The exception occurs on the following line***********
            catDB.Tables.Append(tblLink)

            'Append the primary index to table.
            catDB = Nothing

        End Sub

If  I avoid the line for adding the primary key,everything works fine,but the table ctreated is readonly.

Thanks in advance
Sudeep T S

View Replies View Related

2005 Reporting Service - Cannot Create Connection To Oracle Datasource On Web Server

created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project  - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)

any thoughts or direction greatly appreciated

View Replies View Related

How To Use A Stored Procedure With Parameters To Create The Datasource View For Report Model Builder

I have a stored procedure that takes a date range and returns all the sales in that date range. I'm trying to create the report model for ad-hoc reporting. When I go to create the dataset view, it only lets me select tables or views.... how do I get around this?

View Replies View Related

Turning Off Impersonation On A SQL Server Datasource, Connecting To Datasource Using Reporting Services Credentials

 

Dear SQL Server Reporting Services Support Guru,
 
How do we configure Reporting Services such that when it attempts to connect to a datasource (e.g. Microsoft SQL Server datasource), it connects as the service account under which it is running as opposed to the calling user?
 
From our research we were thinking we could try one of two things: 
 

1) change the credential type on the datasource itself so that it does not use Windows Integrated Security and instead connects as itself or
 
2) change the <identity impersonate="true"> flag in the web.config of the ReportServer web service to false.
 
A high level description of our architecture is that we have a client application with an web browser control that displays a report in the ReportViewer web control on the server.  The report uses a SQL Server datasource to connect to our own SQL Server database hosted on the same server as Reporting Services but we want it to turn off impersonation and have Reporting Services connect as itself, not as the calling user.  We do not want to grant users in Production direct access to our SQL Server database; so instead we wanted to configure Reporting Services such that it resolves and connects to the datasource using its own credentials. 
 
A related question...when does the ReportServer web service get called?  For both retrieval of the .rdl files and connecting to the datasource for dataset retrieval?  What exactly does that <identity impersonate="true"> flag affect?
 
Any help you can provide would be very much appreciated.
 
Thanks much!
 
-canuck81

View Replies View Related

Use Sybase Odbc Datasource Or Oledb Datasource,run No Error,but 0 Row Data Output,why? Help Me!!!

use sybase odbc datasource or oledb datasource,run no error,but 0 row data output,why?  help me!!!

use sql server2005 ssis

 

 

 

View Replies View Related

DELETE Items Where Count(items) &>1

I cannot find an easy way to DELETE items which are > 1 time in my table (i am working with MS SQL 2000)


idserialisOk
-------------------
2AAA1
3BBB0
5dfds0
6CCC1
7fdfd 0
8AAA0
9CCC0


I want to DELETE each Row IN



SELECT doublons.serial, Count(doublons.serial) AS 2Times
FROM doublons
GROUP BY doublons.serial
HAVING Count(doublons.serial)>1



and WHERE isOK = 0

in my exemple , after deleting, my table must look like



idserialisOk
-------------------
8AAA1
9CCC1
3BBB0
5dfds0
7fdfd0



thank you for helping

View Replies View Related

Summing Invoice Items - The Multi-part Identifier &"items.TAX&" Could Not Be Bound

Hi: I'm try to create a stored procedure where I sum the amounts in an invoice and then store that summed amount in the Invoice record.  My attempts at this have been me with the error "The multi-part identifier "items.TAX" could not be bound"Any help at correcting my procedure would be greatly appreciate. Regards,Roger Swetnam  ALTER PROCEDURE [dbo].[UpdateInvoiceSummary]    @Invoice_ID intAS    DECLARE @Amount intBEGIN    SELECT     Invoice_ID, SUM(Rate * Quantity) AS Amount, SUM(PST) AS TAX    FROM         InvoiceItems AS items    GROUP BY Invoice_ID    HAVING      (Invoice_ID = @Invoice_ID)    Update Invoices SET Amount = items.Amount    WHERE Invoice_ID =@Invoice_IDEND

View Replies View Related

SSRS &&"cannot Create A Connection To Datasource&&" Error

Hai All..

I have develop any report in reporting services on server Development. i deploy my report to server production.
i have connection to cube as data source. if open report manager in server production and open the report, its succesfully. the report is open. but if i open report manager in server development show error



An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'PNL'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine
i use windows authentication in my pnl datasource.

thanks

Yudhi

View Replies View Related

I Have Same Datasource Name For All Sites, But Each Datasource Points To A Different DB

I have multiple reportprojects on server each report project belongs to a different client.

the problem i am having is i am using the same name datasource in all different projects but they all poitn to different databases on sql server.

when i am deploying the report project that time it is not uploading the datasource info, on the report server, since all datasources will bemaintained in the same folder on reportserver, thast why it seems it is not uploading the datasource info at all,  since it already found the same datasource name on reportserver.

I am maintaining the same datasource names thorugh put all report projects, is it possible to keep the datasource info in the project folder instead of datasource folder on reportserver.

 

Thank you all for the info.

View Replies View Related

Less Than 2 Items

t1
order
item


how can i get the order that has less than 2 items?

View Replies View Related

Counting Items

Hi,

I'm trying to include the COUNT(*) value of a sub-query in the results of a parent query. My SQL code is:

SELECT appt.ref, (Case When noteCount > 0 Then 1 Else 0 End) AS notes FROM touchAppointments appt, (SELECT COUNT(*) as noteCount FROM touchNotes WHERE appointment=touchAppointments.ref) note WHERE appt.practitioner=1

This comes up with an error basically saying that 'touchAppointments' isn't valid in the subquery. How can I get this statement to work and return the number of notes that relate to the relevant appointment?

Cheers.

View Replies View Related

What's A Best Way Of Tagging Items?

Hey everyone,

I'm working on a document management system that will allow the users to tag docs. Would it better in terms of performance and general maintenance to have all the tags comma de-limited in a column of the doc record, or have each tag in a row of an associated table?

Thanks in advance!

View Replies View Related

Items Not In Table

how to find  which items from a list (without using table ) are not in a specific table 
('443',
'470',
'878',
'567',
'430' 
)

 problem  is  the following  query  gives what is in the table

select distinct areacode
 from area_code
where areacode
in 
('443',
'470',
'878',
'567',
'430' 
)

tried using count to see  0 but only get 1 .... N

don't want to create a table everytime ...  for dynamic list

TIA

View Replies View Related

Getting Items That Were Ordered Alone

Hello Experts. You may have more luck at this than me.

 

I am interested in finding the quantity of items that were ordered alone. I have an orderid field and a product field. So the count of the orderid has to equal one and the have them grouped by product. 

 

Example of how data looks like

I am looking for transactions like orderid 3 and 5.







OrderID
Product

1
hotdog

1
burger

1
taco

2
burrito

2
snack

2
chips

3
burger

4
hotdog

4
burger

4
taco

5
burrito

6
snack

6
chips

 

When i run

 

SELECT product, count(orderid)

From Table

Where BusinessDateID = 20060725

group by product

having (count(orderid)=1)

 

I only get back items that were only sold once.

 

I am looking for a result that looks like this

 







Product
Ordered alone

hotdog
2

burger
3

taco
4

burrito
32

snack
12

chips
76

View Replies View Related

SQL: Get A Maximum Of Items From The Same User

 I want to select the latest photos that were posted on my site from my photos table:id name usercode  createdate1 holiday     5         1/1/20082 holiday2    5      1/1/20083 my car     5       1/1/20084 new home    7      1/1/20085 starry night 8      1/1/20086 me again     6    10/10/2007But in case one user has posted like 400 photos I dont want to show 400 photos of the same user as that would mess up latest photos. So I want to show the latest photos but always with a maximum of 3 for the same user...So in the above data example pictures with id 1,2,3,4,5 would be shownHow can I achieve this with SQL (and as always: without temp tables :))Thanks!

View Replies View Related

How Do I Add Items With Sql In A Specific Order

I need to create an ordered list of items using a select statement in a stored procedure. All itemsare obtained from a table but the first item in the list has a different value from the others.

View Replies View Related

Getting Months From Daily Items

I have a database with multiple items each day. I'm looking to extract monthly information from this data. So I'm thinking that I would like to have a drop down list with each available month in the list. How would I extract which months (for multiple years) have data from a datatype = smalldatetime?
I'm using c#
 Thanks!

View Replies View Related

Deleting Items In My Database

hi I Cant delete items in my grid view.. here is my code




















"
DeleteCommand="DELETE FROM [aspnet_Membership] WHERE [UserId = @UserId]" SelectCommand="SELECT First, Last, Email, CreateDate, IsApproved, IsLockedOut FROM aspnet_Membership">






when i run it.. and clicked the delete button.. this appears:

Server Error in '/mapuaResearch' Application.
--------------------------------------------------------------------------------

An expression of non-boolean type specified in a context where a condition is expected, near 'UserId = @UserId'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An expression of non-boolean type specified in a context where a condition is expected, near 'UserId = @UserId'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): An expression of non-boolean type specified in a context where a condition is expected, near 'UserId = @UserId'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3430
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +186
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1139
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +334
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +407
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +149
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +493
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDelete(IDictionary keys, IDictionary oldValues) +922
System.Web.UI.DataSourceView.Delete(IDictionary keys, IDictionary oldValues, DataSourceViewOperationCallback callback) +176
System.Web.UI.WebControls.GridView.HandleDelete(GridViewRow row, Int32 rowIndex) +914
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +1067
System.Web.UI.WebControls.GridView.RaisePostBackEvent(String eventArgument) +215
System.Web.UI.WebControls.GridView.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +244
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3839




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832


PLEASE HELP ME!!!!! TNX

View Replies View Related

Incorrect Syntax Near Items

Hi,I am getting a mysterious error message, and it doesnt say which line it referres to, just gives me a stack trace.Could somone decipher it for me?:System.Data.SqlClient.SqlException: Incorrect syntax near 'items'.  [SqlException (0x80131904): Incorrect syntax near 'items'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +180 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +68 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2411 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +190 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +380 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +115 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +395 System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary values) +405 System.Web.UI.WebControls.SqlDataSource.Insert() +13 detailproview.Button2_Command(Object sender, CommandEventArgs e) +41 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +75 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4886 My page code is:private bool ExecuteUpdate(int quantity){ SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"; con.Open(); SqlCommand command = new SqlCommand(); command.Connection = con; TextBox TextBox1 = (TextBox)FormView1.FindControl("TextBox1"); Label labname = (Label)FormView1.FindControl("Label3"); Label labid = (Label)FormView1.FindControl("Label13"); command.CommandText = "UPDATE Items SET Quantityavailable = @qty WHERE productID=@productID"; command.Parameters.Add("@qty", TextBox1.Text); command.Parameters.Add("@productID", labid.Text); command.ExecuteNonQuery(); con.Close(); return true;} private bool ExecuteInsert(String quantity) { SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"; con.Open(); SqlCommand command = new SqlCommand(); command.Connection = con; TextBox TextBox1 = (TextBox)FormView1.FindControl("TextBox1"); Label labname = (Label)FormView1.FindControl("Label3"); Label labid = (Label)FormView1.FindControl("Label13"); command.CommandText = "INSERT INTO Transactions (Usersname)VALUES (@User)"+ "INSERT INTO Transactions (Itemid)VALUES (@productID)"+ "INSERT INTO Transactions (itemname)VALUES (@Itemsname)"+ "INSERT INTO Transactions (Date)VALUES (+DateTime.Now.ToString() +)"+ "INSERT INTO Transactions (Qty)VALUES (@qty)"+ command.Parameters.Add("@User", System.Web.HttpContext.Current.User.Identity.Name); command.Parameters.Add("@Itemsname", labname.Text); command.Parameters.Add("@productID", labid.Text); command.Parameters.Add("@qty", TextBox1.Text); command.ExecuteNonQuery(); con.Close(); return true; }protected void Button2_Click(object sender, EventArgs e){ TextBox TextBox1 = FormView1.FindControl("TextBox1") as TextBox; ExecuteUpdate(Int32.Parse(TextBox1.Text) );}protected void Button2_Command(object sender, CommandEventArgs e) { if (e.CommandName == "Update") { SqlDataSource1.Insert(); } }}.  Thanks!Jon  

View Replies View Related

Copy Items From One SQL Database To Another...

...such as stored procedures, tables etc.

Initially this started as a case of "doh, I should just be using one database here, not two", and I was simply wanting to copy database tables. In VS2K5 I tried as there is a right click menu option of copy when a table is selected but this doesn't work for me with any database object of any kind. So fast forward to the present...I now am attempting to deploy an app to a hosting service, 1&1.com. I am allowed only one database in my current package, which should be fine for now. So I had to combine the ASPNETDB along with 2 other databases. It took a bit of time, but I got everything done, I thought, and posted to the servers. While debugging I get an error saying a stored procedure can not be found. And it indeed is not.This really confuses me as I made the changes in VS2k5, shut down and restarted to make sure I didn't miss anything, then used SQL Server Man. Studio to make a .bak file to upload to my hosting service. It never occurred to me to verify the changes I made in VS2k5 were actually on the database when viewed there. Well, they aren't, and I have no idea why. That would be issue #1 I suppose.So after giving the background info here, what I am looking for help with is how to get the changes I am making in VS2k5 to also be present when viewed from SQL Server Man. Studio as the only means of posting a db to my hosting provider is by using a .bak file.Also, why is it a project template I download has a .mdf file I am not able to even see in SQL Server Man. Studio? I guess if I had this answer the issue would be resolved.TIARegards,Joe 

View Replies View Related

SELECT Using All Items From List

I need to create a stored procedure that takes a list of product
numbers(541, 456, CE6050,...) and selects only the customers that have
all product numbers in the list. I have a product table that has the
following schema:

rowid numeric(18,0),productNumber numeric(5,0),customerNumber numeric(5,0)

and a customer table:

customerNumber numeric(5,0),address varchar(50),contact varchar(50)

So a customer can have more than one product, but I need a select
statement that takes the product numbers and selects them against the
product table and returns only the customerNumbers that have the entire
list of product numbers. I have tried doing a join on the product list and productNumber, then join with the customer table on customerNumber, but that gets any entires found in the list not the entries that have all the product numbers.  Thanks in advance for any help.

View Replies View Related

Enterprise Manager Over A VPN Gets 'No Items'

I have an environment that has 18 separate SQL server machines. Whenconnected to the LAN I can connect to each and expand the databases tab noproblem. When I try the same over a VPN I find that three of my servers willconnect but on expanding the databases I get a long pause then 'No items'.I've checked around and found some references to the same problem (SQLserver mag site) but no resolutions. I'm running XP pro and my SQL is sp3.The three servers in question have only TCP and named pipes in the net lib,they are all on Win2K one is on sp3, one on sp2 and one is 'out of the box'.The VPN has ports 1433 and 1434 udp and tcp allowed.Does anyone have any suggestions as to what is causing this, its got to besomething simple but I've been looking at this so long now I cant see thewood for the trees.Help appreciated.

View Replies View Related







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