Investigate Unknown database file type?

hello guys,
i'm new on this forum, i got a file with .inn extension but have a problem while i want to access it. i've tried so many ways to access such that file.
The extension maybe masked by the developer for security reason, i try to change the extension to .dbf and .mdb to access it from odbc but still cannot access it.

please help me to investigate that file.
the file is included on the attachment

thanx in advance for all of your answer.

regards,
canfieldmysql innodb table?|||Perhaps Essbase Temporary Analytic Services index file?
Or Cobol/2 overlay?
(Found those two using Google service. Never heard about Essbase before ...)|||You may not be able to rescue this data.
The file seems to contain no data definitions (schema), therefore unless you have the originating program AND this program has some default/embedded definitions, then you maybe could access the data in this file.

Otherwise, it is useless to try and figure out data structures in a file which you do not have the design format.

:rolleyes:

Inverse -- Reverse

Hi,
I am not able to slove my problem so guys i need ur help.
i had (thousands) of records in my database in this manner.
Name Id
DFDDABBF-7079-4135-AAD8-1BDA58DB0CEB
Now i need the Nameid like below
BFABDDDF-7970-3541-AAD8-1BDA58DB0CEB
I need changes till 18 character started from left handside.
Thanx for ur help.
from
Dollerdoller
It is completely . Do you need to change/reverse only the left
side of the data?
It is not exactly what you wanted but if you explain what are you trying
to achive so we may suggets better solution
Anyway , I tried to give an idea.
CREATE TABLE #Test (col VARCHAR(50) NOT NULL)
INSERT INTO #Test VALUES ('DFDDABBF-7079-4135-AAD8-1BDA58DB0CEB')
SELECT REVERSE(col) FROM #Test
SELECT STUFF(col, 1, CHARINDEX('-',col), 'BFABDDDF-')
FROM #Test
"doller" <sufianarif@.gmail.com> wrote in message
news:1142831035.525419.135860@.t31g2000cwb.googlegroups.com...
> Hi,
> I am not able to slove my problem so guys i need ur help.
> i had (thousands) of records in my database in this manner.
> Name Id
> DFDDABBF-7079-4135-AAD8-1BDA58DB0CEB
>
> Now i need the Nameid like below
> BFABDDDF-7970-3541-AAD8-1BDA58DB0CEB
> I need changes till 18 character started from left handside.
> Thanx for ur help.
> from
> Doller
>|||SOrry if u got confuse
Given Data
DFDDABBF-7079-4135-AAD8-1BDA58DB0CEB (given Data)
Needs like below
BFABDDDF-7970-3541-AAD8-1BDA58DB0CEB
I dont know how to do this (not sure use reverse or inverse).
from
Doller|||Well, you will be better of doing such things on the client side
"doller" <sufianarif@.gmail.com> wrote in message
news:1142833372.212324.309310@.i39g2000cwa.googlegroups.com...
> SOrry if u got confuse
> Given Data
> DFDDABBF-7079-4135-AAD8-1BDA58DB0CEB (given Data)
> Needs like below
> BFABDDDF-7970-3541-AAD8-1BDA58DB0CEB
> I dont know how to do this (not sure use reverse or inverse).
> from
> Doller
>|||Hi Umi,'
Thanx for ur help . !ha|||Was it sarcasm?
"doller" <sufianarif@.gmail.com> wrote in message
news:1142833924.710613.158210@.v46g2000cwv.googlegroups.com...
> Hi Umi,'
> Thanx for ur help . !ha
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3kfDH%23SGHA.5172@.TK2MSFTNGP12.phx.gbl...
> Well, you will be better of doing such things on the client side
I don't see why it can't be done on the server. It looks like a maintenance
job to fix a bug in the app. A simple update statement could fix it pretty
quick.

>
> "doller" <sufianarif@.gmail.com> wrote in message
> news:1142833372.212324.309310@.i39g2000cwa.googlegroups.com...
>|||Hi umi,
Why u think like this man .Ha actually mean yes.
If u think i do then i am sorry.
from
Doller|||doller wrote on 19 Mar 2006 21:03:55 -0800:

> Hi,
> I am not able to slove my problem so guys i need ur help.
> i had (thousands) of records in my database in this manner.
> Name Id
> DFDDABBF-7079-4135-AAD8-1BDA58DB0CEB
> Now i need the Nameid like below
> BFABDDDF-7970-3541-AAD8-1BDA58DB0CEB
> I need changes till 18 character started from left handside.
> Thanx for ur help.
Assuming the strings are in Col1 of your table Table1
SELECT REVERSE(LEFT(Col1,8)) + '-' + REVERSE(SUBSTRING(Col1,10,4) + '-' +
REVERSE(SUBSTRING(Col2,16,4) + SUBSTRING(Col1,20,17)
FROM Table1
Dan|||I think you want something like this:
DROP TABLE #tmp
CREATE TABLE #tmp ( nameid VARCHAR(50) PRIMARY KEY )
INSERT INTO #tmp VALUES( 'DFDDABBF-7079-4135-AAD8-1BDA58DB0CEB' )
-- INSERT INTO #tmp VALUES( 'BFABDDDF-7970-3541-AAD8-1BDA58DB0CEB' )
SELECT nameid,
SUBSTRING( nameid, 7, 2 ) +
SUBSTRING( nameid, 5, 2 ) +
SUBSTRING( nameid, 3, 2 ) +
SUBSTRING( nameid, 1, 2 ) +
SUBSTRING( nameid, 9, 1 ) +
SUBSTRING( nameid, 12, 2 ) +
SUBSTRING( nameid, 10, 2 ) +
SUBSTRING( nameid, 14, 1 ) +
SUBSTRING( nameid, 17, 2 ) +
SUBSTRING( nameid, 15, 2 ) +
SUBSTRING( nameid, 19, 18 )
FROM #tmp
Lookup using SUBSTRING, LEFT, RIGHT, REPLACE and STUFF in the SQL Help.
Let me know how you get on.
Damien
"doller" wrote:

> Hi,
> I am not able to slove my problem so guys i need ur help.
> i had (thousands) of records in my database in this manner.
> Name Id
> DFDDABBF-7079-4135-AAD8-1BDA58DB0CEB
>
> Now i need the Nameid like below
> BFABDDDF-7970-3541-AAD8-1BDA58DB0CEB
> I need changes till 18 character started from left handside.
> Thanx for ur help.
> from
> Doller
>

interoperability bw SQL mobile and j2me application

Hi

guys.

Is it possible to interoperate between SQL mobile and applications developed in j2me?

I need my application in j2me to perorm the basic database operations in sql mobile db.

Please advise

Thanks

Not unless somebody implemented whatever interface J2ME uses for databases (JDBC?) for SQL CE or J2ME now supports OLEDB (and COM in general).