On Aug 23, 9:53 pm, ozguy <
acho...@gmail.com> wrote:
> I'm trying to help a user who's been running a Python program
> successfully on Windows XP to connect to a SQL Server DB on alternate
> port 1435.
>
> This error is the same as another error I've seen on other posts, and
> I tried all of the configuration recommendations mentioned to no
> avail.
>
> It works fine from his XP laptop, but I cannot seem to get it working
> on a CentOS 5.3 32 bit OS, with pyodbc 2.1.6, and with
> unixODBC-2.2.11-7.1. The DB server is on the same subnet, and I can
> telnet to the IP & port without an issue.
>
> When I run the "isql" utility with the syntax "isql -v
> 192.168.195.38,1435 username password" I get the following error:
> IM002][unixODBC][Driver Manager]Data source name not found, and no
> default driver specified
> [ISQL]ERROR: Could not SQLConnect
>
> When I run it throught the python program with the syntax "connection
> = "Driver=
> {FreeTDS};SERVER=192.168.195.38,1435;Database=ANM;TrustedConnection=Yes;UID=username;PWD=password"