Displaying 1 result from an estimated 1 matches for "adventureworks2000".
2006 Nov 04
0
Weak DBI support for MSSQL (was rails and MSSQL transactions)
There is something seriously wrong with DBI support for SQL server. I
have tried both DBI::ODBC and DBI:ADO and the following code always
fails.
---------- Code
require ''dbi''
host= "DEVELOPMENT_DATABASE_SERVER"
database="adventureworks2000"
username="someusername"
password="Somepwd"
db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data
Source=#{host};Initial Catalog=#{database};User
Id=#{username};Password=#{password};")
sql= ''Select FirstName, LastName from contact''
sth = db.prepare(...