Sending Results To Front End Slow
Dec 10, 1998
I have a 100 mb network and I am returning some large result sets of about 10-50 meg. I am getting through put of sending these resutls of about 2 -3 meg only. I have tried adjusting the client network settings to different protocolsand played with the settings from the performance and tuning guide on Microsofts site.
I am using ADO OLE DB as the connections with VB6.0 as the front end.
When transfering a regular file I am getting between 50 -70 mb through put.
Any help will be greatly appreciated.
Thanks
Tom
View 1 Replies
ADVERTISEMENT
Jul 28, 2006
Hi
I am using association alogorythm for market bsket and I want to publish this results to the CRM system or to any Front end application is it possible and if yes pl let us now how to go head with the same
Thanks In advance
Rajesh Ladda
View 1 Replies
View Related
Nov 12, 2007
When I used the following code:
Imports System
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Net.Mail
Imports System.Net
Imports System.Data
Imports System.IO
Imports Microsoft.SqlServer.Dts.Pipeline
Imports System.Text
Public Class ScriptMain
Public Sub Main()
Dim msg As MailMessage
Dim smtp As SmtpClient
Dim dt As Data.tbl_clients
Dim ad As New Data.OleDb.OleDbDataAdapter
dt = New System.Data.tbl_clients
ad.Fill(dt, Dts.Variables("User::AllFilesFound").Value)
Dim data As String
For Each row As Data.DataRow In dt.Rows
For Each column As Data.DataColumn In dt.Columns
data = data & (column.StaffNo & " : " & row(column.Ordinal).ToString()) & "<br>"
Next
Next
Dim sendNotify As String
sendNotify = "<pre>Cards to be printed " & Today() & " : <br><br>" & data.ToString() & ""
msg = New MailMessage( _
"my email", _
"my email again", _
"Subject: Cards to be printed", sendNotify)
smtp = New SmtpClient("smtp client")
smtp.Credentials = CredentialCache.DefaultNetworkCredentials
msg.IsBodyHtml = True
smtp.Send(msg)
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
I got the following error:
The query failed to parse. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name.
I would like to send an email notification after data has been imported into the table. Any response will be highly appreciated.
Many thanks,
Rupa
View 4 Replies
View Related
Oct 27, 2007
Hi all,
I am just wondering if anyone has a code to send query results to a spreadsheet package eg. MS Excel.
i) Automatically send the query result(s) to the package
ii) open the spreadsheet package;
Thanks.
View 1 Replies
View Related
Apr 1, 2007
hi, like, if i need to do delete some items with the id = 10000 then also need to update on the remaining items on the with the same idthen i will need to go through all the records to fetch the items with the same id right? so, is there something that i can use to hold those records so that i can do the delete and update just on those records and don't need to query twice? or is there a way to do that in one go ?thanks in advance!
View 1 Replies
View Related
Mar 25, 2015
I have four tables: Customer (CustomerId INT, CountyId INT), County (CountyId INT), Search(SearchId INT), and SearchCriteria (SearchCriteriaId INT, SearchId INT, CountyId INT, [others not related to this]).
I want to search Customer based off of the Search record, which could have multiple SearchCriteria records. However, if there aren't any SearchCriteria records with CountyId populated for a given Search, I want it to assume to get all Customer records, regardless of CountyId.
Right now, I'm doing it this way.
DECLARE @SearchId INT = 100
SELECT * FROM Customer WHERE
CountyId IN
(
SELECT CASE WHEN EXISTS(SELECT CountyId FROM SearchCriteria WHERE SearchId = @SearchId)
THEN SearchCriteria.CountyId
[Code] .....
This works; it just seems cludgy. Is there a more elegant way to do this?
View 4 Replies
View Related
Feb 12, 2008
Hello. I currently have a website that has a table on one webpage. When a record is clicked, the primary key of that record is transfered in the query string to another page and fed into an sql statement. In this case its selecting a project on the first page, and displaying all the scripts for that project on another page. I also have an additional dropdownlist on the second page that i use to filter the scripts by an attribute called 'testdomain'. At present this works to an extent. When i click a project, i am navigated to the scripts page which is empty except for the dropdownlist. i then select a 'testdomain' from the dropdownlist and the page populates with scripts (formview) for the particular test domain. what i would like is for all the scripts to be displayed using the formview in the first instance when the user arrives at the second page. from there, they can then filter the scripts using the dropdownlist.
My current SQL statement is as follows.
SelectCommand="SELECT * FROM [TestScript] WHERE (([ProjectID] = @ProjectID) AND ([TestDomain] = @TestDomain))"
So what is happening is when testdomain = a null value, it does not select any scripts. Is there a way i can achieve the behaivour of the page as i outlined above? Any help would be appreciated.
Thanks,
James.
View 1 Replies
View Related
May 14, 2008
Hi All,
I have a stored proc which is executing successfully...but the results of that stored proc are displaying in the Messages Tab instaed of results Tab. And in the Results Tab the results shows as 0..So, Any clue friends..it is very urgent..I am trying to call this stored proc in my Report in SSRS as well but the stored proc is not displaying there also...Please help me ASAP..
Thanks
dotnetdev1
View 4 Replies
View Related
Apr 17, 2008
Sorry for the lengthy question, but here goes:
I currently have an access database with a FE and BE that resides on each users laptop. Weekly they connect to the network and synch the BE the master on a network drive. There are numerous propblems with this as it has grown quite extensive.
We would like to have this be a server based database with the remote users either having access through the web or something else?
A few of the capabilities of the current database:
1. generate and print reports 2. update project forms. 3. enter time logs 4. enter notes
My question is:
What are my options for a remote FE? I am well versed in VB6 and Access. Would be willing to learn other languages (VB.net, my SQL, etc.) Would I be able to have the same functionality or would I have to have separate software for certain functions?
View 5 Replies
View Related
Jan 2, 2008
I have a stored procedure that can take up to 2 hours to run, has anyone any ideas on what front end would be best used to call it
View 3 Replies
View Related
Mar 7, 2008
Hi,
If I don't have any visual studio design tools etc.
Is there any way I can build a simple form that will allow users to view, insert, update and delete single rows from a SQL 2005 database?
Or is there any free downloads that might help. the table is really simple and has only 4 fields
TIA
View 1 Replies
View Related
Sep 4, 2007
Hello,
I am new to SQL Server. I currently have an Access 2007 database and next year my client would like to migrate to SQL Server. Which Front End is the best...Access, VB.net or some other platform altogether?
Thanks,
M. Wilson
View 5 Replies
View Related
Jun 18, 2008
Hi all, I have the following SQLDataSource statement which connects to my Gridview:<asp:SqlDataSource ID="SqlDataSourceStandings" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT P.firstName, P.lastName, T.teamName, IsNull(P.gamesPlayed, 0) as gamesPlayed, IsNull(P.plateAppearances,0) as plateAppearances, IsNull( (P.plateAppearances - (P.sacrifices + P.walks)) ,0) as atbats, IsNull(P.hits,0) as hits, P.hits/(CONVERT(Decimal(5,2), IsNull(NullIF(P.atbats, 0), 1))) AS [average], (P.hits + P.walks)/(CONVERT(Decimal(5,2), IsNull(NullIF( (P.atbats + P.sacrifices + P.walks) , 0), 1))) AS [OBP], (P.hits - (P.doubles + P.triples + P.homeRuns) + (2 * P.doubles) + (3 * P.triples) + (4 * P.homeRuns)) / (CONVERT(Decimal(5,2), IsNull(NullIF(P.atbats, 0), 1))) AS [SLG], P.singles, P.doubles, P.triples, P.homeRuns, P.walks, P.sacrifices, P.runs, P.rbis FROM Players P INNER JOIN Teams T ON P.team = T.teamID ORDER BY P.firstName, P.lastName"></asp:SqlDataSource>There are 8 teams in the database, and somehow the average and obp results are as expected for all teams except where T.teamID = 1. This doesn't make sense to me at all! For example, I get the following results with this same query: First NameLast NameTeamGPPAABHAVGOBPSLG1B2B3BHRBBSACRRBI
BrianAustinHope83432230.7187500.7352941.15625014612201221
GabrielHelbigSafe Haven62119141.0000000.9375002.1428576404111519
MarkusJavorSafe Haven82927200.8695650.8000001.21739114501021218
RobBennettMelville83029240.8275860.8333331.55172411904102117
AdamBiesenthalSafe Haven82929210.9130430.9130431.56521712631001015
ErikGalvezMelville82625180.7200000.7307691.24000011322101015 As you can see, all teams except for Safe Haven's have the correct AVG and OBP. Since AVG is simply H/AB, it doesn't make sense for Gabriel Helbig's results to be 1.00000. Can anyone shed ANY light on this please?Thank you in advance,Markuu ***As a side note, could anyone also let me know how I could format the output so that AVG and OBP are only 3 decimal places? (ex: 0.719 for the 1st result)***
View 2 Replies
View Related
Jun 26, 2001
I'm doing a database for employee info and thier payroll.. im using SQL Serevr 2000 and IIS but i'm not too sure what to use as the frontend, a VB would kinda be overkill because each employee just needs to be able to update his own info and addresses, maybe a XML or some other page that uses windows logins for authentication? any ideas, this is my first project like this on on a college Coop
View 1 Replies
View Related
Jan 31, 2005
i am almost finished building the front end for an application to manage restaurants. i am developing the front end with access vba, and intend to use sql server as a back end for the service. i just came across a group of people bashing access developers on a different site. i have several restaurants interested in using the service, and believe that the service should be very successfull (i have a very specific customer base that is currently not being targeted). the access component would not be a multiuser application. before i distribute the app i would appreciate any input. am i getting myself into trouble using access vba? should i run scared and switch to a vb.net web service?
thanks in advance for any thoughts.
View 1 Replies
View Related
Sep 19, 2006
Below is a post by blindman from my other "mentoring" thread (http://www.dbforums.com/showthread.php?t=1608569). I wanted to respond to it but not in that thread:
Yeah, but if he's going to go unbound he might as well develop in .Net rather than Access. You lose half the convenience of MSAccess as a front end if you use unbound forms and controls.
Besides, he's trying to learn SQL Server, not front-end development. Learning both at the same time may be a bit much. I'd suggest he stick with his idea of converting the Access database to SQL Server back-end.
But, you should definitely convert the Access front-end to a Microsoft Access Data Project, rather than a classic mdb file.
Going unbound would increase your application performance, but probably not noticably unless you have scores of uses, and since you are currently using straight MS Access I'd guess you have no more than five or six simultaneous users, right?
blindman
To start I have decided that ADO is the way to go even though I don't necessarily need the performance boost for my current situation. Keep in mind I am planning for future and more demanding opportunities, hopefully :) And I'd like to learn the "right" way to do things.
I actually use ADO quite a bit in my current DB app and bound controls as well so it really wasn't a new concept. However using strictly ADO produces alot more work and code. And like blindman says it pretty much takes all the ease of Access away and VB.NET for that matter too. I mean all the wizards are useless. So I have two questions:
1. When going to all ADO you are pretty much recreating what Access already does for you right? Coding in ADO is more work right? I mean you have to setup connections and fill fields and listboxes manually in code right? I don't mind the extra work I just want to make sure if I'm going to be doing all this extra coding that it is the right thing to be doing.
2. MDB vs. ADP - From what little I've read Access Data Projects are made for use with SQL Server. It is even more useful if you don't/can't actually work in SQL Server. But again if I'm using ADO it strips all the usefulness of the ADP's doesn't? I don't need ADP's to create views or sprocs. I can do all of that through the management studio. So does it really matter if I use an ADP or MDB as my front end if that is all it is going to be is a front end?
Lastly I wanted to use VB 2005 as the front end but we utilize a ton of reports. As far as I know Crystal Reports or something like it has to be used with VB 2005. Or does VB 2005 have some built in reporting capabilities? I thought I saw some report designer for VB6. Anyway I decided to stick with Access because I am familiar with its reporting capabilities.
I should note that I have VB 2005 Express and SQL Server Express. Right now my company is not putting any money into a higher version.
Let me know what you all think.
Thanks,
GG
View 2 Replies
View Related
Apr 9, 2006
Hi
Can anybody tell us what frount end sould i learn for
better result from sql server.
Can also tell us what is price of sql server developer &
enterprise edition
Thanks
ASM
View 4 Replies
View Related
Aug 25, 2006
Hi,
I'd like to get some help on this. I'm new to SQL Server but am keen to learn it. I have SQL Server 2000 SP4 running and wonder what kind of front end application is best suited for SQL Server 2000.
Thank you in advance
View 10 Replies
View Related
Nov 9, 2007
sometimes a capital N is added in front of a string, for example,
N'xxxx'.
What does it mean?
View 3 Replies
View Related
Oct 23, 2005
Is there any front IDE for MS SQL as there is MySQL Front for MySQL. Iam looking for it so that it is easy to quickly add/edit/delete thedata from the existing table. Please prode the Download URL is there isany.Regards.
View 4 Replies
View Related
Jan 9, 2006
Hi!I'm trying to build an app. for my parents' office. They have a smalloffice (5 PCs), and they currently work with a very old program that'sbased on DOS. The program doesn't work well under XP, so they still useWin 98. They had their network upgraded about a year ago. They hadMicrosoft SBS 2000 installed, it includes SQL Server. I've written afew DB's in Access before, and now I'm just learning how to use SQL.Before I start work on their app., I have a question:I know it's possible to create an interface that can be put on theirnetwork and accessed via a browser. How is this done exactly?It would be very beneficial for me, because it would mean that the newapp. would be platform independent, so that they can upgrade to XPeasily. It would also save us the cost of licensing front-end software(e.g. Access) for each machine.Any comments would be appreciated.Noam Nelke, Israel.
View 2 Replies
View Related
Jul 20, 2005
Hi all,I have a number like so 778625 and want to make this a more meaningfuldate (UK) so how difficult is it to add two digits in this case 19 tothe front of this number?Many thanksSam*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 3 Replies
View Related
Jul 20, 2005
I have created a Database Editor with FrontPage using the Wizzard. I have adatabase in SQL 2000 called Equipment with one table named Equipment.When I bring up the editor, it displays a list of all records with a link tothe edit page. When I click on the link for the first record on the page,The edit page come up correctly. I can edit the page and then submit it.When I click on the link for the second record ( and all the rest of therecords) in the list I get the following message:Database Results ErrorDescription: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax errorconverting the nvarchar value 'BF176' to a column of data type int.Number: -2147217913 (0x80040E07)Source: Microsoft OLE DB Provider for ODBC DriversWhen I click on the link for record BF176, which is about 20 records downthe page, I get the following message:Database Results ErrorDescription: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid columnname 'BF176'.Number: -2147217900 (0x80040E14)Source: Microsoft OLE DB Provider for ODBC DriversI have gone in the SQL database and messed arounf with changing the columntype from nvchar to nchar and changing the length, but can not figure thisout. I cannot tell whether this is a Frontpage problem or a SQL problem.Any help would be appreciated! Thanks!DarrenMCP
View 1 Replies
View Related
Sep 18, 2007
Hi
I have a scenario while creating a report where I need to maintain the same number of rows for a column, even if the data grows or shrinks for that column
example
Each Scenario is grouped by ID
Scenario 1
columnA
Row1 X X
Row2 X
Row3 X
Row4 XYZ
Scenario 2
columnA
Row1 XA
Row2 XYZ
In both scenario's I need to control from front end
the number of row should remain 4
I am grouping by row field say Type
This field Type varies for each ID group
View 1 Replies
View Related
Feb 26, 2004
Hello all. Yes, this is another question relating to how to make a front-end to a SQL database using ASP.NET. I performed a search in this forum and did not find the exact answer to my questions (one responder to the other threads about this topic even said this is the incorrect sub-forum for this question, but I found no other appropriate place; considering this sub-forum is for asking beginner questions).
Besides the "quickstart" tutorials linked off this site, can you point me to other web resources (tutorials, walk-throughs, etc) or books that would provide the necessary information to develop a SQL front-end? Specifically I need help creating the Update Record and Delete Record pages.
I was hoping a "rapid development" tool could be used. At my disposal I have Visual Studio .NET 2003, Dreamweaver MX 2004, and FrontPage 2003.
Thank you for your time.
View 1 Replies
View Related
Jan 26, 2001
I am using Access 97 as a front end to access SQL 7 server on NT 4.0 server.
I've set up security model based on NT authentication only. Users have login right to login to SQL and they have public & dataread & denydatawrite access. They also have SELECT permission on a table object and have no permission to INSERT, DELETE and UPDATE.
When I use Access 97 to access a database, users are still capable of inserting and deleteing records in tables.
Am I doing something wrong?
Thanks, Michael.
View 1 Replies
View Related
Jan 18, 1999
Maybe because I have worked mainly with VB as a front end to SQL Server so I am biased, but I now need definite reasons (I am on a committee for potential future directions) for using VB as opposed to Access for front ending SQL/Oracle, etc. I would also like to use ADO as oppose to DAO. Right now we are using Access with DAO.
Any ideas greatly appreciated.
View 2 Replies
View Related
Sep 15, 1998
Hi All,
From front end application, I execute a SQL
`exec sp_password oldpassword,newpassword
and I got error message :
"Error code# 15002 :[Visigenics] [ODBC MS
SQL Server 6 Driver] [MS SQL Server]
The procedure `sp_password` cannot be
executed from within a transaction.".
If I logged in directly to SQL 6.5 without going
thru the front-end application then I could
change password successfully.
Has anyone tried to change password FROM
a front-end application? Our shop uses
Omnis 7.3.6 as front end and SQL 6.5 as back
end. TIA.
David Nguyen
View 2 Replies
View Related
Oct 10, 2001
Hi,
We have just moved a largish Access database (180mb, 78 tables, largest
tables have about 250k records) to SQL 2k. The original app had an Access
back end (now loaded to SQL), and an Access front end (on each client) which is using some
local temporary tables, about 600 queries, and several thousand lines of
code using ADO and DAO). The Front end was relinked to SQL back end. When
testing everything seemed to run OK, but under load (15-20 users) the new
app just crawls. Routines that used to take seconds now take 10s of minutes.
ODBC timeouts or blocks are common.
Any idea why should the SQL back end be so much slower than Access. both the
Access back end and SQL2k are on the same server (Win 2k Adv. with RAID 5,
dual 600mhz Pent III, 512Mb RAM).
I realize that Access is not the best front end but that is what we have to work with.
Any help would be appreciated, as I am ready to swith back to Access.
Thanks,
Jakub
View 2 Replies
View Related
Oct 27, 2006
My company uses MS SQL Server for the back end and a Retail specific CRM as the front end. I wish to develop some internal peices of software for our use. I was planning on doing this with access.
my options are:
*Use access as front end and backend
*Use access as front end and SQL server as backend (create new DB)
*Use other front end and SQL Server as backend.
My question is, what are some good front ends that are availble for reletively small demands? How does Visual Studio come into play?
*Also, I would prefer to be able to create a .exe. I dont think access alows that. I would not want users to be able to go in (or even see) the tables and queries. They should only be able to see the one main menu form at the very least.
thankyou,
Dynasty
View 1 Replies
View Related
Oct 4, 2006
When I build an MS Access front-end for an SQL Server backend, how does it take care of data integrity and concurrency , if it is only a front-end ?
Is Access smart enough to do the job ?
Thanks.
View 1 Replies
View Related
Sep 24, 2012
there is a Crystal Report run from the Front end Application. The DB used here is SQL Server 2008. I need to know the Stored Procedure used by the report that is been run from the front end. . How shall I do it?
View 6 Replies
View Related
May 21, 2008
Clearly, I'm very new to this.
Does anyone have a favorite tool/system for creating a SQLServer front end?
I've been looking into this myself and seeing everything from Visual Basic to Access to ASP, from Web to Windows.
Here's my situation. I need to create a few simple tools for our office folks to use. For example, a tool that creates an invoice using data from two tables (Customers, Items).
I'd like to make it as simple as possible for them (ex. setting up an autocomplete for the customer name, etc.).
Please understand, I'm not looking for anyone to write code for me. I just want some feedback on what tools to use.
I would just use Access (since I am familiar with it), but we don't have it here. Sigh.
Any thoughts? Personal Preferences?
View 3 Replies
View Related
