can anyone please show me an example of RDAoleDBConnectionString? i was playing around with RDA, but i cant pull data with my connection string, with an error message
failure to open SQL Server with given connct string. [ connect string =
Data Source = JUN; Initial Catalog = SmartShopper; Integrated Security =True ]
i need a sample of connection string to connect to SQL server 2005, i was using VB 2005 to deploy my project
You need to specify a provider in the OleDb connection string. See http://www.connectionstrings.com/ for examples.
But if you want to connect to a SQL Server, you should probably use the Sql-specific types instead of OleDb.
|||thanks for your reference site...i get quite a lot info there..