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)
Aadarsh
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.e.
I connect to a SQL Server database to query using ADO like this
'For Standard Security where userid & password supplied in code
stCon = "Provider=sqloledb;" & _
"Data Source=ServerName;" & _
"Initial Catalog=DbName;" & _
"User Id=Username;" & _
"Password=Password"
'For a Trusted Connection using windows security
stCon = "Provider=sqloledb;" & _
"Data Source=ServerName;" & _
"Initial Catalog=DbName;" & _
"Integrated Security=SSPI"Don’t have an account yet? Register yourself now and be a part of our community!