The "SECRET" the dba didn't tell you was that he adjusted the NTFS or Unix FS permissions on the file for the USERID you are connecting to the DSN with, and/or the USER you are logged into the network with...generally speaking a DSNLESS connection is File based access so appropriate file level permissions must be set.
*********** REPLY SEPARATOR *********** On 12/5/01 at 3:05 PM [EMAIL PROTECTED] wrote: >If you do not want to use a DSN, see > >http://aspn.activestate.com/ASPN/Mail/Message/277651 > >You might have to get a DBA involved to get this to work. The connection >worked the first time I tried it but when the database was moved to another >server the DSNless connection would not work. My DBA did something, that >he decided not to convey to me, and then the connection worked. > > > > >sunil matte <[EMAIL PROTECTED]> on 12/04/2001 11:47:12 AM > >To: [EMAIL PROTECTED] >cc: >Subject: RE: error accessing sql server from perl > > >hi > > thanks for your suggestions guys.i did figure >the problem out.i came to grips about dsn..... > >thanks once again >sunil > >__________________________________________________ >Do You Yahoo!? >Buy the perfect holiday gifts at Yahoo! Shopping. >http://shopping.yahoo.com ********************** 2K ******************************
