Problems accessing remote MS SQL Server

domiflichi

Posts: 164
Member Since:
2007-04-06

Submitted by domiflichi on Tue, 06/16/2009 - 8:28am.

Hello,

I successfully (I think) installed and configured FreeTDS using instructions found at a few websites including FreeTDS's, unixODBC's.

I have trixbox 2.2.4 (CentOS 4.7), and downloaded/installed freetds 0.82. I'm trying to connect to a MS SQL Sever 2000 machine (running Windows 2000 Server) via ODBC. I can connect to it using tsql, but it fails when trying to use isql, it fails.
My isql command line:

isql -v MSSQLServer myuser mypass

I get:

[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
[ISQL]ERROR: Could not SQLConnect

Let me know and I can provide other info.

&nbsp

jfinstrom

Posts: 2008
Member Since:
2007-03-07

Although you installed this

Tue, 06/16/2009 - 8:34am

Although you installed this on trixbox it is not a component of trixbox. Your best bet would be to hit up the forum or mailing list for the project you need help with.

&nbsp

domiflichi

Posts: 164
Member Since:
2007-04-06

Thanks for the reply. Yeah,

Tue, 06/16/2009 - 4:27pm

Thanks for the reply. Yeah, I know it's not really an official component or anything. I have posted in a couple of general purpose linux forums already, but have gotten no reply. I was hoping maybe someone here might have some insight into this problem I'm having. I don't know if there is a FreeTDS or unixODBC forum, but I'll look.

&nbsp

domiflichi

Posts: 164
Member Since:
2007-04-06

Not gonna happen

Tue, 07/14/2009 - 7:36am

I thought I'd update this thread with my findings in case anyone else is looking to do the same thing. See my posts at:
http://www.linuxforums.org/forum/redhat-fedora-linux-help/148344-freetds-odbc-ms-sql-server-problem.html

And FYI, I did get it to work on our 2.6.2.2 box.

Hope this 'helps' someone some day.

&nbsp

Problems accessing remote MS SQL Server

Comment viewing options

Search

Main

User login

Who's online