Test ODBC DSN Connectivity from command line

hi ,

operating system : windows 2008 server r2 64 bit

database : ms access 2003 (mdb) secured by workgroup information file (wgi) (placed on shared network drive)

created 32 bit dsn based on above dsn.

i want check if dsn connecting comman line or other way provided os since odbc administrator not give functionality test connection based on access db.

any information appreciated !

regards,

anup wadhekar

you e.g. use vbscript - e.g. in asp page:

- right connection string dsn, e.g. http://www.connectionstrings.com

- add web server role classical asp

- create new folder , add asp page including this:

strconn = [your connection string] set dbconn = server.createobject("adodb.connection") dbconn.open strconn

- create application associated folder.

- application pool of iis needs configured 32bit apps. on 64bit server (advanced properties of app. pool)

it should work without web server, in script - think need careful run cscript syswow64 instead of system32.

elke

ps: think not quite correct forum question accidentally played similar stuff :-)

Windows Server  >  Network Access Protection