Recent

« previous next »
Pages: [1] 2

Author Topic: Component to sdf file - Microsoft SQL Server database  (Read 2176 times)

Mi-Ki

  • Jr. Member
  • **
  • Posts: 74
Component to sdf file - Microsoft SQL Server database
« on: January 30, 2023, 04:05:45 pm »
Hi.
I can't do much in lazarus.
Can you help me please?

I've bought a piece of software that stores its database in an .sdf file
How to open a Lazarus database?


Need to open a database and load a table VAZENI

Here's the database **://leteckaposta.cz/486686910
Thank you very much.
« Last Edit: January 30, 2023, 05:51:54 pm by Mi-Ki »
Logged

wp

  • Hero Member
  • *****
  • Posts: 11912
Re: Component to access sdf database table
« Reply #1 on: January 30, 2023, 04:19:33 pm »
There is a TSDFDataset. Go to "Package" > "Install/uninstall packages" and make sure that package SDFLaz is installed.

Cannot download your database file. Why don't you zip it and attach it to your post? (If it's too large remove some lines - sdf is a text file).
Logged

Mi-Ki

  • Jr. Member
  • **
  • Posts: 74
Re: Component to access sdf database table
« Reply #2 on: January 30, 2023, 04:50:45 pm »
I'm sorry.
I almost deleted everything and has more tha 500 KB.
Logged

wp

  • Hero Member
  • *****
  • Posts: 11912
Re: Component to access sdf database table
« Reply #3 on: January 30, 2023, 04:55:37 pm »
No - this not the kind of SDF file that I mean since it is not a text file - forget my previous post. Which application did you use to write this file?

**s://filext.com/file-extension/SDF - Microsoft SQL Server Compact?
« Last Edit: January 30, 2023, 05:04:57 pm by wp »
Logged

Mi-Ki

  • Jr. Member
  • **
  • Posts: 74
Re: Component to access sdf database table
« Reply #4 on: January 30, 2023, 05:07:14 pm »
I bought the software that it stores in this file.
I opened the database in SDF Viewer 1.13.
**s://sdf-viewer.software.informer.com/St%C3%A1hnout/
**s://postimg.cc/c6dtkS5f

Can't Lazarus use for this file?   :(
« Last Edit: January 30, 2023, 05:22:04 pm by Mi-Ki »
Logged

wp

  • Hero Member
  • *****
  • Posts: 11912
Re: Component to access sdf database table
« Reply #5 on: January 30, 2023, 05:56:05 pm »
Quote from: Mi-Ki on January 30, 2023, 05:07:14 pm
Can't Lazarus use for this file?   :(
I tried to set up a connection with MSSQLConnection but failed due to a missing dll. But wait a bit, I am not an expert with MSSQL, maybe somebody else knows a solution.
Logged

Thaddy

  • Hero Member
  • *****
  • Posts: 14364
  • Sensorship about opinions does not belong here.
Re: Component to sdf file - Microsoft SQL Server database
« Reply #6 on: January 30, 2023, 05:56:40 pm »
https://fileinfo.com/extension/sdf

Which one?

Note the microsoft version is deprecated for 10 years....
Logged
Object Pascal programmers should get rid of their "component fetish" especially with the non-visuals.

Mi-Ki

  • Jr. Member
  • **
  • Posts: 74
Re: Component to sdf file - Microsoft SQL Server database
« Reply #7 on: January 30, 2023, 06:02:48 pm »
Thaddy - I know, but we have the software that uses it.
They need to add data.
Logged

Sieben

  • Sr. Member
  • ****
  • Posts: 310
Re: Component to sdf file - Microsoft SQL Server database
« Reply #8 on: January 30, 2023, 06:11:55 pm »
This here site lists 4 free tools to view and even edit MS SQL Server CE *.sdf files. Since it dates from 2017 these might still be available.

« Last Edit: January 30, 2023, 06:27:14 pm by Sieben »
Logged
Lazarus 2.2.0, FPC 3.2.2, .deb install on Ubuntu Xenial 32 / Gtk2 / Unity7

Thaddy

  • Hero Member
  • *****
  • Posts: 14364
  • Sensorship about opinions does not belong here.
Re: Component to sdf file - Microsoft SQL Server database
« Reply #9 on: January 30, 2023, 06:13:31 pm »
Better to convert the lot to sqlite, ahum, maybe firebird, or standard database format.
In that case your bought library should help over an e.g. odbc connection and on a microsoft system.
Logged
Object Pascal programmers should get rid of their "component fetish" especially with the non-visuals.

Thaddy

  • Hero Member
  • *****
  • Posts: 14364
  • Sensorship about opinions does not belong here.
Re: Component to sdf file - Microsoft SQL Server database
« Reply #10 on: January 30, 2023, 06:14:45 pm »
Quote from: Sieben on January 30, 2023, 06:11:55 pm
This here site lists 4 free tools to view and even edit *.sdf files. Since it dates from 2017 these might still be available.
sdf files lead to confusion because the extension name is not very carefully chosen. Such files are likely to represent different things.

More or less like the imaginary Thaddy's Xenophobic Trauma format.. (txt extension would be nice....)  %)  :o
And no, no driver for that. Maybe you can read it but I won't let you!! Go away...  O:-)
« Last Edit: January 30, 2023, 06:29:00 pm by Thaddy »
Logged
Object Pascal programmers should get rid of their "component fetish" especially with the non-visuals.

Mi-Ki

  • Jr. Member
  • **
  • Posts: 74
Re: Component to sdf file - Microsoft SQL Server database
« Reply #11 on: January 30, 2023, 06:50:33 pm »
Logged

Thaddy

  • Hero Member
  • *****
  • Posts: 14364
  • Sensorship about opinions does not belong here.
Re: Component to sdf file - Microsoft SQL Server database
« Reply #12 on: January 30, 2023, 06:58:44 pm »
Quote from: Mi-Ki on January 30, 2023, 06:50:33 pm
What is this?
**s://www.youtube.com/watch?v=pq2oCiJePHo

NOT the Microsoft format but the Standard Database Format.... You really do not grasp it, do you?

YOUR SDF is Microsoft specific. SDF is a text based format for the normal people.

Also note the dead giveaway: MSSQL is never mentioned.
Logged
Object Pascal programmers should get rid of their "component fetish" especially with the non-visuals.

Mi-Ki

  • Jr. Member
  • **
  • Posts: 74
Re: Component to sdf file - Microsoft SQL Server database
« Reply #13 on: January 30, 2023, 07:07:43 pm »
You confuse the truth, I don't understand. I've never done with the database before.
So is it unsolvable through Lazarus?
Logged

paweld

  • Hero Member
  • *****
  • Posts: 991
Re: Component to sdf file - Microsoft SQL Server database
« Reply #14 on: January 30, 2023, 07:40:51 pm »
Devart's SDAC component suite has the ability to connect to SQL Server Compact - these are paid components:  https://www.devart.com/sdac/
Logged
Best regards / Pozdrawiam
paweld
Pages: [1] 2
« previous next »
 

TinyPortal © 2005-2018