Not a Valid Path for Access Database

[taree]

I have access database in my Q drive and I am getting the below error message. Can someone look at for me where I miss the path. thank you
Q:\DataBase\techmemo.mdb is not a valid path

<add name="TechMemoConnection" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Q:\DataBase\techmemo.mdb; Persist Security Info=False;" providerName="System.Data.OleDb"/>

 

[jmeckley]

the account running IIS needs access rights to the database.
BTW ms access was not designed to run websites. this has to potential to create nasty, hard to find bugs once deployed.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[taree]

thank you jason for response.this is a very small database and the only alternative available for us is to use access database. my question to you is can I put this database in my local drive and create a link from there.If I do this do i still need to have a right from IIS ? thank you

 

[jbenson001]

You can get a free copy of SQL Express.

 

[taree]

can I use for production? I do not want to be sued by Bill Gate I can not afford that. If I download this free sql express does it need to be some where in IIS server or can I have it any where I wanted. I have never dealt with SQL server. please tell me the steps that i need to follow. thank you gusy

 

[jmeckley]

sql express is free for use. the limitations are size and processors. since your app is small neither of these are an issue.

sqlexpress is more like sql server than access. if you only access to databases is access, then... you don't have much exposure to databases.

sql server\express is an application which runs like a service. you can access it via the command prompt
c:\osql -help

you'll need to create the database and a user to access the database. there are plenty of help files online.

then connect your application to the database, VS makes this fairly easy, I think. I'm a raw sql guy myself.

using a db like sqlexpress will allow you you use
indexing
stored procs (if you like that sort of thing )
transactions
multiple result sets

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[jbenson001]

stored procs (if you like that sort of thing )

Ha

 

[jmeckley]

yes that comment was for you

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[jbenson001]

LOL.. I thought so ....