Re: Colud not find file ISAM
- From: "Jim Carlock" <anonymous@localhost>
- Date: Sat, 2 Apr 2005 11:39:47 -0500
Do you want .asp code for connecting to the database ?
Dim sDbQPN
Dim sCon
'Set path and name of db
sDbQPN = "/fpdb/wwForum.mdb"
'Db connection info + driver (if not workable, comment it and use alternative)
'sCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(sDbQPN)
'sCon = "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=" & Server.MapPath(sDbQPN) 'Access 97
sCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(strDbQPN) ' Access 2000/2002
NOTE: The code above is IIS .asp code. It is NOT meant for VB. The
Server.MapPath function is a function of IIS running vbScript.
Hope this helps.
--
Jim Carlock
Please post replies to newsgroup.
"MikeD" wrote:
"Mamatha" <mamatha@xxxxxxxxxxxxxxxxxx> wrote in message
news:u$CbrK1NFHA.3988@xxxxxxxxxxxxxxxxxxxxxxx
> Hi
>
> I used the following way,eventhough i got the same error
>
> set oConn = Server.CreateObject("ADODB.Connection")
> oConn.Mode = adModeShareExclusive
> oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=D:\db1.mdb;" & _
> "User Id=admin;" & _
> "Password="
> oConn.Execute("SELECT * INTO " & _
> "[tblpath] " & _
> "FROM " & _
> "[Provider=sqloledb; " & _
> "SERVER=SREENI;DATABASE=parameter;" & _
> "UID=sa;PWD=thanks;]." & _
> "[tbl_path];")
>
> Set oConn = Nothing
>
>
> If any one know the solution,please let me know this is very urgent need
for
Is the Jet engine installed? What version of MDAC is installed? Is this a
non-English version of VB or Windows? On what line are you getting the
error? Is it even valid SQL to specify a connection string in the FROM
clause? It looks like all you're wanting to do is copy records from a table
in SQL Server to a table in Access. Perhaps you should look into using DTS
to accomplish this task? If you need to do this more than once, you can save
the DTS Package and execute it from your VB app.
You might also want to take a look at the following:
FIX: Error message "Cannot find installable ISAM" after installing localized
versions of Visual Basic 6.0 Service Pack 4 and Service Pack 5
http://support.microsoft.com/default.aspx?scid=kb;en-us;273458
You receive a "Could not find installable ISAM" error message or some file
types are missing when you import files, export files, or link files in
Access 2000
http://support.microsoft.com/kb/209805/
While these might not be specific to the exact issue you're having, they may
provide clues that lead you to the solution. You might want to do a more
general search of the KB than I did (which was just for VB6-related
articles).
--
Mike
Microsoft MVP Visual Basic
.
- References:
- Colud not find file ISAM
- From: Mamatha
- Re: Colud not find file ISAM
- From: Jeff Johnson [MVP: VB]
- Re: Colud not find file ISAM
- From: Mamatha
- Re: Colud not find file ISAM
- From: MikeD
- Colud not find file ISAM
- Prev by Date: Re: Image Arrays
- Next by Date: Proper way to cancel form while loading
- Previous by thread: Re: Colud not find file ISAM
- Next by thread: Re: Could not find file ISAM
- Index(es):
Relevant Pages
|
