help me in a search enging coding i have connect with ms accesss datab

before i hade connected in SQLServer that was wright

Page 1 of 1

1 Replies - 326 Views - Last Post: 13 October 2008 - 08:08 AM Rate Topic: -----

#1 shiba meher  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 11-October 08

help me in a search enging coding i have connect with ms accesss datab

Post icon  Posted 13 October 2008 - 07:39 AM

can any tell me the code what will be if i connect in Ms Access databes

it is connecting in SQL Server databe code
WHERE	 (NAME LIKE @yName + '%')
it is a search enging coding
Is This A Good Question/Topic? 0
  • +

Replies To: help me in a search enging coding i have connect with ms accesss datab

#2 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 418
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

Re: help me in a search enging coding i have connect with ms accesss datab

Posted 13 October 2008 - 08:08 AM

Change the connection string to an MS access connection and use OleDb objects instead of SQL.

ie.
OleDbCommand, OleDbDataAdapter, etc.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1