ODBC Driver

[Oviwan]

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

[Court Campbell]

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.

[Oviwan]

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]

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

[Oviwan]

Hey

Thanks, that's nice!

But I'm looking for MS SQL...

[Court Campbell]

Maybe

http://database.ittoolbox.com/groups/technical-functional/sql-server-l/dblink-oracle-to-sql-2000-120563

[Oviwan]

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

[Jov]

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]

Hey Jov

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

Regards

[Oviwan]

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?