Hi Andre, I think you're right, that UNC may be a limitation of the driver.
Because this particular type of driver uses text files as datasource, the SQLSetConnectAttr is not uncommon. Internally the driver will process SQL as instructions for reading the data. The attribute it's trying to set is probably the UNC info since '(unknown)' is not a valid path, and it doesn't understand it. Bummer.... If you have a SQL Server on that particular network machine (where the UNC points to), you could probably use a Stored Procedure call from Witango to invoke the ODBC call -> but in local context. Know what I mean? Hope that helps. Scott, > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 24, 2007 12:19 PM > To: [email protected] > Subject: RE: Witango-Talk: CSV ODBC Witango 5.0.62 License Error > > > Hi, Scott. > > I would agree it's not license issue, we got managed to get rid of it by > populating DBAction fileds. Now getting new errors. Out Witango is > running under proper network credentials since it is able to save files > via UNC paths. However It is not clear how to pass proper credentials to > UNC Share? > > Witango Service Credentials are not being proxied by ODBC MS TXT/CSV > Driver. Driver itself doesn't have an option to specify password. BTW it > doesn't even offer valid ways to use UNC. I assumed a PWD= tag should be > used within ODBC Descriprion. Unfortunately it doesn't help. > > So, right now we have the same uid/pwd for Witango/ODBC Driver and TAF > File. Still reports: > > Error] [63] -1023 [Microsoft][ODBC Text Driver] '(unknown)' is not a > valid > path. Make sure that the path name is spelled correctly and that you are > connected to the server on which the file resides. HY024 > [Error] [63] [Microsoft][ODBC Driver Manager] Driver's > SQLSetConnectAttr > failed IM006 > [Error] [63] -4 Unable to connect to the specified data source. > > The last string makes me wonder, if we're trying to pass some SQL Specific > parameter to UNC Share? > > Sincerely, > > Andre > > > > Hi Andre, > > > > I've seen those messages when a database Action simply doesn't have a > > datasource assigned. Like when dropping an DB Action into a TAF and > > running > > it, without having dragged any table or columns into the Action. > > > > It could be a permission problem in your case. The Witango service would > > have to have permission to read the UNC share folder on the other > machine, > > me thinks. > > > > Hope that helps. > > > > Scott, > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > >> Sent: Wednesday, January 24, 2007 11:54 AM > >> To: [email protected] > >> Subject: Witango-Talk: CSV ODBC Witango 5.0.62 License Error > >> > >> > >> Hi, Everyone. > >> > >> Just wondering if anyone has a successful experience using ODBC Sources > >> to > >> CSV/TEXT file located at UNC share? > >> > >> The error we get suggests Witango 5.0.62 doesn't work with such DSNs. > >> > >> [Error] [7] -109 This type of data source is not supported by > > the > >> server > >> license. > >> [Error] [8] -4 Unable to connect to the specified data source. > >> Verify that > >> data source is properly configured and that database server is online. > >> [Changed Vars] [8] request$msg=Failed to read CSV file; > >> [request$ Vars] [8] variableTimeout=15; msg=Failed to read CSV > > file; > >> > >> Sincerely, > >> > >> Andre > >> > ________________________________________________________________________ > >> 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
