Search results for query: *

Well thanks for trying to help. I gave up and uninstalled and the reinstalled so I can start work again. For what it's worth here is the contents of the oldest log but I think it is after I reinstalled 2006-07-21 10:01:50.47 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6...

-d and -e replaced Error logs? Event Viewer/System shows 1. Sqlexpress was sucessfully sent a start control 2. sqlexpress service entered the stopped state 3. sqlexpress service terminated with service-specif error 17058 4. The MSSQLSERVER service failed to start due to the following error: The...

Read William Gibsons newest novel <g> Oakgrove Computer Grouper Lansing, MI

If I understand you try to connect from an asp page to an sqlserver where the web server and the sqlserver are not on the same machine and it give you: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." If you put the sqlserver on the same box as the web...

I would think the previous post would work. If not 1. Can you use distinct for just one column e.g. select (distinct ori), ...etc. ... from ... 2. If not I think you could use Group by Oakgrove Computer Grouper Lansing, MI

Hi, I have sqlserver 2000 running on winxp sp2. I recently had the HD changed to a larger drive all programs and files seemed to have transfered over ok. I just installed VStudio 2005 which put a copy of sqlexpress on the machine. Now when I try to start sqlserver2000 with the name of the...

Of course it is sql2000 that I am working with. In the services list I do not find MSSQLSERVER$instancename but what I do find is just MSSQLSERVER I did right click and reset "log on as" to "localSystem Account' This worked and I can now connect using EM using the instance name. Thank you...

I have a named instance of sql2003 running on XP and I used EM to change the Startup Service account from "System account" to the login and password that I use to start up the XP. The prompt said that window text search may not be available if I proceed. I said ok and then sqlserver stoped and...

I wonder if using SQLServer Client Network Utility might let you do something like you want. Just a wild stab in the dark. Oakgrove Computer Grouper Lansing, MI

I have a named instance of sql2003 running on XP and I used EM to change the Startup Service account from "System account" to the login and password that I use to start up the XP. The prompt said that window text search may not be available if I proceed. I said ok and then sqlserver stoped and...

Yepers! Oakgrove Computer Grouper Lansing, MI

I subclassed the VFP 9.0 ffc htmllistener class to modify the getpagelength and getpagewidth so it can be used on a box with no printers defined. The new vcx is noprinthtmllistener. I call it in a COM server “exe” to use it to print a report outputted as an html stream. This exe is called from...

Ok Now I got it. Thanks Oakgrove Computer Grouper Lansing, MI

humm, I must be missing your point select callid,localuserid from [sourcetable] where callid not in(select phoneleadid from [67.xx.xxx.xxx].[server1].[dbo].[targettable] where phoneleadid is not null) returns ALL the records in the source table not just the ones that...

good thought however sourcetable.callid is never null Oakgrove Computer Grouper Lansing, MI

Have you tried breaking it down to one part, see if it runs the adding another, etc. Oakgrove Computer Grouper Lansing, MI

The following query runs on the SQL server box that has the 'sourcetable'. Its function is to add new records to the 'targettable' on the remote linked server. It correctly adds rows when I have the 'targettable' set with column 'phoneleadid' as the primary key. It runs but, does not add rows if...

I just got this whole thing to work about an hour ago. I had to sub class _reportlistener.htmllistener so that I could use getpageheight() and getpagewidth() to set these two values which satisfied VFP runtime even though there was no printer defined on the web server. See MSDN...

Thanks for the reply. 1.Actually I do have the error check in the code. It tells me that "lolistener is not an object" when the "Repo Form ..." line trys to execute. 2.The location of files in directories may well be part of the problem. I would have thought that I Shield would put them in the...

I have found that I can't deploy code in a com object that trys to use the _reportlistener.vcx. For example: The following code produces the report using the vfp classes on my development machine but does not when deployed to a test machine. Instead lolistener = .f. define class getstream...