Re: Using freetds in Windows

Paul, many thanks -- that took care of the problem with tsql. Now I just
need to figure out what my program is doing differently from tsql, and
maybe I'll finally get this show on the road ...

Andy Wakefield
[email protected] 

On Thu, 2009-12-31 at 06:30 -0500, Paul Thurston wrote:
> Andrew:
> 
>  
> 
> On Windows, if your using v0.82, you’ll need to set the environment
> variable FREETDSCONF to point to your freetds.conf file.
> 
> Also, remember to escape the file path sequence as follows: SET
> FREETDSCONF=C:\\Apps\\FreeTDS\\etc\\freetds.conf
> 
> In the freetds.con file itself, make sure that line host=<Address> is
> a valid IP address to the database server.
> 
>  
> 
> Paul
> 
>  
> 
>  
> 
>  
> 
>  
> 
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Andrew H.
> Wakefield
> Sent: Thursday, December 31, 2009 12:15 AM
> To: [email protected]
> Subject: [freetds] Using freetds in Windows
> 
>  
> 
> I have successfully cross-compiled freetds-0.82 for Windows. I can use
> 
> the resulting tsql.exe with an explicit host and port (e.g., tsql -H
> 
> 127.0.0.1 -p 1433 -U username) and connect to the SQL Server. However,
> I
> 
> cannot seem to find a way to use a server name (e.g., tsql -S
> SQLEXPRESS
> 
> -U username). In Linux, I put the server information into the
> 
> freetds.conf file and it works fine. I have tried putting the server
> 
> information into freetds.conf and .freetds.conf in the MS-DOS
> directory
> 
> where tsql.exe is running; I have tried setting the environment
> variable
> 
> FREETDS to point to this file. Nothing has worked. Help!
> 
>  
> 
> _______________________________________________
> 
> FreeTDS mailing list
> 
> [email protected]
> 
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> 
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds