Scott, Robert, and Ben. Thanks for the responses. I don't specify an account and password when I set the datasource within Witango. I just select ODBC and specify the ODBC name with <@var <@var user$U_Site>$CatDSN>. It works fine when I have the DBs located on the Witango server OR if they are located on a separate server and I use a different account.
I would prefer to use the Local System Account for Witango, but I get the following error with the ODBC connection pointing to a separate DB server: Thanks in advance for any advice. Steve Error An error occurred while processing your request: File: Default.taf Position: FindCategoryForBanner Class: DBMS Main Error Number: 7 [RBTI][Oterro ODBC Driver]-ERROR- Unable to connect database ( 7) 08001 File: Default.taf Position: FindCategoryForBanner Class: DBMS Main Error Number: 0 [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). 01000 File: Default.taf Position: FindCategoryForBanner Class: DBMS Main Error Number: 2638 [RBTI][Oterro ODBC Driver]The database is currently unavailable -- it is probably open with MULTI set OFF. 08004 File: Default.taf Position: FindCategoryForBanner Class: Internal Main Error Number: -4 Unable to connect to the specified data source. File: Default.taf Position: FindCategoryForBanner Class: Internal Main Error Number: -4 Unable to connect to the specified data source. Verify that data source is properly configured and that database server is online. -----Original Message----- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 12:32 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: RE: Witango-Talk: Hi Steve, Unless I'm missing something, I don't see why you needed to change the permissions of the Witango Service if it was working fine before. The "System" Account on Windows is preferred for process like Witango. Moving your Database to another Server shouldn't force you to change the Account Witango runs under, even on Windows 2003. Most ODBC Drivers on Windows, that support remote ODBC Client connections (like SQL Server), allow you to specify a Username/Password that can be unique from the Service Account. It's the Username/Password configured for your Database Actions that talk to the ODBC Client you need to change if anything. But like I said, maybe I'm missing a piece of the scenario. Sorry if I don't have it right. Cheers... Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community --------------------- XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) --------------------- -----Original Message----- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Date: Thu, 29 Jan 2004 12:10:44 -0600 Subject: RE: Witango-Talk: RE: Witango-Talk: > I logged in at the Witango server with the new service account. I went > to > the root folder of the site and was able to execute the bat file with > no > problems. So I would think that my permissions are set ok. > > The bat file is located in the root directory. > > The External action is as follows: > > Type: Command Line > Command: <@webroot>dir.bat > Environment Variables: Name - PATH1, Value - <@var method$file_name> > > This worked fine before I changed the "Log On As" account for Witango. > I > could change it back, but I would not be able to use a separate DB > server, > so I would like to work through this if possible. > > Thanks > > Steve > > -----Original Message----- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 29, 2004 10:46 AM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: RE: Witango-Talk: > > > I think it has to be called using something like > > Cmd dir.bat > Or > Command dir.bat > > Trying to remember exact :-b > > > > > Ben Johansen - http://www.pcforge.com > Authorized Witango & MDaemon Reseller > Available for Witango Developement > > > -----Original Message----- > From: Fogelson, Steve [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 29, 2004 11:18 AM > To: Witango User Group (E-mail) > Subject: Witango-Talk: > > Witango version 5, Win 2003 Web Edition > Hi, > > I been working on this problem for 2 days and can't find the solution. > I > changed the "Log On As" account for Witango from "Local System Account" > to a > new account, so that I could locate my databases on a different server. > I > gave Full Control permissions to root directory of the site, wiis.dll > in > the > scripts directory, Witango folder under the Program Files folder. I > located > the DB's on another server, set permissions for the new account, and > changed > the ODBC connections. Everything works great except for one thing: > > When I use External actions, it is having trouble. The External actions > are > not referencing anything on the DB server. I have even reduced the .bat > file > the External action references to just a dir *.* > > I am getting the following error: > > [Application File] [47] /listingimages.tcf > [External Action] [47] call_identify > [Query] [48] C:\Inetpub\wwwroot\CatSite\dir.bat; Parameters: > PATH1=C:\Inetpub\wwwroot\CatSite\Sites\upnorth\Image\catimages\BuckKit. > j > pg; > [External Action] [48] Forking process > [Error] [48] -101 General error during data source operation. > [Error] [48] -101 General error during data source operation. > [External Action] [48] Complete > Any ideas?? > > Thanks > > Steve Fogelson > Internet Commerce Solutions > _______________________________________________________________________ > _ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > _______________________________________________________________________ > _ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > _______________________________________________________________________ > _ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
