Connecting Tech Pros Worldwide Forums | Help | Site Map

connection string to connect ms-access with password protected

Naveen
Guest
 
Posts: n/a
#1: Nov 19 '05
Hi All,
I have developed an application in ASP.NET and everything went fine till i
found a need to use Crystal Reports, after surfing I found that Crystal
Reports can only be used when I have a pwd assigned to my access db.

my previous connection string goes as follows:

<add key="constring" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:/inetpub/wwwroot/myApplication/database/myDB.mdb;" />

1)now when I run the application it gives error sayin Invalid Password
2)Then I changed my connection string to :
<add key="constring" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:/inetpub/wwwroot/AECLighting/database/lighting.mdb;UID=Admin;PWD=somepwd"/>

I gives an error saying Could not find Installable ISAM.

Any help will be greatly appreciated.

Thanks in Advance.

Regards
Naveen

Kevin Spencer
Guest
 
Posts: n/a
#2: Nov 19 '05

re: connection string to connect ms-access with password protected


Hi Naveen,

I have great news fro you. There is a web site that has Connection Strings
for most databases, and it is very comprehensive. See
http://www.connectionstrings.com/ to find your Connection String. I checked,
and they have one for an Access database using password. And the next time
you have a Connection String issue, you can just go there and find the one
you need! :-D

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.

"Naveen" <Naveen@discussions.microsoft.com> wrote in message
news:93991444-EE3D-462E-BA97-BC04988D7E9E@microsoft.com...[color=blue]
> Hi All,
> I have developed an application in ASP.NET and everything went fine till
> i
> found a need to use Crystal Reports, after surfing I found that Crystal
> Reports can only be used when I have a pwd assigned to my access db.
>
> my previous connection string goes as follows:
>
> <add key="constring" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=D:/inetpub/wwwroot/myApplication/database/myDB.mdb;" />
>
> 1)now when I run the application it gives error sayin Invalid Password
> 2)Then I changed my connection string to :
> <add key="constring" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=D:/inetpub/wwwroot/AECLighting/database/lighting.mdb;UID=Admin;PWD=somepwd"/>
>
> I gives an error saying Could not find Installable ISAM.
>
> Any help will be greatly appreciated.
>
> Thanks in Advance.
>
> Regards
> Naveen[/color]


Naveen
Guest
 
Posts: n/a
#3: Nov 19 '05

re: connection string to connect ms-access with password protected


Hi kevin,
Thank for ur reply.

regards
Naveen

"Kevin Spencer" wrote:
[color=blue]
> Hi Naveen,
>
> I have great news fro you. There is a web site that has Connection Strings
> for most databases, and it is very comprehensive. See
> http://www.connectionstrings.com/ to find your Connection String. I checked,
> and they have one for an Access database using password. And the next time
> you have a Connection String issue, you can just go there and find the one
> you need! :-D
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> ..Net Developer
> Ambiguity has a certain quality to it.
>
> "Naveen" <Naveen@discussions.microsoft.com> wrote in message
> news:93991444-EE3D-462E-BA97-BC04988D7E9E@microsoft.com...[color=green]
> > Hi All,
> > I have developed an application in ASP.NET and everything went fine till
> > i
> > found a need to use Crystal Reports, after surfing I found that Crystal
> > Reports can only be used when I have a pwd assigned to my access db.
> >
> > my previous connection string goes as follows:
> >
> > <add key="constring" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=D:/inetpub/wwwroot/myApplication/database/myDB.mdb;" />
> >
> > 1)now when I run the application it gives error sayin Invalid Password
> > 2)Then I changed my connection string to :
> > <add key="constring" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=D:/inetpub/wwwroot/AECLighting/database/lighting.mdb;UID=Admin;PWD=somepwd"/>
> >
> > I gives an error saying Could not find Installable ISAM.
> >
> > Any help will be greatly appreciated.
> >
> > Thanks in Advance.
> >
> > Regards
> > Naveen[/color]
>
>
>[/color]
Closed Thread