¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
kevinwill
µù¥U®É¶¡: 2005-11-04 ¤å³¹: 10
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 07, 2015 5:38 pm ¤å³¹¥DÃD: [°ÝÃD]½Ð°Ý windows 2003 R2 64bit ¦w¸Ë myODBC For VFP |
|
|
½Ð°Ý¦U¦ì¤j¤j¦³¸Ñ¶Ü?
¤p§Ì¨Ï¥Î VFP7.0 ¶}µoµ{¦¡
client OS : windows 2003 R2 64bit
¸ê®Æ¨Ó·½¦³¤@³¡¤À¬O mySQL ©ó¬O·|¦w¸Ë myODBC 32bit 5.1.10
¦ý¦w¸Ë§¹ ODBC 32bit ¸Ì¨S¦³ MySQL ODBC 5.1 Driver
¬GµLªk¥¿±`°õ¦æ
°O±o VFP ¬O¥Î ODBC 32Bit
(c:\windows\SysWow64\odbcad32.exe)
µù: windows 7;windows8,windows 8.1 ¤@¼Ë¦w¸Ë ¥i¥¿±`°õ¦æ
ODBC 32Bit ¸Ì¤]¥¿±`¦³ MySQL ODBC 5.1 Driver
¥Î¥H¤Uµ{¦¡¦Û°Ê«Ø¥ß myODBC
¥N½X: |
************°Æµ{¦¡¤Î¦Û©w¨ç¼Æ************ KJE
Function mySQLODBC
Para vlcODBCName
******************************************
lcODBCDriver='MySQL ODBC 5.1 Driver' &&DRIVERÃþ«¬
lcODBCName=vlcODBCName+' MySQL' &&¸ê®Æ·½¦W¦r
lcODBCServer=Myipadss &&SQL SERVER¦W¦r
lcODBCDatabase=vlcODBCName &&n³s±µªº¸ê®Æ®w¦W¦r
lcODBCDesc='³s±µ MySQL SERVER' &&¸ê®Æ·½´yz
Declare Integer SQLConfigDataSource In odbccp32 Integer, Integer, String, String
lnWindowHandle=0
**¥ý¸Õ¹Ïקï¤w¦³ªºODBC¡A¦pªG¤£¦s¦b¡Aªð¦^0¡C
lreturn=SQLConfigDataSource(lnWindowHandle, 2, lcODBCDriver, ;
'DSN=' + lcODBCName + Chr(0) ;
+ 'Description=' + lcODBCDesc + Chr(0) ;
+ 'Server=' + lcODBCServer + Chr(0) ;
+ 'Database=' + lcODBCDatabase + Chr(0))
If lreturn=0 &&¤£¦s¦b
lreturn=SQLConfigDataSource(lnWindowHandle, 1, lcODBCDriver, ;
'DSN=' + lcODBCName + Chr(0) ;
+ 'Description=' + lcODBCDesc + Chr(0) ;
+ 'Server=' + lcODBCServer + Chr(0) ;
+ 'Database=' + lcODBCDatabase + Chr(0);
+"network=DBMSSOCN" + Chr(0))
If lreturn=0 &&¥¢±Ñ
Messagebox("MySQL ³s½u¥D¾÷¥¢±Ñ"+Chr(13)+"½Ð«·s±Ò°Êµ{¦¡¦A¸Õ¤@¦¸",16,"¥D¾÷³s½u¥¢±Ñ")
Endif
Endif
Clear Dlls
Return |
|
|
¦^³»ºÝ |
|
|
ckp6250
µù¥U®É¶¡: 2004-07-30 ¤å³¹: 1644
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 07, 2015 8:42 pm ¤å³¹¥DÃD: |
|
|
§ï¥Îmyodbc3.51¬Ý¬Ý§a
¤Ï¥¿³£¯à³s¡A
¤£¥²±j¨D¦w¸Ë¨º¤@ª©¥» |
|
¦^³»ºÝ |
|
|
kevinwill
µù¥U®É¶¡: 2005-11-04 ¤å³¹: 10
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤Q¤G¤ë 08, 2015 9:41 am ¤å³¹¥DÃD: |
|
|
ckp6250 ¼g¨ì: | §ï¥Îmyodbc3.51¬Ý¬Ý§a
¤Ï¥¿³£¯à³s¡A
¤£¥²±j¨D¦w¸Ë¨º¤@ª©¥» |
¦w¸Ë 3.51 «á ÁÙ¬O¨S¦³32bit MySQL Driver ¿ï¶µ VFP¨S¿ìªk¨Ï¥Î
¦³¿ìªk±j¢µn¿ý¨ì 32bit ODBC¶Ü? |
|
¦^³»ºÝ |
|
|
ckp6250
µù¥U®É¶¡: 2004-07-30 ¤å³¹: 1644
²Ä 4 ¼Ó
|
|
¦^³»ºÝ |
|
|
kevinwill
µù¥U®É¶¡: 2005-11-04 ¤å³¹: 10
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤Q¤G¤ë 15, 2015 6:03 pm ¤å³¹¥DÃD: |
|
|
§Ú¸Õ¸Õ¬Ý¤¤~ ÁÂÁ |
|
¦^³»ºÝ |
|
|
|