Re: Error - Could not find installable ISAM

From: Brendan Reynolds (brenreyn)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 13:48:24 +0100

You can use the Universal Data Link (UDL) dialog to point and click your way
to a connection string. In recent versions of Windows, there's no direct way
to create a new UDL, but you can create a new text file and then just change
the extension from '.txt' to '.udl'. Then when you double-click the file,
the UDL dialog will open. It defaults to the SQL Server provider, so be sure
to change that to the Jet OLEDB 4 provider on the first page of the dialog,
then there's a browse button on the second page of the dialog where you can
select your MDB. When everything is working in the UDL (there's a 'Test
Connection' button in the dialog) you can save it, then open it in Notepad
and copy and paste the connection string into your code. 

-- 
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"Dave" <dave5398@btinternet.com> wrote in message 
news:uuzZJ30tEHA.3476@TK2MSFTNGP14.phx.gbl...
>
> "Val Mazur" <group51a@hotmail.com> wrote in message
> news:ugHVCVktEHA.2300@TK2MSFTNGP09.phx.gbl...
>> Hi Dave,
>>
>> It is possible that you do not have permissions to access your database
> from
>> ASP. Also check if this is not your case
>>
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;268860
>>
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;318161
>>
>> --
>> Val Mazur
>> Microsoft MVP
>>
>>
>> "Dave" <dave5398@btinternet.com> wrote in message
>> news:%23MKZ2tItEHA.3156@TK2MSFTNGP12.phx.gbl...
>> > Hi,
>> >
>> > I am just trying to connect to an Access database on my local IIS 
>> > server
>> > (for testing).  I am using this as a connection string
>> >
>> > oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data
>> > Source=c:\apath\myDb.mdb"
>> >
>> > This is creating an error
>> >
>> > Run time erorr - could not find installable ISAM
>> >
>> > Any ideas what's going on here?
>> >
>> >
>> > Dave
>
>
> Thanks - tried then KB articles but can't get past first base!  I did 
> this:
>
> Installed ADO 2.7 in a VB project
>
>
> Just did (copied from the article)
>
> Dim cnn As New ADODB.Connection
> cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;"
>
> Even this comes up with a Runtime error "Authentication failed" !!!
>
> I should have permission, I am trying to open a little Access database on 
> my
> own laptop.  I have IIS installed to provide a testbed for asp 
> development.
>
> This really should not be a problem should it!
>
>
> Dave
>
>