Sybase to Excell odbc conection 
Author Message
 Sybase to Excell odbc conection

I am running Sybase system 10 on a AIX server and need to establish a ODBC
link to a workstation using excell. I think I just need to install the
sybase open client on the desktop station and run ODBC setup, but would
appreciate any comments from anyone who has done this before.

Thanks



Tue, 29 Aug 2000 03:00:00 GMT
 Sybase to Excell odbc conection

You got it !
load the open client ie 11.1.1
check connectivity - add server entry into sqledit and ping
load odbc driver, and setup DSN once loaded

and wayhey....your away....

:o)



Fri, 01 Sep 2000 03:00:00 GMT
 Sybase to Excell odbc conection

On Fri, 13 Mar 1998 16:08:27 -0500, "Charles Lyle"

Quote:

>I am running Sybase system 10 on a AIX server and need to establish a ODBC
>link to a workstation using excell. I think I just need to install the
>sybase open client on the desktop station and run ODBC setup, but would
>appreciate any comments from anyone who has done this before.

>Thanks


Basically correct.  There may be some fine tuning to get your Excel ->
Sybase requests and returns working.  I have this running with Excel 5
(after doing some research on passing long SQL statements [>256
characters] via ODBC) and getting good response times considering the
age of the server (300 records selected out of 80,000 and returned in
30 to 45 seconds).  


Visit my homepage - source code in C, PB, VB: http://johnecarter.home.mindspring.com/
Visit my favorite elementary school: http://addison.home.mindspring.com/



Fri, 01 Sep 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Database conection using Ado Conection

2. SYBASE DBA/ CAREER POSITION/ EXCELL OPP/ VA

3. LYNUX to SUN Sybase conection using PHP3

4. I'm new to VB, regarding ADO msflexgrid controls using odbc, Excell spreadsheet

5. ODBC to Excell help!

6. ODBC conection problems

7. ODBC loses conection to SQL2000 server

8. Collecting data from an ODBC conection

9. Problem with Acces conection with SQL server 7.0 with ODBC

10. URGENT - 16 bit ODBC conection to SQL 7.0

11. Conection to a Remote SQL Server through ODBC ,giving Connection Errors

12. JDBC:ODBC conection to multiple databases


 
Powered by phpBB® Forum Software