.Net Database Connection

[flannagan]

Hi,

I am using Visual Studio and would like to connect to an MS access database I have created. I can do this fine when everything is local to my machine, but I am unsure how to connect to it when I upload it to the catalyst2 servers. Is there a step by step guide on how to do this as I am new to .Net development.

Many thanks

Flannagan

[WhiskyFudge]

One of our users Jenny has created a tutorial for such things which can be downloaded at: http://support.catalyst2.com/index.p...ds&_m=get&_i=5. If you want any more help then let us know.

On an annoying side note I would like to point out that Access is not a suitable database system to handle any form of serious traffic, but will happily do small sites.

Hope that helps

Jas

[flannagan]

I have looked at the guide and am still having problems connecting to my database. I want to create a connection in Server Explorer (Visual Studio) So I can drag the tables I want onto the selected web forms. Im trying to use MS Jet 4.0 OLE DB provider. When I try to test my connection Im getting a workgroup information file is missing or opened exclusively by another user error.

Any suggestions, once I can connect to it via server explorer ill be away and running.

Thanks

Flannagan

[Jacob]

Is the database in anyway password protected?

Have you had a look at: http://msdn.microsoft.com/library/de.../odatanet2.asp ?

What is your connection code?

Regards,

Jacob