[resolved] Driver for SQL Server to alpha 64 bit

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

[resolved] Driver for SQL Server to alpha 64 bit

Post by roy »

Hi All,
Does anyone know of ODBC driver for SQL Server
that is for alpha true 64 bit?

oh and if not, any thoughts of getting data from it, it is my source data?
(I have some Ideas like unloading and ftp the file to my DS server)

any info would help!

Thanks in advance,
Last edited by roy on Tue Dec 23, 2003 8:15 am, edited 1 time in total.
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Teej
Participant
Posts: 677
Joined: Fri Aug 08, 2003 9:26 am
Location: USA

Re: Driver for SQL Server to alpha 64 bit

Post by Teej »

There was a thread asking a similiar thing, and Ray said it best:

"If Microsoft want you to use SQL Server on UNIX, they will provide you with a version for UNIX."

Then Ken raised a suggestion that you ftp the data over.

Do a quick search.

-T.J.
Developer of DataStage Parallel Engine (Orchestrate).
shawn_ramsey
Participant
Posts: 145
Joined: Fri May 02, 2003 9:59 am
Location: Seattle, Washington. USA

Re: Driver for SQL Server to alpha 64 bit

Post by shawn_ramsey »

roy wrote:Hi All,
Does anyone know of ODBC driver for SQL Server
that is for alpha true 64 bit?

oh and if not, any thoughts of getting data from it, it is my source data?
(I have some Ideas like unloading and ftp the file to my DS server)

any info would help!

Thanks in advance,
It was my understanding that Ascential was shipping the Data Direct Wire Level ODBC drivers with the server. If not I would talk to the Data Direct folks since they do have 64 bit ODBC drivers for SQL Server that run on Unix platforms.
Shawn Ramsey

"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Unfortunately, all of the wire drivers seem to be marked as "[not Tru64]" in the server readme. So, as noted, I assume you'd need to purchase them for the Alpha platform from the vendor.
-craig

"You can never have too many knives" -- Logan Nine Fingers
shawn_ramsey
Participant
Posts: 145
Joined: Fri May 02, 2003 9:59 am
Location: Seattle, Washington. USA

Post by shawn_ramsey »

chulett wrote:Unfortunately, all of the wire drivers seem to be marked as "[not Tru64]" in the server readme. So, as noted, I assume you'd need to purchase them for the Alpha platform from the vendor.
I just went to the Data Direct site and it looks like DataDirect does not even support Tru64.
Shawn Ramsey

"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Thanks All,
Ascential said they have a datadirect driver in the branded_odbc under installation directory.
I see it but the documnetation doesn't list it.

So now I miss the entries I need for the .odbc.ini file.
If anyone has them i'll apreciate it, otherwise I'll have to wait for Ascential's reply.

I'll try to give the final answer if it works when I get the entries I need.

Thank,

(workes fine were only typo problems in driver configuration :oops: )
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
forgot to post the name of the driver name:
VMmsss17.so
in the branded_odbc/lib directory
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply