Connect between SQL Server and Sybase without using ODBC

Question

Connect between SQL Server and Sybase without using ODBC

Crazy Pabs

SSC Enthusiast

Points: 185
More actions
December 8, 2008 at 5:05 am

#71688

Is it possible to Connect between SQL Server and Sybase without using ODBC
Scenario:
Setup in SQL Ent Man
Scheduled job executes a DTS
DTS has connection to Sybase 11 and SQL Server 2000
If I execute the DTS manually it looks at the ODBC software on my PC and executes perfectly.
If the Scheduled Job executes the DTS it fails because the ODBC software is not installed on the Server.
I have instructed by the dba's that the ODBC software is not going to be installed on Server as it is a cluster and cant be installed on a single Blade (or something like that)
Can we think outside of the box for a way to create a connection between the two, I have already tried using two tomato tins with a piece of string between them. Before you asked yes I did wash the tins before trying this experiment.
Yours going slightly crazy, as usual,
Crazypabs

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 1

The older DBLib stuff might work (based on named pipes).

However you need some way to connect from Windows to Sybase, and once you have that, it's possible that you can move data.

Likely you've have to use BCP to suck the data out and then pull it in from a flat file using DTS.

hemanth.damecharla SSCommitted Points: 1740 More actions · Answer 2

[font="Verdana"]Don't want to sound like an idiot but, why can't we install ODBC drivers on a cluster? I thought, as long as the drivers were available...then the DTS will work. All the DBAs or Windows Admins need to do is, install the drivers on both the nodes (assuming, you have a two node cluster). And the Sybase drivers come with a config utility to make connections.[/font]

-Hope is a heuristic search :smooooth: _~Hemanth

Crazy Pabs SSC Enthusiast Points: 185 More actions · Answer 3

Thanks All,

I'll investigate the BCP in sybase, but as this is not my box I suspect the owner will put up barriers. Can only but see.

On the point of ODBC Clusters,I'll pass this to the DBAs to see what they say.

Thanks

Pabs

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 4

There's no reason this won't work on a cluster, put everything on both sides and it should be fine.

Unless someone is nervous about it, and I understand that. If you don't have a test environment, I see the issues.

BCP works fine with Sybase, or at least they have one. Suck stuff out from another box even, don't mess with the SQL boxes, and put it somewhere the SQL Agent service account can copy it from.