ruby方法里关于sql的写法.

Python010

ruby方法里关于sql的写法.,第1张

[Copy to clipboard]

CODE:

create table mytab(

id serialnot null,

msg varchar(100),

primary key(id)

)

require 'win32ole'

connection = WIN32OLE.new('ADODB.Connection')

connection.open("Provider=SQLOLEDB.1User ID=sapassword=xxxxData Source=localhost,1433Initial Catalog=mydb")

最重要的一点是即使默认端口1433也要加上，不然会报错：

sql.rb:27:in `method_missing': open (WIN32OLERuntimeError)

OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server

[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

HRESULT error code:0x80020009

Exception occurred.from sql.rb:27:in `open'

from sql.rb:63