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
>

Reply via email to