¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 1 ¼Ó
|
µ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¥H
¦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§@¹Ú |
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 2 ¼Ó
|
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
a903
µù¥U®É¶¡: 2004-07-27 ¤å³¹: 1
²Ä 3 ¼Ó
|
µ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: |
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 4 ¼Ó
|
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
Ruey
µù¥U®É¶¡: 2003-03-12 ¤å³¹: 1698 ¨Ó¦Û: tunglo
²Ä 5 ¼Ó
|
µ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 ¦¸×§ï |
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤C¤ë 29, 2005 4:19 pm ¤å³¹¥DÃD: |
|
|
¬Û¹j¤@¦~ªº¦^À³..... ![Smile](images/smiles/icon_smile.gif) _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
Ruey
µù¥U®É¶¡: 2003-03-12 ¤å³¹: 1698 ¨Ó¦Û: tunglo
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤C¤ë 29, 2005 4:23 pm ¤å³¹¥DÃD: |
|
|
×¥¿ª©¥»....½Ð¤U¸ü~
§ó¥¿¶µ¥Ø:
¸ê®Æ®w¸ô®|¹w³]§ì¨ú¥Ø«e¸ô®| _________________ #############################
§Ö¼Ö¶ý«}¨t¦C©¯ºÖ¦v°t,³Ü¤Q¥þÂû´ö~ì¨Ó©¯ºÖ¨º»ò²³æ!!
¾Ç·|VFP¨Ï¥ÎªÌªÀ°Ïªº·j´M,Code¤~·|§ó¦³½ì~
############################# |
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
Ruey
µù¥U®É¶¡: 2003-03-12 ¤å³¹: 1698 ¨Ó¦Û: tunglo
²Ä 8 ¼Ó
|
µ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¤~·|§ó¦³½ì~
############################# |
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 9 ¼Ó
|
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 10 ¼Ó
|
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 11 ¼Ó
|
µ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§@¹Ú |
|
¦^³»ºÝ |
|
![](templates/subSilver/images/spacer.gif) |
|