Well, I got it working. manzo had some good ideas, and from those investigations I realized what was happening and corrected things. I feel a bit foolish at this point, but figured that I would give my embarrassing solution since there were so many trying to help me.
As it turned out, there actually was two databases. I now remember that when I originally wrote the package, it did not work properely. This was because the ISP required that the database be placed in a certain area. I did this and changed the file that holds the connection strings on the other end. When I was working locally, I updated the database in the original area I had placed it, completely forgetting about the previous problem. Needless to say, adding a couple of fields meant that I was looking for them in a database that did not include them. Thanks to everyone for your time in helping me with this. Without you I would certainly still be shaking my head. Cheers - george --- In [email protected], Paul Manzotti <[EMAIL PROTECTED]> wrote: > GLSmyth wrote: > > >Ret = OpenCommand(objCommand, "LAKS") > > > > > I'm curious as to what this does? I take it that it's a sub in your > connection file that sets up the connection for the command object, but > I'm wondering why you assign it to a variable? > > Other random thoughts: > > Have you tried > > objCommand.CommandText = "Select [Question] From [Registration] Where > [Username] = 'z'" > > rather than assigning it to a variable. I mean, you may have the only > machine on which VBScript is case sensitive! ;-) > > Have you tried using LIKE instead of "="? > > Have you tried saving the query in Access, and using it like a stored > procedure? > > Can you find out what version of the MDAC is running on each server (I > think that there's a way of doing it with code). > > Sorry I've got no concrete ideas, but I usually find it's worth trying > anything once you get to this stage with a problem. > > manzo --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
