[thelist] Oledb connection problem with Access XP

[darren]

On 22 November 2001 at 16:36:37, Joel D Canfield <joel at spinhead.com> wrote:

JDC> Any idea why this code:

JDC>      Set objConn = Server.CreateObject("ADODB.Connection")
JDC>      objConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
JDC> Source=c:\Inetpub\wwwroot\issimo\issimo.mdb"

JDC>      strQuery="SELECT * FROM products"

JDC>      Set InsProduct = objConn.Execute(strQuery)

JDC> begets this error?

cos you're trying to set your db connect to your connection string.  try

   objConn.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data
                 Source=c:\Inetpub\wwwroot\issimo\issimo.mdb")

hth,

darren