Re: [sqlite] CEROD in System.Data.SQLite

[E. Timothy Uy]

I tried

  conn = new SQLiteConnection(String.Format("Data
Source={0};ToFullPath=False", ":memory:"));

but unfortunately still no love

On Thu, Feb 12, 2015 at 3:45 AM, E. Timothy Uy  wrote:

> http://system.data.sqlite.org/index.html/artifact/9a65aebbcf2379f3
>
> Hmm, yes, I think that this is the issue. Need to have handling of the
> :cerod:pwd: tag  near
>
>  if (!fullUri)
>   {
> if (isMemory)
>   fileName = MemoryFileName;
> else
> {
> #if PLATFORM_COMPACTFRAMEWORK
>   if (fileName.StartsWith("./") || fileName.StartsWith(".\\"))
> fileName = 
> Path.GetDirectoryName(System.Reflection.Assembly.GetCallingAssembly().GetName().CodeBase)
>  + fileName.Substring(1);
> #endif
>   bool toFullPath = SQLiteConvert.ToBoolean(FindKey(opts, 
> "ToFullPath", DefaultToFullPath.ToString()));
>   fileName = ExpandFileName(fileName, toFullPath);
> }
>   }
>
>
> Maybe I can temporarily shunt it using "toFullPath".
>
> On Thu, Feb 12, 2015 at 3:43 AM, E. Timothy Uy  wrote:
>
>> I have confirmed that the unencrypted version works fine. Perhaps this is
>> the issue, that it is trying to ExpandFilename on a string that is
>> prepended by ":cerod:".
>>
>> On Wed, Feb 11, 2015 at 7:37 PM, E. Timothy Uy  wrote:
>>
>>> I'm working on switching our custom build of System.Data.SQLite from our
>>> custom build and am having problems opening a CEROD database. Going back
>>> over our code, I see that I wrote in Open():
>>>
>>>  // TU: Need to split out "cerod" prepend to filename before
>>> expandfilename
>>>
>>> string pattern = "(:.*:)(.*)";
>>>
>>>   Match m = Regex.Match(fileName, pattern);
>>>
>>>   if (m.Groups.Count == 3)
>>>
>>>   {
>>>
>>>   string prefix = m.Groups[1].ToString();
>>>
>>>   string cleanFileName = m.Groups[2].ToString();
>>>
>>>   cleanFileName = ExpandFileName(cleanFileName);
>>>
>>>
>>>
>>>   fileName = prefix + cleanFileName;
>>>
>>>   }
>>>
>>>   else
>>>
>>>   {
>>>
>>>   fileName = ExpandFileName(fileName);
>>>
>>>   }
>>>
>>>
>>> Maybe something similar is needed?
>>>
>>
>>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CEROD in System.Data.SQLite

[E. Timothy Uy]

http://system.data.sqlite.org/index.html/artifact/9a65aebbcf2379f3

Hmm, yes, I think that this is the issue. Need to have handling of the
:cerod:pwd: tag  near

 if (!fullUri)
  {
if (isMemory)
  fileName = MemoryFileName;
else
{
#if PLATFORM_COMPACTFRAMEWORK
  if (fileName.StartsWith("./") || fileName.StartsWith(".\\"))
fileName =
Path.GetDirectoryName(System.Reflection.Assembly.GetCallingAssembly().GetName().CodeBase)
+ fileName.Substring(1);
#endif
  bool toFullPath = SQLiteConvert.ToBoolean(FindKey(opts,
"ToFullPath", DefaultToFullPath.ToString()));
  fileName = ExpandFileName(fileName, toFullPath);
}
  }


Maybe I can temporarily shunt it using "toFullPath".

On Thu, Feb 12, 2015 at 3:43 AM, E. Timothy Uy  wrote:

> I have confirmed that the unencrypted version works fine. Perhaps this is
> the issue, that it is trying to ExpandFilename on a string that is
> prepended by ":cerod:".
>
> On Wed, Feb 11, 2015 at 7:37 PM, E. Timothy Uy  wrote:
>
>> I'm working on switching our custom build of System.Data.SQLite from our
>> custom build and am having problems opening a CEROD database. Going back
>> over our code, I see that I wrote in Open():
>>
>>  // TU: Need to split out "cerod" prepend to filename before
>> expandfilename
>>
>> string pattern = "(:.*:)(.*)";
>>
>>   Match m = Regex.Match(fileName, pattern);
>>
>>   if (m.Groups.Count == 3)
>>
>>   {
>>
>>   string prefix = m.Groups[1].ToString();
>>
>>   string cleanFileName = m.Groups[2].ToString();
>>
>>   cleanFileName = ExpandFileName(cleanFileName);
>>
>>
>>
>>   fileName = prefix + cleanFileName;
>>
>>   }
>>
>>   else
>>
>>   {
>>
>>   fileName = ExpandFileName(fileName);
>>
>>   }
>>
>>
>> Maybe something similar is needed?
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CEROD in System.Data.SQLite

[E. Timothy Uy]

I have confirmed that the unencrypted version works fine. Perhaps this is
the issue, that it is trying to ExpandFilename on a string that is
prepended by ":cerod:".

On Wed, Feb 11, 2015 at 7:37 PM, E. Timothy Uy  wrote:

> I'm working on switching our custom build of System.Data.SQLite from our
> custom build and am having problems opening a CEROD database. Going back
> over our code, I see that I wrote in Open():
>
>  // TU: Need to split out "cerod" prepend to filename before
> expandfilename
>
> string pattern = "(:.*:)(.*)";
>
>   Match m = Regex.Match(fileName, pattern);
>
>   if (m.Groups.Count == 3)
>
>   {
>
>   string prefix = m.Groups[1].ToString();
>
>   string cleanFileName = m.Groups[2].ToString();
>
>   cleanFileName = ExpandFileName(cleanFileName);
>
>
>
>   fileName = prefix + cleanFileName;
>
>   }
>
>   else
>
>   {
>
>   fileName = ExpandFileName(fileName);
>
>   }
>
>
> Maybe something similar is needed?
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] CEROD in System.Data.SQLite

[E. Timothy Uy]

I'm working on switching our custom build of System.Data.SQLite from our
custom build and am having problems opening a CEROD database. Going back
over our code, I see that I wrote in Open():

 // TU: Need to split out "cerod" prepend to filename before expandfilename

string pattern = "(:.*:)(.*)";

  Match m = Regex.Match(fileName, pattern);

  if (m.Groups.Count == 3)

  {

  string prefix = m.Groups[1].ToString();

  string cleanFileName = m.Groups[2].ToString();

  cleanFileName = ExpandFileName(cleanFileName);



  fileName = prefix + cleanFileName;

  }

  else

  {

  fileName = ExpandFileName(fileName);

  }


Maybe something similar is needed?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users