VFP ·R¥ÎªÌªÀ°Ï ­º­¶ VFP ·R¥ÎªÌªÀ°Ï
¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
 
 ±`¨£°ÝÃD±`¨£°ÝÃD   ·j´M·j´M   ·|­û¦Cªí·|­û¦Cªí   ·|­û¸s²Õ·|­û¸s²Õ   ·|­ûµù¥U·|­ûµù¥U 
 ­Ó¤H¸ê®Æ­Ó¤H¸ê®Æ   µn¤JÀˬd±zªº¨p¤H°T®§µn¤JÀˬd±zªº¨p¤H°T®§   µn¤Jµn¤J

Firebird-VFP & Embedded server¦w¸Ë¡þ¨Ï¥Î»¡©ú

 
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> SQL °Q½×°Ï
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD  
µoªí¤H ¤º®e
goto-dream



µù¥U®É¶¡: 2004-05-11
¤å³¹: 909


²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤C¤ë 14, 2004 1:14 pm    ¤å³¹¥DÃD: Firebird-VFP & Embedded server¦w¸Ë¡þ¨Ï¥Î»¡©ú ¤Þ¨¥¦^ÂÐ

FirebirdSQL WiKi
http://wiki.sunyear.com.tw/index.php?page=FirebirdSQL


¨Ï¥Î¸ê®Æ®wª©¥»¡G Firebird-1.5.0.4290_embed_win32



Embedded server¦w¸Ë¡þ¨Ï¥Î»¡©ú¡G

Registry:µL»Ýµù¥U Registry ¡A®wÀɪº¥Ø¿ý´N¬O¤º¸m¦øªA¾¹ªº¥Ø¿ý¡C
¸ê®Æ³X°Ý:¥u¯à¥»¦a¨Ï¥Î¡A¤º¸m¦øªA¾¹¤£¤ä´©»·ºÝ¦s¨úªº¨ó©w¡A³slocalhost³£¤£¯à¨Ï¥Î¡C
³\¥iÅv»P¦w¥þ:¦w¥þ¸ê®ÆÀÉ®×security.fdb¨S¦³¨Ï¥Î¡C¦ý¬Oª`·N, SQLªº°õ¦æ³\¥iÅv¤´·|³QÀˬd.
¬Û®e©Ê:§A¥i¥H¦P®É¹B¦æ¦h­Ó¨Ï¥Î¤º¸m¦øªA¾¹ª©¥»ªºÀ³¥Îµ{¦¡¡A¦Ó¤£·|¦³½Ä¬ð¡C
¦³IB/FB¦øªA¾¹ª©ªºÀ³¥Îµ{¦¡¤]¤@¼Ë¤£·|¦³°ÝÃD¡C¦ý¬O¹ï©ó¨Ï¥Î¤º¸m¦øªA¾¹ª©¥»ªºÀ³¥Îµ{¦¡¡A
¤£­n¦h­ÓÀ³¥Îµ{¦¡¦P®É³X°Ý¤@­Ó¸ê®ÆÀɮסA¦]¬°¤º¸m¦øªA¾¹ª©ªºµ{¦¡µ²ºc»P¦øªA¾¹ª©¤@¼Ë¡A
¦ý¬O¥¦¨Ï¥Î¿W¦ûÂê¨Ó³X°Ý¸ê®Æ®w¡C

¥Îªk¡G
½Æ»sgds32.dll©Mfbembed.dll(ª`·N¬O¤º¸m¦øªA¾¹ª©¥»ªº)¨ìÀ³¥Îµ{¦¡¥Ø¿ý¤U¡A
§âfbembed.dll§ï¦W¬°fbclient.dllµM«á´N¥i¥Hª½±µ³X°Ýfirebirdªº¸ê®Æ®wÀɤF¡C
( ª½±µ§ï¬°gds32.dll¤]¥i¥HWink

¦pªG»Ý­n¨Ï¥Î¤@¨Ç¥~³¡®wªº¤ä«ù¡A¤ñ¦p¡GINTL ¤ä´©¨ç¦¡®w (fbintl.dll) ©Î UDF®w¡A
¥²¶·§â¥¦­Ì¤À§O©ñ¦b¦U¦Ûªº¥Ø¿ý¡A´N¹³¦øªA¾¹ª©¤@¼Ë¡AµM«á³]¸m¦nfirebird.confÀɤ¤
ªº®Ú¥Ø¿ý(RootDirectory)¬°¤º¸m¦øªA¾¹ª©ªº©Ò¦b¥Ø¿ý§Y¥i¡C

¤U­±¬O¤@­Ó¨Ò¤l¡A¨Ï¥Î¤º¸m¦øªA¾¹ª©ªºÀ³¥Îµ{¦¡ªºÀɵ²ºc¦p¤U¡G

/myapp/app.exe

/myapp/fb15/gds32.dll

/myapp/fb15/firebird.conf

/myapp/fb15/firebird.msg

/myapp/fb15/intl/fbintl.dll

/myapp/fb15/udf/fbudf.dll

firebird.confÀɪº¤º®e:

RootDirectory = /myapp/fb15
--------------------------------------------------------------------------------

»Ý­nª`·Nªº¬O¡A³Ì¦n¨Ï¥Îhttp://sourceforge.net/project/showfiles.php?group_id=9028&release_id=152919

¤W¥¿¦¡µo§Gªºª©¥»¡A¤£µMªº¸Ü¡A¥i¯à¦s¦bµLªk¥¿±`¨Ï¥Îªº¥i¯à¡C

_________________
ºÖ¶©©÷²b¤ô¦³­­¤½¥q--²b¤ô¾¹ªº±M®a,²b¤ô¾¹,¶¼¤ô¾÷,Âo¤ß!!

·Q¤F¸Ñ§ó¦h¡A±z¥i¤W©¯ºÖÂû´ö²Õ.§ä´M!!¤BæXÞ±.¦Ñ®v.

¡@¡@¡@¡@¡@¡@¡@¡@¡@¡@·R§@¹Ú
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
goto-dream



µù¥U®É¶¡: 2004-05-11
¤å³¹: 909


²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤C¤ë 14, 2004 10:23 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

²Ä¤G¨BÆJ½T©wFirebirdSQL ODBC Driver¬O§_¦³¦w¸Ë¡A¨S¦³¸É¤W¥h¡D
³o­Ó¬O±Ä¥Î§å¦¸Àɮצw¸Ëªº.
§Ú¦bµ{¦¡ªº©I¥s¸ô®|¤W³]¸m¦³·å²«.·|¾É­Pµ{¦¡µLªk¨Ï¥Î.
­×¥¿«Ü®e©öªº.µ¹¦U¦ì¤U¸üªº¤H·í§@¬O²ßÃD§a!!

_________________
ºÖ¶©©÷²b¤ô¦³­­¤½¥q--²b¤ô¾¹ªº±M®a,²b¤ô¾¹,¶¼¤ô¾÷,Âo¤ß!!

·Q¤F¸Ñ§ó¦h¡A±z¥i¤W©¯ºÖÂû´ö²Õ.§ä´M!!¤BæXÞ±.¦Ñ®v.

¡@¡@¡@¡@¡@¡@¡@¡@¡@¡@·R§@¹Ú
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
a903



µù¥U®É¶¡: 2004-07-27
¤å³¹: 1


²Ä 3 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤C¤ë 30, 2004 9:30 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¦bClientºÝ¤w¦w¸Ë OdbcJdbcSetup «á,¦b ±±¨î¥x->¸ê®Æ¨Ó·½ODBC->¨Ï¥ÎªÌ¸ê®Æ¨Ó·½¦WºÙ,·s¼W"FireBird ODBC Setup"®É,¤U¦CÄæ¦ì­n«ç»ò³] ?

DSN:
DataBase:
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
goto-dream



µù¥U®É¶¡: 2004-05-11
¤å³¹: 909


²Ä 4 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤C¤ë 30, 2004 11:55 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

§A¦³¤U†^­ì©l‡ù…º¡H
­n¤£µMªº†O.§A®Ú¥»¤£…Ñ¥hƒô„±ƒªƒô‹_ªº.
µ{¦¡¤w…î‰Ö§A°µ¦n¤F¡ã¡ã

_________________
ºÖ¶©©÷²b¤ô¦³­­¤½¥q--²b¤ô¾¹ªº±M®a,²b¤ô¾¹,¶¼¤ô¾÷,Âo¤ß!!

·Q¤F¸Ñ§ó¦h¡A±z¥i¤W©¯ºÖÂû´ö²Õ.§ä´M!!¤BæXÞ±.¦Ñ®v.

¡@¡@¡@¡@¡@¡@¡@¡@¡@¡@·R§@¹Ú
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
Ruey



µù¥U®É¶¡: 2003-03-12
¤å³¹: 1698
¨Ó¦Û: tunglo

²Ä 5 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤C¤ë 29, 2005 4:02 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

a903 ¼g¨ì:
¦bClientºÝ¤w¦w¸Ë OdbcJdbcSetup «á,¦b ±±¨î¥x->¸ê®Æ¨Ó·½ODBC->¨Ï¥ÎªÌ¸ê®Æ¨Ó·½¦WºÙ,·s¼W"FireBird ODBC Setup"®É,¤U¦CÄæ¦ì­n«ç»ò³] ?

DSN:
DataBase:


1.¤£¥Î³]©w....
©p½Ð¸ÑÀ£ÁY¨ìD:

µ{¦¡³Ì¦n©ñ¨ì D:\MyAPP
¤~·|¦¨¥\.....
¦]¬°dsn odbc¦bµ{¦¡¤¤.³]¦º¤F....

¥N½X:
DSN=fb;
DRIVER={OdbcJdbc};
DBNAME=D:\MyAPP\myapp.fdb;
UID=SYSDBA;PWD=masterkey


2.¦w¸ËODBC DRIVER
D:\MYAPPFB15\Setup_ODBC.bat

3.°õ¦æMYAPP

_________________
#############################
§Ö¼Ö¶ý«}¨t¦C©¯ºÖ¦v°t,³Ü¤Q¥þÂû´ö~­ì¨Ó©¯ºÖ¨º»ò²³æ!!

¾Ç·|VFP¨Ï¥ÎªÌªÀ°Ïªº·j´M,Code¤~·|§ó¦³½ì~
#############################


Ruey ¦b ¬P´Á¤­ ¤C¤ë 29, 2005 6:53 pm §@¤F²Ä 1 ¦¸­×§ï
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
syntech



µù¥U®É¶¡: 2003-05-16
¤å³¹: 4211
¨Ó¦Û: Taipei,Taiwan

²Ä 6 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤C¤ë 29, 2005 4:19 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¬Û¹j¤@¦~ªº¦^À³..... Smile
_________________
¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊ­p¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý

½ÐÁpµ¸§Ú­Ì,¤]³\§Ú­ÌÀ°±o¤W¦£
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó AIM Address
Ruey



µù¥U®É¶¡: 2003-03-12
¤å³¹: 1698
¨Ó¦Û: tunglo

²Ä 7 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤C¤ë 29, 2005 4:23 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

­×¥¿ª©¥»....½Ð¤U¸ü~


§ó¥¿¶µ¥Ø:
¸ê®Æ®w¸ô®|¹w³]§ì¨ú¥Ø«e¸ô®|

_________________
#############################
§Ö¼Ö¶ý«}¨t¦C©¯ºÖ¦v°t,³Ü¤Q¥þÂû´ö~­ì¨Ó©¯ºÖ¨º»ò²³æ!!

¾Ç·|VFP¨Ï¥ÎªÌªÀ°Ïªº·j´M,Code¤~·|§ó¦³½ì~
#############################
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
Ruey



µù¥U®É¶¡: 2003-03-12
¤å³¹: 1698
¨Ó¦Û: tunglo

²Ä 8 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤C¤ë 29, 2005 4:43 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¥»¨Ó»Ý­n³]©wodbcªº....¦]¬°myapp¤w¸g¦³´£¨Ñµù¥U¤F...©Ò¥H²¤Æ¤âÄò

¤â°Êodbc³]©w¦p¤U

_________________
#############################
§Ö¼Ö¶ý«}¨t¦C©¯ºÖ¦v°t,³Ü¤Q¥þÂû´ö~­ì¨Ó©¯ºÖ¨º»ò²³æ!!

¾Ç·|VFP¨Ï¥ÎªÌªÀ°Ïªº·j´M,Code¤~·|§ó¦³½ì~
#############################
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
goto-dream



µù¥U®É¶¡: 2004-05-11
¤å³¹: 909


²Ä 9 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤Q¤@¤ë 21, 2008 1:25 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¸ô®|§ó·s//

³o­Ó¥i¥H»s§@ ÀH¨­ºÐª©¥»!!
¦pªGµ{¦¡¬Oc/sªº.¤£¥ÎÅܰʤӤj

_________________
ºÖ¶©©÷²b¤ô¦³­­¤½¥q--²b¤ô¾¹ªº±M®a,²b¤ô¾¹,¶¼¤ô¾÷,Âo¤ß!!

·Q¤F¸Ñ§ó¦h¡A±z¥i¤W©¯ºÖÂû´ö²Õ.§ä´M!!¤BæXÞ±.¦Ñ®v.

¡@¡@¡@¡@¡@¡@¡@¡@¡@¡@·R§@¹Ú
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
goto-dream



µù¥U®É¶¡: 2004-05-11
¤å³¹: 909


²Ä 10 ¼Ó

µoªíµoªí©ó: ¬P´Á¤é ¤Q¤@¤ë 23, 2008 11:24 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

Firebird Embedded Server ¤w¸g¥X¨ì 2.0¤F
­nªº¤H¨ì³o¸Ì¤U¸ü
http://www.firebirdsql.org/index.php?op=files&id=engine_211

_________________
ºÖ¶©©÷²b¤ô¦³­­¤½¥q--²b¤ô¾¹ªº±M®a,²b¤ô¾¹,¶¼¤ô¾÷,Âo¤ß!!

·Q¤F¸Ñ§ó¦h¡A±z¥i¤W©¯ºÖÂû´ö²Õ.§ä´M!!¤BæXÞ±.¦Ñ®v.

¡@¡@¡@¡@¡@¡@¡@¡@¡@¡@·R§@¹Ú
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
goto-dream



µù¥U®É¶¡: 2004-05-11
¤å³¹: 909


²Ä 11 ¼Ó

µoªíµoªí©ó: ¬P´Á¤G ¤Q¤G¤ë 02, 2008 10:57 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

µ{¦¡¥]§tfirebird embedded 1.5(4MB)/2.0(10MB)À³¥Î
°ß¦³odbc³¡¤À¥þ³¡§ï¦¨2.0,¤è«Kµo¥¬


µ{¦¡¤¤¥u»Ý­n°Ê¨ì
1.ODBC³]©w
setDSN("fb","",thisform.txtDb_Path1.value, gc_SYSPATH+"fb2\")

2.³s½u¦r¦ê
TEXT to lc_ConnectString TextMerge NoShow
DSN=fb;
DRIVER={OdbcJdbc};
DBNAME=<<gc_SYSPATH>>\myapp.fdb;
UID=SYSDBA;PWD=masterkey
ENDTEXT

_________________
ºÖ¶©©÷²b¤ô¦³­­¤½¥q--²b¤ô¾¹ªº±M®a,²b¤ô¾¹,¶¼¤ô¾÷,Âo¤ß!!

·Q¤F¸Ñ§ó¦h¡A±z¥i¤W©¯ºÖÂû´ö²Õ.§ä´M!!¤BæXÞ±.¦Ñ®v.

¡@¡@¡@¡@¡@¡@¡@¡@¡@¡@·R§@¹Ú
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
±q¤§«eªº¤å³¹¶}©lÅã¥Ü:   
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> SQL °Q½×°Ï ©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
²Ä1­¶(¦@1­¶)

 
«e©¹:  
±z µLªk ¦b³o­Óª©­±µoªí¤å³¹
±z µLªk ¦b³o­Óª©­±¦^ÂФ峹
±z µLªk ¦b³o­Óª©­±½s¿è¤å³¹
±z µLªk ¦b³o­Óª©­±§R°£¤å³¹
±z µLªk ¦b³o­Óª©­±¶i¦æ§ë²¼
±z µLªk ¦b³o­Óª©­±ªþ¥[ÀÉ®×
±z µLªk ¦b³o­Óª©­±¤U¸üÀÉ®×


Powered by phpBB © 2001, 2005 phpBB Group
¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@