SQL Communicating With Progress
May 15, 2008
Our ERP uses a Progress db but several of our web apps are developed in vb.Net and use a SQL backend. I need to pull some data in from Progress using TSQL queries.
Experimenting a little I find that a simple query, i.e. from 1 Progress table, takes anywhere from 20 seconds to a couple of minutes. However, when I joined on a 2nd table, I had to cancel the query after it ran for over 10 minutes.
SQL server is connected to Progress via a Linked server.
Any advice on improving the query will be appreciated.
I believe the query has to be in the T-SQL syntax; is that right? Where does the translation into Progress syntax occur?
Thank you,
LadyReader
View 7 Replies
ADVERTISEMENT
Sep 4, 2001
Hi, I am fairly new to MS SQL and have it running on SP1. When I try to run SP3, I get an error that the account (SA) cannot be authenticated. I went into the SQL Enterprise Manager-Security-Logins and changed the SA account password to what we have it documented as, but still cannot be authenticated.
The reason I am attempting to run SP3 is that our Arcserve Backup Agent running on the SQL server will not allow me to attach to it. We have a different server that we backup to and I had it working fine, but then updated our accounting package and now SQL will not allow me to authenticate to it. The accounting package is working fine, but backups are not. The accounting application support has no clue.
Is there a way to test that I have communication with the SQL?
Thanks.
View 1 Replies
View Related
Mar 22, 2006
In a proposed architecture, a production SQL Server will live in the DMZ, and an additional internal Production server will reside on the internal network. If Port 1433 is opened on the firewall and access to the DMZ SQL is restricted to only the internal SQL server, is this secure?
I've been told two stories:
1) That if port 1433 is opened, that a hacker can enter the DMZ and then browse ANY SQL Server on the internal network, not just the internal SQL server mentioned in the proposed architecture above.
2) If you define a rule on the firewall and you use a trusted connection, then ONLY those two SQL servers can communicate with each other and that it is secure.
Which is true? Are there other methods necessary to allow secure access between the LAN and the DMZ when two SQL servers need to talk with each other? Is allowing this kind of direct SQL communication considered to be bad practice?
Thanks, in advance, for the assistance.
View 4 Replies
View Related
Nov 21, 2006
Hello,
I am writting two applications that talk to each other. I create a service and then a dialog that points to Client2Service which means it is talking to it self. When I do that it works because I get pack the string "client1" which I am forcing it to send if it is calling ServiceProc in client1. I cahnge the Client2Service to Client1Service and it does not work any more. I do not understand why but am guessing it has something to do with the way I have the database setup. The installation script is bellow. Please share your thoughts because I am running out of ideas.
USE master;
GO
CREATE DATABASE ssb_FloorSystem;
GO
USE ssb_FloorSystem;
GO
CREATE MESSAGE TYPE Request VALIDATION = None;
CREATE MESSAGE TYPE Response VALIDATION = None;
GO
CREATE CONTRACT MessageTalk(
Request SENT BY INITIATOR,
Response SENT BY TARGET
);
GO
-- Install assemblies
BEGIN TRY
CREATE ASSEMBLY BrokerLibraryAssembly
FROM 'c:ServiceBrokerClient1Client1inDebugServiceBrokerInterface.dll'
END TRY
BEGIN CATCH
-- Catch and handle exception
END CATCH;
GO
BEGIN TRY
CREATE ASSEMBLY SqlClient1BrokerServiceAssembly
FROM 'c:ServiceBrokerClient1Client1inDebugSqlClient1BrokerService.dll'
END TRY
BEGIN CATCH
-- Catch and handle exception
END CATCH;
GO
BEGIN TRY
CREATE ASSEMBLY SqlClient2BrokerServiceAssembly
FROM 'c:ServiceBrokerClient2Client2inDebugSqlClient2BrokerService.dll'
END TRY
BEGIN CATCH
-- Catch and handle exception
END CATCH;
GO
CREATE PROCEDURE Client1ServiceProc
AS
EXTERNAL NAME SqlClient1BrokerServiceAssembly.[SqlBrokerServiceNS.SqlBrokerService].ServiceProc
GO
CREATE PROCEDURE Client2ServiceProc
AS
EXTERNAL NAME SqlClient2BrokerServiceAssembly.[SqlBrokerServiceNS.SqlBrokerService].ServiceProc
GO
CREATE QUEUE Client1ServiceQueue
WITH
STATUS = ON,
RETENTION = ON,
ACTIVATION (
STATUS = ON,
PROCEDURE_NAME = Client2ServiceProc,
MAX_QUEUE_READERS = 4,
EXECUTE AS SELf
)
ON [default];
GO
CREATE QUEUE Client2ServiceQueue
WITH
STATUS = ON,
RETENTION = ON,
ACTIVATION (
STATUS = ON,
PROCEDURE_NAME = Client1ServiceProc,
MAX_QUEUE_READERS = 4,
EXECUTE AS SELf
)
ON [default];
GO
CREATE QUEUE [dbo].[ClientQueue] WITH STATUS = ON;
GO
CREATE SERVICE Client1Service ON QUEUE Client1ServiceQueue (
MessageTalk,
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho]
);
GO
CREATE SERVICE Client2Service ON QUEUE Client2ServiceQueue (
MessageTalk,
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho]
);
GO
CREATE SERVICE HelloWorldClient ON QUEUE ClientQueue (
MessageTalk,
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho]
);
GO
EXEC sp_configure 'clr enabled', 1
GO
RECONFIGURE WITH OVERRIDE
GO
USE master;
GO
Thanks,
Scott Allison...
View 3 Replies
View Related
Oct 7, 2005
I have a problem.
View 7 Replies
View Related
Jun 14, 2007
I have SQL Server 2005 express installed on my machine, and I was wondering if there is any way to have an asp.net 2.0 web service hosted by a different company be able to send sql commands to the sql server on my machine.
View 3 Replies
View Related
Jun 29, 2007
Hi there,
I have a flat file source in my data flow that is suppose to feed through a couple of columns to a script component. All of the columns have data but when I debug in my script component (with the aid of messageboxes) I can see that one of then is empty.
This is wrong because when I preview that data in the flat file source, I can see that the columns are all populated.
Has anyone ever encountered that a flat file source doesn't communicate with a script component properly? I mean it does pass through the data of all other columns except for one.
I have replaced the components in case it had become corrupt and I even rebuild the package but the problem still persists.
Any advice would be welcome
Regards
Mike
View 11 Replies
View Related
May 25, 2006
I have some SP's I run once a month and each SP takes a few mins to run and when I batch em together in one shot, I hate sitting there waiting for them to finish
whats the easiest way to report back the status of the exec?
Ex:
Set NoCount ON
EXEC StatesUpdateZipTableUpdate 'AE'
EXEC StatesUpdateZipTableUpdate 'AK'
EXEC StatesUpdateZipTableUpdate 'AL'
EXEC StatesUpdateZipTableUpdate 'AP'
EXEC StatesUpdateZipTableUpdate 'AR'
EXEC StatesUpdateZipTableUpdate 'AZ'
How would I get it to report the results after each Exec?
In otherwords Id like to create a progress bar......
Just for Query Analyzer..... no bells and whistles
View 5 Replies
View Related
Nov 22, 2002
I need to logg progress of a DTS job. How do I do that? I'd like the progress to be stored in a file and emailed to me.
I need to track progress of the transfer of each table in two databases.
View 2 Replies
View Related
Aug 5, 1998
I am having a problem backing up a customer database to tape.
The progress bar just sits there with no movement. I have even left it running overnight and nothing the next day
I am able to backup all other databases (master, msdb, model).
Any help would be appreciated.
Thank you,
joseph gerardi
View 1 Replies
View Related
May 30, 2008
Hello, we started a restore of a database that is just over 1.2 TB. It took 23 hours to complete the Copy Data Phase. Now, SQL Server continues to show the database in a Restoring state, however, there is no other indication of what SQL Server is doing. We do not have any way to see in which phase of the restore process SQL Server is in or how much time may be remaining. We do know that SQL Server is doing something because of the I/O activity. Its there a command, script, or other tool that we can use to determine where in the Restore process we are and how much time may be remaining? We did not use the WITH STATS = switch so that is out, and the sys.dm_exec_requests shows Percent_Complete is 100, however, we know that its not done, the Data Copy Phase has completed but the Severe is still churning.
Thanks, Clay
View 4 Replies
View Related
Jul 5, 2006
How Can connect tha Progress Databases in DTS?
View 3 Replies
View Related
Dec 10, 2007
Using Reporting Services when I go against an SQL database I use @Company.
when I go against an Oracle database I use :Company.
What do you use when you go against a Progress database?
View 1 Replies
View Related
Mar 24, 2006
is there a way to capture what gets written to the progress tab to a table, or is it overwritten on each execution as xml somewhere so it can be saved kind of like an odometer? the mission is to be able to audit the results of a load, or even if it doesnt turn out to be a load, then document the run.
similarly, is there a way to watch what executes to see what actually runs during a merge join transform, iow, something that exposes ssis to trace? how do i find it?
thanks
drew
View 2 Replies
View Related
Sep 5, 2007
Does anyone knows how to retrieve execution progress from ssis package, that was
executed programatically.
What I am trying to do, is to launch ssis package on server
and send the progress ("percent complete") to some remote client in order to display it
in progress bar.
I want that ,while ssis package executes, it will raise some event every time the progress changes.
View 4 Replies
View Related
Oct 17, 2007
When running large Store Procedures that take several hours, does SQL 05 have a way of monitoring the progress by telling you what it has actually completed so far rather than having to wait till the query has finished to find out.
View 11 Replies
View Related
May 29, 2007
Hi guys, I am using ASP.NET 2.0, In one web page i am loading a data from VIEW,This view takes more time to execute and this this data is i am showing in grid on page load event.and the web page only displayes after the view execute until it remains on old page User fills there is no response. I want to show the progress in status bar,Can any one tell me how can i do this. Thanks in advance
View 1 Replies
View Related
Jun 14, 2004
I have a script file which do the replication and in the script there is a lot of table need to be addad as article.
So while use osql execute the script there would be cost a lot of time. What I want to do is show a dialog which could show the progress percent and the file name which is now being addad as article.
hwo can i use Transact-SQL to do this?
Thanks a lot
View 4 Replies
View Related
Feb 16, 1999
Has anyone heard of/know of a SQL server Dump/Load progress indicator?
Thanks!
-Chris
View 2 Replies
View Related
Jan 20, 2004
Does anybody have information on co-existence of SQL Server and Progress on the same machine? Are they happy to live together, or should they be given separate homes?
I would like to cut down on server proliferation, if possible, and have a server "beefy" enough to handle both, but is it a wise thing to do?
View 1 Replies
View Related
Jun 16, 2008
I have 2 questions,
1. I am trying to create an index, which is running for a long time. Is there an option to know the progress so far or how much more time it is going to take?
2. Is there anyway to find out how much space is required to rebuild an index?
------------------------
I think, therefore I am - Rene Descartes
View 2 Replies
View Related
Jun 26, 2006
I'm trying to pull data from about 30 progress databases using DTS andscheduling the jobs to run monthly. I'd like to pull data betweenspecific dates, but for some reason, I can't figure out how to filterthe data on the progress side.I want to run a query that will pull all data fromprior-month/8/current-yearandcurrent-month/15/current-yearI'll also have to account for when it's january, make it december ofthe year before.Any ideas?thanks,M@
View 1 Replies
View Related
Jul 20, 2005
I'm doing a big old join on one table with 10,000,000 rows, andanother with400,000 rows. As you can imagine, this is taking a long time.Is there any way to monitor the progress of the join after executingthe sql statement (more specifically, from code)?(Oh, and any good practices for speeding up this join would beappreciated, too).Thanks,Andrew
View 3 Replies
View Related
Sep 2, 2006
The ETL processing for my project will be deployed as part of a larger application which is operated by non-technical users. Therefore I want to provide real-time feedback to the user on progress, errors, etc., using windows standard GUI interface objects and style- for example a progress bar. The "designer" of course does some of this but there won't be any designer in our deployed application (and SSIS designer is neither intended to be used by, nor appropriate for, non-technical users anyway).
Now that I have the ETL logic working, it's time to tackle this UI requirement. I am thinking one way to do this is to start a script task to run in parallel with the main ETL processing, open a winform in that task that has various GUI objects whose "state" is based on package scoped variables, update the package level variables via the "on progress" event (or other events as needed) of various SSIS tasks and components, and refresh the winform's display regularly via a timer event.
Does this approach seem like it would be effective? Has anyone tried maintaining an open winform via a script task and updating it's objects via package variables in parrallel with the package is running other tasks?
Thanks,
Ken
View 2 Replies
View Related
May 29, 2007
Hello,
is there any way to measure the progress of a synchronization operation so as to show a progress bar to the user?
Best regards,
Marcos Ruano
View 5 Replies
View Related
Nov 13, 2007
I have a pacakage wich loads data from a .csv file into my database. When I run the package from Visual Studio there is a Progress/Execution Results tab where I see information about the progress. I would like to insert some of these messages into my database. I tried to handle the OnProgress event with an Execute SQL Task and insert the Progress descriptions, but that doesn't seem to give all the information I see on the above mentioned tab (moreover, I get different numbers of events running the package from VS and running it programmatically from c#, why is that?).
What I really would like to get are the messages from the Progress tab which look like these:
[Agreement File [11773]] Information: The processing of file "D:****files*********.csv" has started.
[Agreement File [11773]] Information: The total number of data rows processed for file "D:****files*********.csv" is 201.
[Agreement File [11773]] Information: The processing of file "D:****files*********.csv" has ended.
[DTS.Pipeline] Information: "component "OLE DB Destination" (12598)" wrote 200 rows.
Any help would be appreciated.
View 3 Replies
View Related
Feb 16, 2008
Hi!
I have filegroup that has to few files.
I added new files (corresponding to number of cores).
Now I'm trying to move data to these new files:
dbcc shrinkfile ('oldfile', EMPTYFILE)
But now there are gone nearly one day and dbcc is not finished yet.
It is stressing not to see some progress.
Is it possible to see in some sys table how much data are moved?
Alternative suggestions?
Thanks
View 6 Replies
View Related
Feb 21, 2008
I have just finished building an SSIS package which does a couple of things including using variables, calling child packages as well as starting off replication.
I plan to kick-off the package via SQL Server Agent.
Is there any way I can monitor the progress of this report by creating a web front-end that refreshes every few minutes to report on errors and progress?
Any ideas are welcome.
Thanks
View 2 Replies
View Related
Nov 11, 2006
Hi
am calling an ssis app from my vb programme. It takes about 5 minutes to run. What is the best way to provide progress feedback to my vb user.
Cheers
Ants
I
View 7 Replies
View Related
Jul 4, 2007
Is there any way to limit the content that is placed into the Progress Tab during execution of a package in debug mode?
My problem is that I have a complex package that puts lots of info in there. This package is called in a loop from another package. Each time the package is called, the new info is added to the existing info in the Progress Tab. Eventually the instance of Dev Studio hangs when it gets too much content in that screen.
The only solution would be if I can limit the output content of that screen or turn it off.
All suggestions appreciated.
View 13 Replies
View Related
Mar 8, 2014
I have a query that returns the jobs that have completed for the nightly processing.
If I run the query it does not reflect jobs that are in progress.How can the following query be modified to reflect jobs that have started but have not completed?
SELECT DISTINCT j.Name AS Job_Name,
msdb.dbo.Agent_datetime(Run_Date, Run_Time) AS Run_Datetime,
Dateadd(second, Datediff(second, 0, msdb.dbo.Agent_datetime(19000101, Run_Duration)), msdb.dbo.Agent_datetime(Run_Date, Run_Time)) AS Run_Endtime,
Stuff(Stuff(RIGHT('000000'
+ Cast(Run_Duration AS VARCHAR(6)), 6), 5, 0, ':'), 3, 0, ':') AS Run_Duration,
[code]....
View 6 Replies
View Related
Oct 28, 2015
I am working on a SSRS report and need to show a progress bar as shown in the image below.I can think of using two cells in my tablix with
1:-First cell -a databar having value as percentage (scale 1 to 100)
2:-Second cell containing percent value and then removing the border ( not merging )
However this is not close to the expected
View 6 Replies
View Related
Jan 8, 2008
I'm trying to do an Ad Hoc connection to a Progress database from SQL query Analyzer. I have successfully created a DataDirect ODBC connection and I can access the progress database tables through Excel. However, I can't get it working in SQL.
My stetament is the following:
SELECT *
FROM OPENDATASOURCE(
'DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E',
'DSN=datasourcename;host=servername;port=2501;db=rdatabasename;uid=SYSPROGRESS'
)..schema.tablename
Thanks, Susan
View 6 Replies
View Related
