DSN Less Connection?


"Server=Oracle; Driver={Microsoft ODBC for Oracle};"
  • Interview Candidate
  • 3
  • 1649

Showing Answers 1 - 3 of 3 Answers

Sandhya.Kishan

  • May 24th, 2012
 

A database connection can be done without using DNS and hence it is called as DNS less.In DNS less method we need to specify the information needed for the connection like database type, server / file location, username and password and also the connection option etc.

Example:
strconn="Driver={MicrosoftAccessDriver(*.mdb)};DBQ=F:Inetpubwwwrootsomedirdb1.mdb;DefaultDir=

f:Inetpubwwwrootsomedir;uid=LoginID;pwd=Password;DriverId=25;FIL=MSAccess;"
set conn = server.createobject("adodb.connection") conn.open strconn

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions