ODBC Connection to MS Access

[edward_m]

All,

I never worked with MS ACCESS database,now i got a requirement to load data into MS Access DB.I did some search and found MS Access DB comes in .mdb file.My question is how to set up ODBC DSN for MS Access DB on DS Server.

Thanks in advance..

[meena]

Hi edward_m...
I think it is through Administrative tools..Programfiles/Administrative tools/ Data source(ODBC)...check it...

[kris007]

You need to goto Control Panel>>Administrative Tools>>DataSources(ODBC) on your server. Ask your DS Admin to create one.

[meena]

Ooops...
I think I am wrong...I am taking my sentence back because I am not sure...

Hi edward_m...
I think it is through Administrative tools..Programfiles/Administrative tools/ Data source(ODBC)...check it...

[meena]

Hi Kris007
Do you think even I was right or wrong..

You need to goto Control Panel>>Administrative Tools>>DataSources(ODBC) on your server. Ask your DS Admin to create one.

[edward_m]

You need to goto Control Panel>>Administrative Tools>>DataSources(ODBC) on your server. Ask your DS Admin to create one.

Thanks..What information i need to send to DS Admin to create DSN for MS Access DB..for example if i need ODBC DSN for SQLServer i will pass Servername and database name..
Please suggest me what info i need to send DS admin for the above requirement..

[kris007]

You will have to ask him to create a System DSN for MSAccess and give your database name which you would like to connect. Apart from that I don't see what he will need to set it up.

[jdmiceli]

Hello all!

Try taking a peak at this link: viewtopic.php?t=95235&highlight=connect++access

Hopefully that will help. I don't know all of the factors with your situation, but the link will give quite a bit. Good luck!

Bestest![/url]