Search results for query: *

Thanks. I'll try that. I set it on the server, but my client that is trying the connection from outside my network is gone now...slacker! :) I'll know tomorrow morning. Steve

I have a Server running Server 2003 with SQL Server 2000 SP3a. I have a VB app that connects and runs fine while I am on my local network. I added the following connection string and am trying to connect running from another location and it is giving me the usual 'Login failed for user...

JASS1220: Your code will work, but you are essentially scanning the entire table yourself to find the row you are looking for. If that table is large, you may bog down pretty quickly since you will on the average scan half the rows in the table everytime. I'd recommend just doing the whole...

You can get fields with the same name from multiple tables if you use the AS operator to rename the field in the result set: adoPartyRosterRS.Open "select Members.ID AS MemberID, Visit.ID AS VisitID from Members INNER JOIN Visit ON Members.MembershipID = Visit.MemberID where Visit.PartyID...

Perhaps you are expecting it to do more than it is intended. I personally don't consider VNC an "editing tool". I consider it a "remote control" tool. I use it often to connect to other remote machines to do on those machines whatever I could do locally. I have no problem...

I would just write a second little app that takes command line parameters of the copyfrom and copyto file names. Start it up from the ToBeReplaced application. The ToBeReplaced application shuts down and the CopierApp does the copy and starts the new copy back up. The CopierApp can attempt to...

I do this by encrypting the user's password before it is placed in the table. When the user enters their password the next time, I encrypt the entered value and compare it to the encrypted version stored in the db. If they are equal, the user entered the right password. I use IE's 128bit...

Assuming you have ADO code that is working and you just want to add transactions, just add the BeginTrans and CommitTrans method invocations in your code on the connection object doing the data access. Put the BeginTrans before your database modifications and the CommitTrans after the last...