Recent content by wyldsider

Okay, here is an interesting question that I haven't seen posted here before. We have an application that is getting close to completion, and I have been tasked with making sure the install program is up to snuff. So in the process of defining what is needed to install the server portion of...

Okay, can you be a bit more precise on what I can look for? Any kind of reference to how to fix it? thanks in advance, Jack Jack De Winter Software Developer MedTel Software www.medtel.on.ca

Okay, background first. We have an application that is working fine on 99% of the machines we have tested it on. There is one machine, called Norm, that seems to be really stubborn. (No relation to the cheers character of course.) The connection string I am using is...

Actually, not to mix words, but as NULL implies the absence of any value, wouldn't it be more correct to say that no value is stored so that the "value" of the column remains NULL? cheers, Jack Jack De Winter Software Developer MedTel Software www.medtel.on.ca

For our sake, we all downloaded D4Time, a freeware program, and installed it in the Startup Folder. It syncs to the national atomic clocks and keeps things nice and steady. cheers, Jack Jack De Winter Software Developer MedTel Software www.medtel.on.ca

This is going against MSDE. I develop using a developer's edition of SQL Server, so I have the tools here, but not on that machine. My copy of EM cannot seem to connect up to that machine, it gets the same error as if I am trying to do a normal connection. When I install, I do: setup.exe...

Nope, goes straight to the machine in question. We are also having problems from some machines access a data drive on the same computer? Perhaps a SOCKS or PDC problem? cheers, Jack Jack De Winter Software Developer MedTel Software www.medtel.on.ca

Would blocking the port happen if you were trying to access it from the other side of the router, or the inside. Basically, there is my machine (as an example) and the server machine. They both use the LinkSys to shove packets around, but I would have assumed that port 1433 would only be...

IP traffic to the machine is fine. Pings work, and network traffic seems to be fine. It only seems to be this one machine that is having a problem. We have 5 2K machines in the office, and this seems to be the only one with this problem. Jack De Winter Software Developer MedTel Software...

long and short of it is that we went from a network where we had a proxy server as our gateway (no PDC) to using a LinkSys router as our gateway. Before, everyone was able to log on to one of the computers running SQLServer 2K (MSDE) and now no one can unless they are on that computer itself...

HI... we have a small shop here where we don't actually have Win2K Server acting as a PDC. We were using a proxy server, but that had network problems so we replaced its functionality with a LinkSys router that seemed to be doing everything that we needed. Before, when using the proxy server...

Here is an associated question then. We end up using ADO to map to a SQLServer 2000 database, and it works very well. However, we find that SQL Server uses 1900-01-01 for a base date and COleDate uses 1899-12-30 for a base "zero" date. Has anyone else had these kinds of problems...

What we have done here to get around the problem is to store the UTC (Universal Time) itself, and then using the windows routines to translate into the local times. Now, we enter most of our times manually, so this is an option to us. Is there a way to tell SQL Server you want to add a UTC...

Is there a way to schedule these from direct SQL queries, for those of us programming against MSDE? Jack De Winter Software Developer MedTel Software www.medtel.on.ca

For those of us that are trying to do the same thing using MSDE, is there a MSDE solution involving SQL queries that could achieve the same result? Jack De Winter Software Developer MedTel Software www.medtel.on.ca