Hi Rob, > Did I mention my abilities(cough!). I've seen you here long enough to know you sell yourself short.
> I have seen DSNs mentioned, but have never attempted to > use them. For the most part they are a waste of processing power and resources for the typical app, but for network aware applications they're a little more useful. > I don't have a server at home, and have never developed > apps to run on them, before now. The easiest way to set up so you can test it out using DSN's is to rename your computer (right click my computer > properties > network id...). Then setup the DSN via control panel, admin tools, data sources (ODBC), SYSTEM DSN. At this point it should use a LOCAL file path (C:\path\file) not a UNC (\\servername\path\file). > \\Xpws1\c\SecaJobs\Target.txt (<== OE seems to think that's > a link ?) UNC paths are assumed to be URL-aware. > Is that a UNC path ? Yep. > >Check the log files on the server > > Uncharted territory for me, and I rarely visit the > client physically, as they are miles away in the > foothills. I will try to check that out over the > phone, and if that does not work, I will get out > of my cave, and visit.. Have their geeky step-child (or whoever you said it was) do it while on the phone with you. The steps I gave should lead him directly to the errors if it's a licensing problem. > > Just set the SERVER param in the connection string to > > the server's name > Any search words that I should use when 'googling' to > understand how to do that ? "sql connection string remote server" > > be setting the connectiontimeout property higher than it is now > > Is that a property that my pgms would set each time they > connect? Yep. > If I go with Matt's suggestion for running an exe on the > server with a continous connection, Is that where the > Timeout thing would come in handy ? Yes, but this could cause further blocking problems if it is a CAL deficiency. Regards, Shawn K. Hall http://12PointDesign.com/ http://ReliableAnswers.com/ '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> 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/
