Sybase linked table

  • Hi

    I have a database with many tables linked by ODBC to Sybase.

    On clicking on the linked table, i get a prompt simlar to the picture attached.

    Now if i need to connect to this database and run queries on this table, how do i open it directly from code without it prompting for pwored(can somehow fill through VBA)


  • Re: Sybase linked table

    Well, I am not familiar with SyBase per se, but AFAIK, if you wish to run queries against an ODBC datasource, you need to supply userid & password if that database's settings require it for read/write access.... for SQL server you can use "Integrated Security" where your userid & password can be retrieved from your windows account...


    I connect to a SQL Server database to query using ADO like this

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!