[freetds] Does FreeTDS support access to SQL Server 2000/2005 from HPUX 11i on 64-bit Itanium

[Betty Gwon]

Hello,

We are trying to convert our Database server from HPUX PA-Risc2 (32-bit)
to HPUX Itanium (64-bit). We have a 3rd party application that extracts
data from a SQL Server 2000 database server. This process worked fine
using the Freetds software with UnixODBC on the HPUX PA-Risc2 (32-bit).
However, it is not working on the Itanium server. They are telling me
they it is not supported. Can someone please tell me if I can use
FreeTDS to extract data from an SQL server 2000 and a SQL Server 2005
server from an Itanium (64-bit) server?

Thanks,
Betty

[Betty Gwon]

Sorry, correction. I need to know if we can connect to SQL Server 2000
and 2008.

Thanks,
Betty

-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Betty Gwon
Sent: Monday, May 18, 2009 8:43 AM
To: freetds at lists.ibiblio.org
Subject: [freetds] Does FreeTDS support access to SQL Server 2000/2005
fromHPUX 11i on 64-bit Itanium

Hello,

We are trying to convert our Database server from HPUX PA-Risc2 (32-bit)
to HPUX Itanium (64-bit). We have a 3rd party application that extracts
data from a SQL Server 2000 database server. This process worked fine
using the Freetds software with UnixODBC on the HPUX PA-Risc2 (32-bit).
However, it is not working on the Itanium server. They are telling me
they it is not supported. Can someone please tell me if I can use
FreeTDS to extract data from an SQL server 2000 and a SQL Server 2005
server from an Itanium (64-bit) server?

Thanks,
Betty

[James K. Lowden]

Post by Betty Gwon
Can someone please tell me if I can use
FreeTDS to extract data from an SQL server 2000 and a SQL Server 2005
server from an Itanium (64-bit) server?

...

Post by Betty Gwon
Sorry, correction. I need to know if we can connect to SQL Server 2000
and 2008.

Answer to all questions is Yes. FreeTDS works on any 64-bit architecture
for which it compiles.

64-bit ODBC is a little tricky though. The ODBC 3.0 specification was not
64-bit clean, meaning there were places where pointers were passed as
integers. AIUI this has all been resolved if you use the right versions
of everything, especially of the Driver Manager.

HTH.

--jkl

[Betty Gwon]

Can you please tell me what you mean by right version of everything? In
my current freetds.config file, it says "freetds.conf,v 1.12". Is this
the correct version? Should I be using TDS Version 8.0 for both SQL
Server 2000 and 2008?

Thanks,
Betty

-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Monday, May 18, 2009 6:14 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Does FreeTDS support access to SQL Server
2000/2005 from HPUX 11i on 64-bit Itanium

Can someone please tell me if I can use FreeTDS to extract data from
an SQL server 2000 and a SQL Server 2005
server from an Itanium (64-bit) server?

...

Sorry, correction. I need to know if we can connect to SQL Server
2000 and 2008.

Answer to all questions is Yes. FreeTDS works on any 64-bit
architecture for which it compiles.

64-bit ODBC is a little tricky though. The ODBC 3.0 specification was
not 64-bit clean, meaning there were places where pointers were passed
as integers. AIUI this has all been resolved if you use the right
versions of everything, especially of the Driver Manager.

HTH.

--jkl

[James K. Lowden]

Post by Betty Gwon
Can you please tell me what you mean by right version of everything?

In particular, make sure your driver manager is up to date. Check its
documentation regarding 64-bit issues. I can't be more specific because I
don't have much direct experience with it.

Post by Betty Gwon
In
my current freetds.config file, it says "freetds.conf,v 1.12". Is this
the correct version?

That's a user-edited file that describes servers. The revision isn't
important; what matters is what you put in it.

Post by Betty Gwon
Should I be using TDS Version 8.0 for both SQL
Server 2000 and 2008?

Yes. Or TDS 7.0.

HTH.

--jkl

[Betty Gwon]

We are going to try to install again. Are there any environment
variables that need set prior to running the "make" and "config"?

Thanks,
Betty


-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Monday, May 18, 2009 6:14 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Does FreeTDS support access to SQL Server
2000/2005 from HPUX 11i on 64-bit Itanium

Can someone please tell me if I can use FreeTDS to extract data from
an SQL server 2000 and a SQL Server 2005
server from an Itanium (64-bit) server?

...

Sorry, correction. I need to know if we can connect to SQL Server
2000 and 2008.

Answer to all questions is Yes. FreeTDS works on any 64-bit
architecture for which it compiles.

64-bit ODBC is a little tricky though. The ODBC 3.0 specification was
not 64-bit clean, meaning there were places where pointers were passed
as integers. AIUI this has all been resolved if you use the right
versions of everything, especially of the Driver Manager.

HTH.

--jkl

[James K. Lowden]

Post by Betty Gwon
Are there any environment
variables that need set prior to running the "make" and "config"?

The User Guide describes that process in some detail. The answer to your
question is, No, FreeTDS doesn't rely on any environment variables to be
set at any stage. Environment variables permit changing some run-time
behavior, but they're optional.

--jkl