Did not you forget about connection string? Something like: conn.open "Provider=sqloledb;Data Source=ip address;Initial Catalog=dbname;User Id=#*$!;Password=#*$!x;"
On Sun, Dec 21, 2008 at 10:43 PM, Ashwini Khanna <[email protected]>wrote: > Hi Group, > > I am trying to establish a connection to an Access database using ADODB. On > the very first line QTP throws an error saying "ActiveX component can't > create object: 'ADODB.Connection'" > > QTP version: 9.5 > > OS: Win XP > > CODE: > > Set objConn = CreateObject("ADODB.Connection") > objConn.Open "Project_Data" > (I have a DSN named "Project_Data") > > Any ideas on whats wrong? > Thanks, > Regards, > Ashwini > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en -~----------~----~----~----~------~----~------~--~---
