Hello,

Anukul Singhal wrote:
 > server.connect('113.212.133.232,1423','username','password')
 > database = server.Databases('DIT_Photon_1007')
 >
 > Can anybody help me which method would be used to execute a query in
 > win32ole?
Sorry, I don't know how to execute a query using SQLDMO.SQLServer,
but how about using ADODB.Connection instead of SQLDMO.SQLServer?

conn = WIN32OLE.new('ADODB.Connection')
conn.ConnectionString = 'Provider=SQLOLEDB;' +
   'User ID=username;' +
   'Password=password;' +
   'Data Source=113.212.133.232;' +
   'Initial Catalog=DIT_Photon_1007'
conn.open
rs = conn.execute('Select * from dbo.tLNPOrderStatus')
puts rs.fields.item(0).value

   Regards,
   Masaki Suketa