如何用Ruby连接SQL Server 2005
1个回答
展开全部
require 'win32ole'
connection = WIN32OLE.new('ADODB.Connection')
connection.open("Provider=SQLOLEDB.1;User ID=sa;password=xxxx;Data Source=localhost,1433;Initial 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
connection = WIN32OLE.new('ADODB.Connection')
connection.open("Provider=SQLOLEDB.1;User ID=sa;password=xxxx;Data Source=localhost,1433;Initial 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
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
