|
ASP
mySQL
More detial or script code example
Connect to MySQL DB from ASP VB script pages.
由 mySQL 資料庫連結到 ASP 網頁 Description: <%
Dim Conn, oRs
Dim qry, connectstr
Dim db_name, db_username, db_userpassword
Dim db_server, fieldname, tablename
db_server="----your server-----"
'sometimes IP, domain, or a designed server, (Data Source) localhost
db_name="--dbname--" 'sometimes your db username : sometimes title of description, (Initial Catalog)
db_username="--username--" 'your db username (User Id)
db_userpassword="PW" 'your db password (Password)
fieldname="c1"
tablename="tb1"
connectstr="Driver={MySQL ODBC 3.51 Driver};SERVER="&db_server&";UID="& db_username &";PWD="& db_userpassword &";DATABASE="& db_name &";OPTION=3;"
set conn=Server.CreateObject("ADODB.Connection")
conn.open connectstr
%>
OPTION=3; 不一定使用
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=[主機位址]; DATABASE=[資料庫名稱]; UID=[帳號];PASSWORD=[密碼]; OPTION=3"
|
