Go Back   Technology Questions > Software Questions > Operating System Questions > Vista Community > Windows Vista

Windows Vista Discuss the different versions of Windows Vista, Fuji, or Vienna

Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old 03-01-2007, 06:00 PM
Rob
Tablet PC Guest
 
Posts: n/a
OLE DB Provider for ODBC error

When I run the following code in my ASP file:

set dbConn = Server.CreateObject("ADODB.Connection")
szPath=Server.MapPath("../../../")
szProvider="Driver=Microsoft Access Driver (*.mdb); DBQ=" & szPath
szProvider=szProvider & "\database\" & szDir & "\" & szDB & ".mdb;"
if bDebug then fpDebug.WriteLine("szProvider: " & szProvider)
dbConn.Open szProvider

I get the following error on the last line.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

I know the szProvider is set to

Driver=Microsoft Access Driver
(*.mdb);DBQ=C:\bobstuff\database\thehills\HMGA.mdb ;

as I write the variable to a debug file prior to trying to open it. I tried
using the code using the conn.Provider="Microsoft.Jet.OLEDB.4.0" code that
was suggested in another post, but that did not work either.

The above code works on XP w/ IIS 5.1 and Win2K w/ IIS 5.0. The database in
question is an Office 2000 database. I'm trying to migrate to a new
development machine using Vista Home Premium and Office 2007. Any suggestions
would be welcome.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

 
Old 03-01-2007, 06:00 PM
Xploder HD Movie Player for PS3. Manage, convert and transfer media files between the PC and PS3.
  #2 (permalink)  
Old 03-01-2007, 08:00 PM
Manuel Nonaca
Tablet PC Guest
 
Posts: n/a
Re: OLE DB Provider for ODBC error




http://support.microsoft.com/kb/238971/en-us

--
Manuel Nonaca
MIS/M University of Phoenix Online
Clovis, CA (PST)


"Rob" <Rob@discussions.microsoft.com> wrote in message
news:21542CCF-E99C-4558-96F5-1F9932EF9734@microsoft.com...
> When I run the following code in my ASP file:
>
> set dbConn = Server.CreateObject("ADODB.Connection")
> szPath=Server.MapPath("../../../")
> szProvider="Driver=Microsoft Access Driver (*.mdb); DBQ=" & szPath
> szProvider=szProvider & "\database\" & szDir & "\" & szDB & ".mdb;"
> if bDebug then fpDebug.WriteLine("szProvider: " & szProvider)
> dbConn.Open szProvider
>
> I get the following error on the last line.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Disk or network error.
>
> I know the szProvider is set to
>
> Driver=Microsoft Access Driver
> (*.mdb);DBQ=C:\bobstuff\database\thehills\HMGA.mdb ;
>
> as I write the variable to a debug file prior to trying to open it. I
> tried
> using the code using the conn.Provider="Microsoft.Jet.OLEDB.4.0" code that
> was suggested in another post, but that did not work either.
>
> The above code works on XP w/ IIS 5.1 and Win2K w/ IIS 5.0. The database
> in
> question is an Office 2000 database. I'm trying to migrate to a new
> development machine using Vista Home Premium and Office 2007. Any
> suggestions
> would be welcome.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom ActiveSync provider on Windows Vista hfann Pocket PC General 2 02-07-2007 08:47 PM
Re: unlock mpx220 simm provider NEILC Smartphones 0 01-08-2007 07:15 PM
ODBC Oracle Error Jac Windows XP 0 01-04-2007 04:48 AM
[Microsoft][ODBC SQL Server Driver][DBNETLIB] error using Query An Leptonator Windows Vista 0 01-01-2007 09:54 PM
New Merchant account provider found, any experience ? mal_bates Tablet PC - Sandbox (Chit Chat) 0 06-10-2004 06:17 AM


All times are GMT -8. The time now is 05:34 AM.


2003 - 2008 All Rights Reserved. Technology Questions

SEO by vBSEO 3.1.0