Installing a Sybase package to work with SQL Server

heigold1 has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I am trying to run the Makefile.pl that comes with DBD-Sybase-1.05.tar.gz, and keep getting the error:

Please set SYBASE in CONFIG, or set the $SYBASE environment variable at Makefile.PL line 97, <IN> line 44.

Setting this at the DOS prompt doesn't work, but even if it did then i wouldn't know the correct value to initialize it to anyways.

Does anyone know how to get around this?

Your help is greatly appreciated,

Brent.

Comment on Installing a Sybase package to work with SQL Server

Replies are listed 'Best First'.
Re: Installing a Sybase package to work with SQL Server by mpeppler (Vicar) on May 11, 2005 at 19:04 UTC
Also note that to work with SQL Server (I assume you mean Microsoft) you need to use FreeTDS. The Sybase client libraries will not work. I don't know if FreeTDS compiles under Windows. You might be better off trying DBD::ODBC in this situation. Michael	[reply]
Re^2: Installing a Sybase package to work with SQL Server by Grygonos (Chaplain) on May 11, 2005 at 20:52 UTC
I will concur `DBD:ODBC` is the way to go. I have been successfully using it for over 2 years to connect to SQL Server boxes @ my place. Grygonos	[reply] [d/l]
Re: Installing a Sybase package to work with SQL Server by ikegami (Patriarch) on May 11, 2005 at 18:54 UTC
System-wide environment variables can be created as follows: Right-click on the "My Computer" icon. Select the "Properties" menu item. Select the "Advanced" tab. Click on the "Environment Variables" button. Click on the bottom "New" button. Enter the appropriate data. (Those are instructions for Win2k. Intructions for other versions of Windows are similar, but may differ slightly.) I don't know what the variable's value should be, though.	[reply]
Re: Installing a Sybase package to work with SQL Server by dragonchild (Archbishop) on May 11, 2005 at 18:45 UTC
You're looking for the Environment variables, which are buried in some 3rd-level window in the Control Panel, under System somewhere (depending on your Win32 version). Your best bet would be to use PPM. In general, if you think something isn't in Perl, try it out, because it usually is. :-) "What is the sound of Perl? Is it not the sound of a wall that people have stopped banging their heads against?"	[reply]