reading database w/o odbc

[Nanda]

Hi all!

My client wants to access the Oracle and SQL database from ASP without using ODBC....I do not know if it is possible!! and how!! If I use OLE-DB that also uses ODBC layer in between.

If anybody has done this before or doing....please let me know. Please also give your suggestions/comments to convience to client on this point.

I would really appreciate quick response(s).

Thank you

 

[TomasDill]

Hi!

You cannot. However, if problem is in maintaining of ODBS DSN in ODBC, you can use DSN-less connection to SQL Server, following is sample of connection string. Replace connection string in global.asa (or other places) that use ODBC DSN by following connection string (Sample is for MS SQL Server):

DRIVER={SQL Server};SERVER=MOON;UID=sa;PWD=MyPassword;APP=MyApp;WSID=MYCOMPUTER;DATABASE=MyDatabase

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs