| :: Error #:-2147467259 :: (2) | Post a New Message | Post a Reply |
 Error #:-2147467259 | Post a Reply |
since: Nov 28, 2005
from: somewhere
Error #:-2147467259
Unspecified error
From reading the forums it looks like a connection issue. I am using it on a Company Intranet and tring to connnect to an Access database. this is the code i am using
objWiz.Init("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=Y:\database.mdb;")
Can you please give me some insight on this problem.
Thank You
 Re: Error #:-2147467259 | Post a Reply |
from: Washington, DC
The first thing to do is make sure that your database connection is working. To do that, run the sample code below in a blank ASP page on your server.
Dim objConn, objRS, strConn
'TODO: Change Table1 below to an existing table name in your database
strSQL = "SELECT * FROM Table1"
strConn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=Y:\database.mdb;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConn
Set objRS = objConn.Execute(strSQL)
If Not objRS.EOF Then
Do While Not objRS.EOF
Response.Write objRS(0) & "<br>"
objRS.MoveNext
Loop
objRS.Close
End If
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
Let me know if you get any errors
-------------------------
Ghost