[thelist] Oledb connection problem with Access XP
darren
darren at web-bitch.co.uk
Thu Nov 22 10:51:21 CST 2001
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
More information about the thelist
mailing list