Re: Newbie problem connecting to MS SQL Server

[Thomas A. Lowery]

Mark Vaughan wrote:
Amonotod,
Yes, that helped tremendously.
Now I've moved on to the next problem.
I installed unixODBC and the tsql command worked (no errors), although
it replied with a 1> prompt and didn't seem to do anything unless I
typed 'quit', in which case it did just that.
I was able to run isql and get data from a table.
I installed freetds and it seems to work okay because I can use the isql
command with the dsn (isql gunnison user pass).
Now the problem:  I'm using perl to connect to the DB (see below) and
here is the snippet of code that fails:
 my $dbh = DBI->connect( "DBI:ODBC:gunnison", "user", 'pass');
 

<snip>
I'm trying to use the ODBC data source as listed above.
<snip>
 

SQLDriverConnect failed:
SQLConnect 'gunnison', 'mv'
dbd_error: err_rc=-1 rc=0 s/d/e: 0/8052744/8294408
dbd_error: SQL-IM002 (native 0): [unixODBC][Driver Manager]Data source
name not found, and no default driver specified (SQL-IM002)
dbd_error: err_rc=-1 rc=0 s/d/e: 0/0/8294408
db_login/SQLConnect error -1 recorded: [unixODBC][Driver Manager]Data
source name not found, and no default driver specified (SQL-IM002)(DBD:
db_login/SQLConnect err=-1)
   <- connect= undef at
 

<snip>
Can anyone offer any suggestions?
Is "gunnison" defined in either your global odbc.ini file or local 
~/.odbc.ini? Is ODBCINI set?  If ODBCINI is not set
then defining gunnison in either the global or local should work.  If 
ODBCINI is set make sure it points to
the odbc.ini file that contains gunnison.

Tom