Using ADODB TO Connect To Sybase

[ChloeRadshaw]

Hi All,

I ve been trying all day to figure out how to connect to Sybase to run dynamic SQL.

Does anyone have any ideas?

I ve searched Google high and low without any success :(

I have the server, userId and password and can connect to this using QueryTables and ODBC.

I want to avoid having to write the SQL results to a worksheet as I need to process them in memory.

Can anyone please help?

Thanks

[CreganTur]

Have you looked here (http://www.connectionstrings.com/)?

[Bob Phillips]

Post your code so that we can work with something.

[ChloeRadshaw]

That tutorial was very helpful -= Thank you for posting it