Forum Discussion
jthompson1
9 years agoContributor
Well I do appreciate the replies. Makes me feel a little more confident that I am headed in the right direction, however I still have not resolved this issue. Should I find a solution I will be sure to reply on this thread. :smileyvery-happy:
- NisHera9 years agoValued Contributor
I do like this and works for me....
Connect = ADO.CreateConnection();
ADOCommand = ADO.CreateCommand();
ConnectionString = 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=';
ConnectionString = ConnectionString + 'DatabaseName';
ConnectionString = ConnectionString + ';Data Source=' + 'SQLServerName';
Connect .ConnectionString = ConnectionString ;
Connect .Open();
ADOCommand.ActiveConnection = Connect ;
ADOCommand.CommandType = adCmdText;
ADOCommand.CommandText = "My...SQLQuery";
RecordSet = sADOCommand.Execute();I think what you are missing is
ADOCommand = ADO.CreateADOCommand();
Related Content
- 6 years agoranujn
- 6 years agomcostantini
- 3 years agoMarkSchofer
- 3 years agomsalvador
Recent Discussions
- 5 hours agoSvetaG