How store ultralite10's database file(.udb file) in wince emulator's store card?
i use ultralite10(develop version) in vs2005 with wm5.0 emulator. i find i can't store .udb file in emulatotr store card.it will make a "SQLE_MEMORY_ERROR", why happened this? what should i do so i can may the .udb file in emulator's store card?
|
0 |
|
jia
9/17/2007 10:29:32 AM
sybase.sqlanywhere.ultralite
2982 articles. 
0 followers.
3 Replies
774 Views
We haven't had any issues with this. You can post more details about how you attempted to connect or open a tech support case Mike
|
|
0 |
|
Michael
9/24/2007 2:36:57 PM
> We haven't had any issues with this. You can post more
> details about how you attempted to connect or open a tech
> support case
>
> Mike
>
>
the connect function is this:
string path = @"\sync.udb";
try
{
ULConnectionParms openParms = new
ULConnectionParms();
string CodePath =
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase;
path = CodePath.Substring(0,
CodePath.LastIndexOf(@"\"));
//path = @"\Storage Card";
//open connect syncConn
openParms.DatabaseOnCE = path +
@"\sync.udb";
openParms.UserID = "user";
openParms.Password = "AxA2519eAB";
openParms.EncryptionKey = "AxA2519eAB";
openParms.CacheSize = "256k";
syncConn = new ULConnection();
syncConn.ConnectionString =
openParms.ToString();
if
(!syncConn.State.ToString().Equals("Open",
StringComparison.CurrentCultureIgnoreCase))
syncConn.Open();
syncConn.DatabaseID = 1;
//open connect premConn
openParms.DatabaseOnCE = path +
@"\premium.udb";
openParms.UserID = "user";
openParms.Password = "AxA2519eAB";
openParms.EncryptionKey = "AxA2519eAB";
openParms.CacheSize = "256k";
premConn = new ULConnection();
premConn.ConnectionString =
openParms.ToString();
if
(!premConn.State.ToString().Equals("Open",
StringComparison.CurrentCultureIgnoreCase))
premConn.Open();
premConn.DatabaseID = 1;
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Message);
}
when i change path as "\Storage Card",it will cause the
exception as 'SQLE_MERROR_ERROR'
|
|
0 |
|
jia
9/25/2007 7:12:56 AM
I don't see what the problem could be. You could try using a non-encrypted
database to see if that might be the problem. Other than that I suggest you
open a tech support case to get further help.
Mike
<jia> wrote in message news:46f8b4f8.26e2.1681692777@sybase.com...
>> We haven't had any issues with this. You can post more
>> details about how you attempted to connect or open a tech
>> support case
>>
>> Mike
>>
>>
> the connect function is this:
> string path = @"\sync.udb";
> try
> {
> ULConnectionParms openParms = new
> ULConnectionParms();
> string CodePath =
> System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase;
> path = CodePath.Substring(0,
> CodePath.LastIndexOf(@"\"));
> //path = @"\Storage Card";
> //open connect syncConn
> openParms.DatabaseOnCE = path +
> @"\sync.udb";
> openParms.UserID = "user";
> openParms.Password = "AxA2519eAB";
> openParms.EncryptionKey = "AxA2519eAB";
>
> openParms.CacheSize = "256k";
>
> syncConn = new ULConnection();
> syncConn.ConnectionString =
> openParms.ToString();
> if
> (!syncConn.State.ToString().Equals("Open",
> StringComparison.CurrentCultureIgnoreCase))
> syncConn.Open();
> syncConn.DatabaseID = 1;
>
> //open connect premConn
> openParms.DatabaseOnCE = path +
> @"\premium.udb";
> openParms.UserID = "user";
> openParms.Password = "AxA2519eAB";
> openParms.EncryptionKey = "AxA2519eAB";
>
> openParms.CacheSize = "256k";
>
> premConn = new ULConnection();
> premConn.ConnectionString =
> openParms.ToString();
> if
> (!premConn.State.ToString().Equals("Open",
> StringComparison.CurrentCultureIgnoreCase))
> premConn.Open();
> premConn.DatabaseID = 1;
>
> }
> catch (Exception e)
> {
>
> System.Diagnostics.Debug.WriteLine(e.Message);
> }
>
> when i change path as "\Storage Card",it will cause the
> exception as 'SQLE_MERROR_ERROR'
|
|
0 |
|
Michael
9/26/2007 3:30:20 PM
Similar Artilces:
write binary files from the Web server's file system and store database
hi , please help i have phiscal file in web server how can store this file in table in database. i want to convert file to byts. i dont want to use file upload. I assume you have a table with a image datatype column. I also assume the same table has a filename-column. This snippet of code inserts a physical file into a database column of datatype binary: Private Function saveInDB(ByVal physicalFilename As String) As BooleanDim f As New IO.FileInfo(physicalFilename)If f.Exists ThenDim fs As System.IO.FileStream = System.IO.File.OpenRead(physicalFilename)Dim a(fs.Length - 1) As ...
superreview granted: [Bug 361730] Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length : [Attachment 246709] biesi's proposal
Scott MacGregor <mscott@mozilla.org> has granted David Bienvenu <bienvenu@nventure.com>'s request for superreview: Bug 361730: Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length https://bugzilla.mozilla.org/show_bug.cgi?id=361730 Attachment 246709: biesi's proposal https://bugzilla.mozilla.org/attachment.cgi?id=246709&action=edit ...
superreview requested: [Bug 361730] Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length : [Attachment 246709] biesi's proposal
David Bienvenu <bienvenu@nventure.com> has asked Scott MacGregor <mscott@mozilla.org> for superreview: Bug 361730: Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length https://bugzilla.mozilla.org/show_bug.cgi?id=361730 Attachment 246709: biesi's proposal https://bugzilla.mozilla.org/attachment.cgi?id=246709&action=edit ...
Open file in browser or application getting the page's name as the file's name
Hi, I'm am trying to get a file to open in either a browser or application depending on the mime type. I'am using the following code in the page load. protected void Page_Load(object sender, EventArgs e){ if (!IsPostBack) { DocumentInfo document = (DocumentInfo)Session["View_Document"]; StreamFile(document.Document, document.DocumentName, document.FileType.MimeType); } } }private void StreamFile(byte[] fileData, string originalFileName, string mimeType) { try { Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("Con...
Can I use UL9's ActiveX component to open UL7's database file?
UltraLite components require schema information in the database (8.0.2 and later). Also, as of 9.0.0, UltraLite's ActiveX component on the desktop works with Unicode databases. Palm database files are still ANSI and Windows CE database files are still Unicode. If you are synchronizing, synchronize the old app, create a schema file with ulinit and then write your ActiveX app and synchronize it. Otherwise, for a Palm, Windows CE or unicode desktop database file: To move to 9.0.0 or later, you would have to: 1. Backup your database file just in case. 2. Modify your 7...
Where There's Data Stored, There's A Risk
"BUSINESSES THROUGHOUT THE REGION THAT handle large amounts of personal information have found one sure-fire way of avoiding security breaches: collect less data."... <http://www.theday.com/re.aspx?re=f34df362-157f-43fd-a990-77ba17fa54b9> or http://preview.tinyurl.com/253a5y -- js http://justheadlines.awardspace.com ...
Storing jpg's as BLOB's
Using PB 7.0.3 with an Oracle 7.3 database, storing .jpg's as BLOBs, defined as long raw in the database. When storing the images in the database, I get a page fault error, and the program crashes. Through some testing, I discoverd that if I use Adobe Photo Shop, and save the images as 'Web Enabled', they work fine. Numerous other graphics packages all cause the page fault error. This does not appear to relate to the size of the image, as I have succesfully loaded Adobe PS images over 100k with no problem, but 30k images from other packages cause the problem. If I use...
stored proc's and output param's
Hi all I've got a TSQL stored proc (on SQL Anywhere) with several output parameters that I'm trying to execute from PowerScript. Procedure header looks like this: alter procedure spt_test(@in1 int, @in2 int, @out1 int output, @out2 int output, @out3 int output) (It does not return anything, just puts values into the out-var's) Now, in PB I have used the following: declare spt_test procedure for spt_test @in1 = :li_var1, @in2 = :li_var2, @out1 = :li_var3, @out2 = :li_var4, @out3 = :li_var5; execute spt_test; messagebox('result', string(SQLCA....
What's witht the .exe's when dling a file
I was downloading a debial iso to a directory in my E: drive. In the middle of it I got a popup saying that my C: drive was filled and that there wasn't room for an [somerandomlookingstring].exe there. Why is moz creating an exe for a download? -- Mark Heaely marknews(at)healeyonline(dot)com On 03/10/27 22:50 Mark Healey apparently typed: > I was downloading a debial iso to a directory in my E: drive. In > the middle of it I got a popup saying that my C: drive was filled and > that there wasn't room for an [somerandomlookingstring].exe there. Unless your ...
Replace 1's and 0's in a gridview column with Yes's and No's
Is it possible to change the display of a column in a gridview to show a Yes for all 1's and a No for 0's that display in a particular column of a gridview bound to a database? If so, can someone share the way with me? I am using ASP.NET 2.0 with VB Code Behind. Thanks One way you can do is thrrough CASE in your select statement: Select YesNoColumn= CASE yourColumn WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' ELSE '' END FROM YourtableLimno <Columns> <asp:TemplateField HeaderText="yourHeader" SortExpression="yourDataField"> ...
It's Linux !? No, it's BSD ! No, no, it's...
kFreeBSD http://wiki.debian.org/Debian_GNU/kFreeBSD a Debian distro using the FreeBSD kernel ! ObiWan wrote: > kFreeBSD > > http://wiki.debian.org/Debian_GNU/kFreeBSD > > a Debian distro using the FreeBSD kernel ! Why use a BSD kernel? I hope the reason is more than, just because they can. http://wiki.debian.org/Debian_GNU/kFreeBSD_why It's easy to understand why the would want to use Debian packages. :) -- Jimmy Johnson Registered Linux User #380263 >> kFreeBSD >> >> http://wiki.debian.org/Debian_GNU/kFreeBSD >> ...
how to control a RadioButtonList's Listitem's text show according database's field
Hi my page has a repeater control,in repeater has a RadioButtonList control now i want to let the RadioButtonList has four Listitem,every Listitem's text is a database's field so the listitem can show dynamic according every record how can i work out my problem thanks a lot hello dearbound your RadioButtonList to database if i m not clear fell free 4 replySatyabrat SinghB.E.(C.Sc.)Web developer Livetek Solution Dont forget to click "Mark as Answer" on the post that helped you. yes.i bound the radiobuttonlist to a dataset but how to display the ...
Needed List of RunTime File's / DLL's.
Can someone give me the list of needed Runtime File's / DLL's needed for PB7 applications. Thanks. Refer to the following Sybase info: <http://www.sybase.com/content/1001114/deploymentinfo.pdf> //Martin "DJD" <djd@str.org> wrote in message news:#6Ke$1CeBHA.346@forums.sybase.com... > Can someone give me the list of needed Runtime File's / DLL's needed for PB7 > applications. > > Thanks. > > Go here, it lists them all: http://manuals.sybase.com/onlinebooks/group-pb/pbg0702e/apptech/@Generic__BookView Acco...
Is it possible to read folder's and file's properties over HTTP?
I am building a scraper, and do you know if it is possible to read folder's properties (like last time it was updates?) www.blahblasite.com/foldername How can I tell when the last time was that [/foldername] was updated? And is there any way I can read all of the image files in that directory, without knowing names of those image files? And also read their properties? Hi,Q1:Such properties can be accessed like this:System.IO.DirectoryInfo di = new System.IO.DirectoryInfo("directory path"); datetime lastwt = di.LastWriteTime;Q2:You can use System.IO.Directo...
hi , please help i have phiscal file in web server how can store this file in table in database. i want to convert file to byts. i dont want to use file upload. I assume you have a table with a image datatype column. I also assume the same table has a filename-column. This snippet of code inserts a physical file into a database column of datatype binary: Private Function saveInDB(ByVal physicalFilename As String) As BooleanDim f As New IO.FileInfo(physicalFilename)If f.Exists ThenDim fs As System.IO.FileStream = System.IO.File.OpenRead(physicalFilename)Dim a(fs.Length - 1) As ...
superreview granted: [Bug 361730] Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length : [Attachment 246709] biesi's proposal
Scott MacGregor <mscott@mozilla.org> has granted David Bienvenu <bienvenu@nventure.com>'s request for superreview: Bug 361730: Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length https://bugzilla.mozilla.org/show_bug.cgi?id=361730 Attachment 246709: biesi's proposal https://bugzilla.mozilla.org/attachment.cgi?id=246709&action=edit ...
superreview requested: [Bug 361730] Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length : [Attachment 246709] biesi's proposal
David Bienvenu <bienvenu@nventure.com> has asked Scott MacGregor <mscott@mozilla.org> for superreview: Bug 361730: Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length https://bugzilla.mozilla.org/show_bug.cgi?id=361730 Attachment 246709: biesi's proposal https://bugzilla.mozilla.org/attachment.cgi?id=246709&action=edit ...
Open file in browser or application getting the page's name as the file's name
Hi, I'm am trying to get a file to open in either a browser or application depending on the mime type. I'am using the following code in the page load. protected void Page_Load(object sender, EventArgs e){ if (!IsPostBack) { DocumentInfo document = (DocumentInfo)Session["View_Document"]; StreamFile(document.Document, document.DocumentName, document.FileType.MimeType); } } }private void StreamFile(byte[] fileData, string originalFileName, string mimeType) { try { Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("Con...
Can I use UL9's ActiveX component to open UL7's database file?
UltraLite components require schema information in the database (8.0.2 and later). Also, as of 9.0.0, UltraLite's ActiveX component on the desktop works with Unicode databases. Palm database files are still ANSI and Windows CE database files are still Unicode. If you are synchronizing, synchronize the old app, create a schema file with ulinit and then write your ActiveX app and synchronize it. Otherwise, for a Palm, Windows CE or unicode desktop database file: To move to 9.0.0 or later, you would have to: 1. Backup your database file just in case. 2. Modify your 7...
Where There's Data Stored, There's A Risk
"BUSINESSES THROUGHOUT THE REGION THAT handle large amounts of personal information have found one sure-fire way of avoiding security breaches: collect less data."... <http://www.theday.com/re.aspx?re=f34df362-157f-43fd-a990-77ba17fa54b9> or http://preview.tinyurl.com/253a5y -- js http://justheadlines.awardspace.com ...
Storing jpg's as BLOB's
Using PB 7.0.3 with an Oracle 7.3 database, storing .jpg's as BLOBs, defined as long raw in the database. When storing the images in the database, I get a page fault error, and the program crashes. Through some testing, I discoverd that if I use Adobe Photo Shop, and save the images as 'Web Enabled', they work fine. Numerous other graphics packages all cause the page fault error. This does not appear to relate to the size of the image, as I have succesfully loaded Adobe PS images over 100k with no problem, but 30k images from other packages cause the problem. If I use...
stored proc's and output param's
Hi all I've got a TSQL stored proc (on SQL Anywhere) with several output parameters that I'm trying to execute from PowerScript. Procedure header looks like this: alter procedure spt_test(@in1 int, @in2 int, @out1 int output, @out2 int output, @out3 int output) (It does not return anything, just puts values into the out-var's) Now, in PB I have used the following: declare spt_test procedure for spt_test @in1 = :li_var1, @in2 = :li_var2, @out1 = :li_var3, @out2 = :li_var4, @out3 = :li_var5; execute spt_test; messagebox('result', string(SQLCA....
What's witht the .exe's when dling a file
I was downloading a debial iso to a directory in my E: drive. In the middle of it I got a popup saying that my C: drive was filled and that there wasn't room for an [somerandomlookingstring].exe there. Why is moz creating an exe for a download? -- Mark Heaely marknews(at)healeyonline(dot)com On 03/10/27 22:50 Mark Healey apparently typed: > I was downloading a debial iso to a directory in my E: drive. In > the middle of it I got a popup saying that my C: drive was filled and > that there wasn't room for an [somerandomlookingstring].exe there. Unless your ...
Replace 1's and 0's in a gridview column with Yes's and No's
Is it possible to change the display of a column in a gridview to show a Yes for all 1's and a No for 0's that display in a particular column of a gridview bound to a database? If so, can someone share the way with me? I am using ASP.NET 2.0 with VB Code Behind. Thanks One way you can do is thrrough CASE in your select statement: Select YesNoColumn= CASE yourColumn WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' ELSE '' END FROM YourtableLimno <Columns> <asp:TemplateField HeaderText="yourHeader" SortExpression="yourDataField"> ...
It's Linux !? No, it's BSD ! No, no, it's...
kFreeBSD http://wiki.debian.org/Debian_GNU/kFreeBSD a Debian distro using the FreeBSD kernel ! ObiWan wrote: > kFreeBSD > > http://wiki.debian.org/Debian_GNU/kFreeBSD > > a Debian distro using the FreeBSD kernel ! Why use a BSD kernel? I hope the reason is more than, just because they can. http://wiki.debian.org/Debian_GNU/kFreeBSD_why It's easy to understand why the would want to use Debian packages. :) -- Jimmy Johnson Registered Linux User #380263 >> kFreeBSD >> >> http://wiki.debian.org/Debian_GNU/kFreeBSD >> ...
how to control a RadioButtonList's Listitem's text show according database's field
Hi my page has a repeater control,in repeater has a RadioButtonList control now i want to let the RadioButtonList has four Listitem,every Listitem's text is a database's field so the listitem can show dynamic according every record how can i work out my problem thanks a lot hello dearbound your RadioButtonList to database if i m not clear fell free 4 replySatyabrat SinghB.E.(C.Sc.)Web developer Livetek Solution Dont forget to click "Mark as Answer" on the post that helped you. yes.i bound the radiobuttonlist to a dataset but how to display the ...
Needed List of RunTime File's / DLL's.
Can someone give me the list of needed Runtime File's / DLL's needed for PB7 applications. Thanks. Refer to the following Sybase info: <http://www.sybase.com/content/1001114/deploymentinfo.pdf> //Martin "DJD" <djd@str.org> wrote in message news:#6Ke$1CeBHA.346@forums.sybase.com... > Can someone give me the list of needed Runtime File's / DLL's needed for PB7 > applications. > > Thanks. > > Go here, it lists them all: http://manuals.sybase.com/onlinebooks/group-pb/pbg0702e/apptech/@Generic__BookView Acco...
Is it possible to read folder's and file's properties over HTTP?
I am building a scraper, and do you know if it is possible to read folder's properties (like last time it was updates?) www.blahblasite.com/foldername How can I tell when the last time was that [/foldername] was updated? And is there any way I can read all of the image files in that directory, without knowing names of those image files? And also read their properties? Hi,Q1:Such properties can be accessed like this:System.IO.DirectoryInfo di = new System.IO.DirectoryInfo("directory path"); datetime lastwt = di.LastWriteTime;Q2:You can use System.IO.Directo...
Web resources about - How store ultralite10's database file(.udb file) in wince emulator's store card? - sybase.sqlanywhere.ultraliteResources last updated: 12/29/2015 3:22:22 AM