Search results for query: *

can you query db from server to db on a webform? yes crTableLogOnInfo = crTable.LogOnInfo; // get correct password crTableLogOnInfo.ConnectionInfo.Password = ODBCPassword(crTableLogOnInfo.ConnectionInfo.ServerName.ToString()); crTableLogOnInfo.ConnectionInfo.UserID =...

Crystal is pulling the data for the reports. I am not using stored procedures to populate the report with data. does the account connecting to the db have permission on the server to execute the sql statement? I have set up a SQL user am logging onto the db using that. The reports that are...

I have written a web application which embeds crystal reports into ASP.NET (1.1 framework). I have no issues running the reports on my development machine where all the SQL Server 2000 db is located but when I deploy to the test and live servers where the SQL Server db is located on a different...

I have written a web application which embeds crystal reports into ASP.NET (1.1 framework). I have no issues running the reports on my development machine where all the SQL Server 2000 db is located but when I deploy to the test and live servers where the SQL Server db is located on a different...

that's done the trick, it's easy when you know how ta

dg.Items.Item[1].Cells[20].Text; is what I had figured it out to be but I wasn't sure. I am using ASP.NET 1.1 with C# and I am getting this message should be somethig simple I've overlooked c:\inetpub\wwwroot\Reconciliation Reports\Menu.aspx.cs(93)...

Sorry for the stupid question but I have been looking for a while to get the syntax. What is the c# syntax for getting a value from a selected datagrid? the vb is "dg.Items.Item(1).Cells(20).Text

It is looking to me like there isn't really a problem now. The application is a .net application being built using visual studio. It appears that in the debug mode connections are only created and never seem to be closed unless by code. In Release mode it looks like connections are reused if...

I have a web application because of the way people can quit out of it, their connection to SQL Server remains (SPID). I have written a proc that will run during the night to kill the SPID processes, however I am worried that during the day I might hit an upper limit of SPID processes and the...

I have not used Crystal for a few years, however last time I did I created an application embedding Crystal Reports 8.5 into an ASP interface. In that application I could change the groups of the reports at runtime, I believe it was the command AddGroup. Can I do the same in ASP.NET using VB...

I have installed MySql version 5.0 locally onto my laptop. I have problems when I change locations from the office to home, "Could not connect to specified instance. MySQL Error 1045 Access denied for user 'root'@'localhost' (using password:YES)" I have a static ip address at work and but not...

I have 2 dts packages that use a query to get just under 16,000 records from an ORACLE view that uses 5 tables and has just under 100,000 results I have an ORACLE view that uses 5 tables and returns just under 100,000 results. I have 2 dts packages that use the same query that returns just...

go into Enterprise manager. highlight the database you want to shrink. right click >> All tasks >> Shrink db select the shrink files option at the bottom of the screen select the file you want to shrink data or log select shrink action shrink file to and define file size to shrink to that...

I have set up a windows account with Administrator privileges as my SQL Server Agent proxy account. When I schedule the job it uses that account and executes the dts package as expected. Thanks

We have sorted it out now. We had to create a windows account with the correct permissions and then go into the SQL Server Agent Properties, select Jobs System and set up a proxy account using the window account. Don't understand why it did previously work with a SQL Server import and not an...

A good idea but we built an ran the dts package on the server. It looks to me like a security problem. I log onto the server with domain security. The job has SQL Server uses the sa logon, with administrator rights. The connection to ORACLE as an ORACLE account with read only rights. The dts...

I have 2 dts packages, one dts package imports data from a sql server db and the other imports data from an ORACLE db. Both dts packages can be executed from sql enterprise manager. The problem is that when I schedule the packages with a job, the SQL Server import dts package works fine but the...

1. Are you using Page.LoadControl() to create the user control? Nope. 2. When are you trying to access the property? I have a combobox on my parent form. On the change event of that combobox I want to populate the valve of a text field in the user control into a text field on the parent...

I am new to asp.net. I have created a user control that has a text tox in it and I have put it onto a web form. (I am doing this with a reference book in one hand!) When I run it I get the user control loaded onto my form ok, The buttons do what they are suposed to do and the text box gets...

thanks, we'll look into it