Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2007-08-01 : 01:29:04
|
| Hi guys,We have a new project that involves Finger Scanning. We have the device for the scanning but we need to develop our own interface and database using MS SQL Server.What kind of data type are we going to use in order to save the Finger-scanned-image ?How will I search the input finger-scanned ?Thank you very much. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-08-01 : 01:44:06
|
| there have to be APIs/SDKs for stuff like this that you can use to get jump started. EDIT:I just googled that and it came up with a dozen hits for different API/SDK products. this seems like a better approach than rolling the whole thing yourself.-ec |
 |
|
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2007-08-01 : 02:13:27
|
| Thank you.so what type of API dll will I use ? GDI32.DLL ? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-01 : 02:28:02
|
Normally you should use BINARY(x) to save the data.But as in all cases, it depends on the manufacturer.Read the manual for your product. E 12°55'05.25"N 56°04'39.16" |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-08-03 : 16:02:14
|
quote: Originally posted by rpc86 Thank you.so what type of API dll will I use ? GDI32.DLL ?
API doesn't mean "DLL provided as part of Windows". It stands for "Application Programming Interface", which means it's a way that the vendor of the hardware/software provides for you to interact with it programmatically.The answer to your question is that you need to check with the manufacturer of your scanner to see what the available APIs are and what format the scanner will provide data in; you can then decide how to handle them in SQL Server (store the scan as binary data in a column, or save the scan as a separate file on disk and store the fully qualified pathname to the file in your database, for example). |
 |
|
|
|
|
|