Sunil -- It would help if you posted the offending code so I could give you specific advice -- but that notwithstanding, it appears the problem is that you haven't properly defined the Data Source Name (DSN) on your server. You must go to Start / Programs / Administrative Tools / Data Sources (ODBC) and create a valid DSN for your SQL Server by entering the server name, user id, password, and a NAME for the DSN. This applet will give you an opportunity to test the connection as well... and if it doesn't work in the Data Sources applet then it is not going to work in your perl app.
So after you have the DSN set up correctly and successfully tested, you must reference the DSN and login parameters correctly in your perl code, in the DBI->connect() function. Hope this helps Hugh J. Hitchcock Sr. Software Engineer, TIAXA http://www.tiaxa.com > -----Original Message----- > From: sunil matte [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 01, 2001 2:59 AM > To: [EMAIL PROTECTED] > Subject: error accessing sql server from perl > > > hi > i am trying to acces sql server through perl(on a > windows 2000 machine). i dowloaded the DBI module and > the required DBD's(DBD-ODBC).i get the following > error. > Can some one help me out with this.it would help me a > lot if some one could show me how to specify the dsn > name.i tried giving the name of the database but it > gave this error... > > Error message: > [Microsoft][ODBC Driver Manager] Data source name not > found and no default driver specified (SQL-IM002)(DBD: > db_login/SQLConnect err=-1) > > thanks in advance > sunil matte > > > __________________________________________________ > Do You Yahoo!? > Buy the perfect holiday gifts at Yahoo! Shopping. > http://shopping.yahoo.com >
