cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC Driver

Oviwan
Honored Contributor

ODBC Driver

Hey Folk

Is an ODBC Driver (MSSQL) available for free? HPUX 11.11
I found this link: http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=993550
But they are all not for free.


Thanks.

Regards
11 REPLIES
Court Campbell
Honored Contributor

Re: ODBC Driver

It would be nice to have more info on what you are trying to achieve, but if you are using perl and want to access data on an mssql server then you could try DBD::ODBC or DBD::Sybase. I am not sure if DBD::Sybase will work with newer versions of mssql, but you can try.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Oviwan
Honored Contributor

Re: ODBC Driver

Thanks for response

I'm trying to create a database link from an oracle db on the unix box to a sql server. and for that I'm trying to create a Generic Connectivity.

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14232/gencon.htm#i1006075


Regards
Yogeeraj_1
Honored Contributor

Re: ODBC Driver

hi,

Have a look at the follow repository of MYSQL ODBC drivers:

http://mysql.mirrors.cybercity.dk/Downloads/MyODBC3/

hope this helps!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Oviwan
Honored Contributor

Re: ODBC Driver

Hey

Thanks, that's nice!

But I'm looking for MS SQL...
Court Campbell
Honored Contributor

Re: ODBC Driver

Maybe

http://database.ittoolbox.com/groups/technical-functional/sql-server-l/dblink-oracle-to-sql-2000-120563
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Oviwan
Honored Contributor

Re: ODBC Driver

That's very old and I think this is the Transparent Gateway method...
Jov
Honored Contributor

Re: ODBC Driver

Hi Oviwan,

Not sure what you're exactly trying to do. What do you mean a generic connection between the two databases?

The Perl ODBC module allows you to create DSN on both Unix and Windows and allow queries or normal SQL operations, but if you're trying to operator one from another within their respect SQL interface, than this is not for you.

Jov
Oviwan
Honored Contributor

Re: ODBC Driver

Hey Jov

Thanks, I'll try it with the Perl ODBC module tomorrow.

Regards
Oviwan
Honored Contributor

Re: ODBC Driver

I think it's more required than only the Perl ODBC module. I couldn't find some ODBC Driver for free. Or have you found somewhere a howto how to create a DSN with the perl modul without some driver?
Yogeeraj_1
Honored Contributor

Re: ODBC Driver

hi,

Sorry for the confusion.

For connections to MSSQL databases, you may also look into Transparent gateway options. With this you can directly query MSSQL tables in your Oracle Database.

hope this helps too!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Oviwan
Honored Contributor

Re: ODBC Driver

Yes it know this about the Transparent gateway but this is an extra cost option that does not come with the database license. hence I'm looking for a free odbc driver for a Generic Connectivity...