Search results for query: *

Hi all, WinForms errorProvider will not work after programmatically changing data values in textboxes I tried ErrorProvider1.Clear() but did not help. If it is a UI change by user, there is no problem with ErrorProvider1. I tested after program changes code that it still runs through the...

Hi all, I am using vs2013 update 4. I'm having some difficulties and thinking my approach is wrong from the get go. I have made a "business logic" class in C# console app thinking ahead that I could compile this class to a dll an then in an MVC project (or any other .Net project for that...

Hi all, How to make web page images also appear first time a web browser hits the page? I took a screen shot when browser first loads page, then after hitting refresh one time when then the images also show up. Of course once it is cached it will load all. How do I fix this. Same behavior in...

Hi all, I am semi-retired but was a long time IT professional (Asp.net,c# developer, IT trainer,database developer, etc) and I need some extra income. I want to start a small "mom-N-pop" biz just cleaning up, speeding up, removing viruses, etc to mom and pop clients. Often as we know a complete...

when I get to the screen to set path for snapshot folder, I get the invalid path or filename message. I rechecked the path and it is correct. \\LAPTOPRENAMED\C:\Program Files\Microsoft SQL Server\MSSQL\REPLDATA I also set the REPLDATA folder to be a shared folder. what am i doing wrong here...

I get a message when runnig the replication wizard saying replication will fail becuase I am using the system account for SQL Agent startup. What exactly is the system account anyway? So anyway I go to the logon tab in sql agent properties applet in services in control panel and click the...

install enterprise editon error - system32\autoexec.nt not suitable ..for ms-dos It looks like the autoexec.nt needs to run in system32 but this XP os uses a 16bit subsystem. Is this normal , I have no problem run system32 bit programs on my other xp box. I am installing it to practive...

OK so I import 2 tables, 1 with 500,000 rows and one with 300,000 rows using dts and creating the tables for them in sql server. Now I need to query these 2 tables and join them in the query and use a where clause to filter records I want. But first I think I should makes some indexes which is...

I do a select query to a linked external table, but when I turn into make table it takes forever. Also when I changed back to select but with a where clause it takes forever again. If the records set I have selected in my query is large, is it not better to filter via where clause or...

I am using Qury builder pop up window from the DTS wizard. My source is ODBC using a relativeity software driver, my destination is an excel file. when I check my syntax below I get this error. what may be causing it?? select elgnot.eudpcd, elgnot.eucatg, elgnot.eudpfl, elgnot.euflag...

I had the bright idea to bypass access and just use DTS to pull down data from a table. My source is ODBC (relativity data source driver) and my target is excel 2000. I am using query builder utility which pops up in a dts wizard. I am having trouble with syntax error though. Is the problem...

query syntax problem using DTS wizard query builder the query builder generated all but the last 3 lines. I noticed it did not join the tables so I inserted the Join code. select "elgemp"."eegpno", "elgnot"."eunmbr", "elgnot"."eudpcd", "elgnot"."eucatg", "elgnot"."eudpfl", "elgnot"."euflag"...

I want to use access as front end app for SQL server. can someone explain how to set this up. I took a class and the instructor showed this and I could see in access how the datatype of the table turned from text (access data type) to varchar (sql data type) I was the first American Soldier to...

how to convert.mdb to .adp for SQL server I want to use access as front end app for SQL server. can someone explain how to set this up. I took a class and the instructor showed this and I could see in access how the datatype of the table turned from text (access data type) to varchar (sql data...

why would you use a view vs a query??? I need something concrete to know when to use which !!! TANKS! I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam

iif([eeloca] In ('AMRL','ECON','LUMB','SCIL','TWIS'), 20050301, [eeloca] In ('BOAS','BUHG','JBHT','LBLK'), 20050401, [eeloca] In ('CARD','FRON','AFTY','STHF'), 20050501, true, 99999999) Tank U!! I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a...

can I do an inline select case statement? syntax ? I am using a table for look up that vba code is referencing. switch([eeloca] = "AMRL", "1", [eeloca] = "ECON", "2") 1st question in this switch statement, do I need to put the [eeloca] each time. this is simplified, the problem is it is more...

Is it normal 2 have 2 close and reopen EM after executing some types of scripts in QA or Isql. I created a table in QA and on command line and I refresh EM but does not show up. So I have to close and reopen EM to see the changes. Is this normal or am I missing something obvoius? Thanx I was...

what is good web site to get T-SQL syntax I forgot my T-SQL book and cannot even delete rows from a table. I am converting from access. My DELETE * FROM CUSTOMERS give me an error on the asterisks . Althoug I read if I want to delete all rows I should just truncate since it does not lof...

I am running data.bat file with the following lines: Rem Tis batch file will populate tables cd\program files\Microsoft SQL Server\MSSQL osql -U sa -P Password -d MyBusiness -i c:\data.sql The contents of the data.sql file is: insert Customers (CustomerID, CompanyName, Phone)...