System.Exceptin: System.NotSupprotedException: The given path's format is not supported
Posted on 2007-08-02
Products: VS2005, SQLServer2005, WinServer2003-1="server," WinServer2003-2="client"
Goal: Store documents(.doc, .xls, .mp3 etc.) as VARBINARY(MAX) records in SQL Server db.
WinApp: Collect Path\File.ext and miscellaneous fields, pass to Sproc via ADO.Net (Params.Add, ... ExecNonQuery)
SQLServer: Consume .dll to yield methods as stored procedures. The .dlls use stream reader and writer to read/write Path.File. It is the stream reader that fires System.Exception (described in title and below)
Development Environment: Win2003. Everything works as expected when "client" and SQLServer are on the same box.
Generic Problem (at deployment): SQL Server on box2 doesn't access files on box1-client.
Clue 1: SQL Server (box1) cannot connect to .dll on client development box2. Solution 1: copy .dll from dev. box2 and past into shared folder on Server box2.
Clue 2: "System.Exception: System.Data.SqlClient.SqlException ... from 'clrSpStoreDoc' (my clr sproc) System.Exception: System.NotSupprotedException: The given path's format is not supported..."
The paths it complains about: "C:\directory\file.ext", "\\MachineName\C:\directory\file.ext", "220.127.116.11\C:\directory\file.ext."
Specific Question: How do I get the two boxes to play together?
Hypothesis 1: Ill-formatted file locater string. Hypothesis 2: Win Security issue---need to elevate permission on server so it has permission on client (??nonsense??).
Worst scenario: WinApp copies file from client to shared directory on server, then launches sproc which reads file from it's local directory and writes to db.
This description deliberately high level. Need a direction to drill into. Will answer questions and explore suggestions in good-faith dialog.