Access Connection string problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I added a connection to server explorer, dragged a table to the designer to
create a strongly typed dataset, this worked ( I can also open tables in the
db and view the data)

When i try to configure my tableAdapter i get a message not a valid account
name or password

How is it that i can retrieve data from the server explorer but cant config
my table adapter with the same connection string?


here is my code:
<connectionStrings>
<add name="ApolloDMSConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=|DataDirectory|\ApolloDMS.mdb;Persist Security
Info=True;Password=mk;User ID=err;Jet OLEDB:System
database=C:\Dms\Secured1.mdw"
providerName="System.Data.OleDb" />
</connectionStrings>
 
How is it that i can retrieve data from the server explorer but cant
config
my table adapter with the same connection string?


here is my code:
<connectionStrings>
<add name="ApolloDMSConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=|DataDirectory|\ApolloDMS.mdb;Persist Security
Info=True;Password=mk;User ID=err;Jet OLEDB:System
database=C:\Dms\Secured1.mdw"
providerName="System.Data.OleDb" />
</connectionStrings>
Click to expand...

I think the problem is:
|DataDirectory|

Which won't be correctly parsed.

include a full path:
c:\mydatabase.mdb
 
Back
Top