ODBC Microsoft Access Driver

23 Feb 2006 4:13 PM

somersbar

hello all,

im trying to connect to a microsoft access database from an ASP.NET web

form.
i keep getting the following error though:

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use
'(unknown)'; file already in use. ERROR [IM006] [Microsoft][ODBC Driver

Manager] Driver's SQLSetConnectAttr failed ERROR [HY000]
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
file already in use.

i think its something to do with permissions and ive tried changing the

permissions on the folder that the mdb database is in (C:\Documents and

Settings\All Users\Documents), but im still getting an error.ive been
tryin to fix this for the past week but nothing i do seems to work.

any help would be appreciated.

23 Feb 2006 5:31 PM

William (Bill) Vaughn

Ah why are you using the ODBC driver and not the OleDb .NET data provider?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

<somers***@yahoo.com> wrote in message

Show quote

news:1140711187.837940.122180@g47g2000cwa.googlegroups.com...
> hello all,
>
> im trying to connect to a microsoft access database from an ASP.NET web
>
> form.
> i keep getting the following error though:
>
>
> ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use
> '(unknown)'; file already in use. ERROR [IM006] [Microsoft][ODBC Driver
>
> Manager] Driver's SQLSetConnectAttr failed ERROR [HY000]
> [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
> file already in use.
>
>
> i think its something to do with permissions and ive tried changing the
>
> permissions on the folder that the mdb database is in (C:\Documents and
>
> Settings\All Users\Documents), but im still getting an error.ive been
> tryin to fix this for the past week but nothing i do seems to work.
>
>
> any help would be appreciated.
>

24 Feb 2006 4:27 PM

Paul Clement

On 23 Feb 2006 08:13:07 -0800, somers***@yahoo.com wrote:

¤ hello all,
¤
¤ im trying to connect to a microsoft access database from an ASP.NET web
¤
¤ form.
¤ i keep getting the following error though:
¤
¤
¤ ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use
¤ '(unknown)'; file already in use. ERROR [IM006] [Microsoft][ODBC Driver
¤
¤ Manager] Driver's SQLSetConnectAttr failed ERROR [HY000]
¤ [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
¤ file already in use.
¤
¤
¤ i think its something to do with permissions and ive tried changing the
¤
¤ permissions on the folder that the mdb database is in (C:\Documents and
¤
¤ Settings\All Users\Documents), but im still getting an error.ive been
¤ tryin to fix this for the past week but nothing i do seems to work.

First, use Jet OLEDB instead of ODBC. Second, see the following:

PRB: Cannot connect to Access database from ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;316675

Paul
~~~~
Microsoft MVP (Visual Basic)