Connect to Sybase Server - vai VBA 1

[AccordingToDale]

Hey-o,

Anyone have a clue how to connect to a Sybase Server via VBA? (This would be from Excel 2003.)

d

 

[PHV]

Have a look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AccordingToDale]

i already checked there -- i have it bookmarked ;>)

i think i might be missing something though.

i cannot find either ADO or ODBC as a reference to add to my project (i'm assuming i need to add a reference). so i can't create a connection object.

thots?

d

 

[PHV]

The reference for ADO is:
Microsoft ActiveX Data Objects 2.x Library

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AccordingToDale]

fantastic.

thanx.

d

 

[AccordingToDale]

i'd give you a start if i could figure out how!!!

 

[AccordingToDale]

well, some figured it out! ;>)

must be monday or something.

d