Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Delphi XE4 ADORecordset - trouble setting the active connection

Posted on 2013-11-11
2
Medium Priority
?
887 Views
Last Modified: 2013-11-13
Hi, Experts.  I'm new to Delphi XE4.  I have lots of years with Delphi 5, a little with Delphi 2006, but am trying to make the leap to XE4.

I have few Delphi 2006 windows service programs that run fine.  I'm trying to create a new one in XE4, based on one of my existing Delphi 2006 programs.

One change that happened somewhere between 2006 and XE4 is the _Recordset object's _Set_ActiveConnection now takes a parameter of IDispatch instead of string.

In my ignorance, I've simply changed the string parameter to IDispatch and tried typecasting.  (Don't laugh too long.)

I've read a bit of the help file on IDispatch and that gave me no better understanding.

What I'm trying to do in this program is read an encrypted ADO connection string from an INI file, and use that to make a connection to a SQL database to get a set of records that I have to process in the timer event of my service program.

The event log gives me the Microsoft equivalent to "you can't get there from here" when the service program gets to

MyRecordSet._Set_ActiveConnection(FConnectionString);  

// FConnectionString is a typecast IDispatch of a string from reading the ini file.

I'd sure appreciate some direction on how to set the connection string for an ado connection.

Thanks.
0
Comment
Question by:bjones8888
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
Sinisa Vuk earned 2000 total points
ID: 39640883
You can always create connection object and pass it to Set_ActiveConnection as is here:
aConnection := CoConnection.Create;
aConnection.Open(sConnectionString, '', '', -1);
recs.Set_ActiveConnection(aConnection);
....

Open in new window


if you van to stick with string....
connStr: OleVariant;
recs: _Record;
...
connStr := 'Provider...';
recs.Set_ActiveConnection(connStr);
....

Open in new window

0
 

Author Closing Comment

by:bjones8888
ID: 39646004
It seems to me like the older version of Delphi may have created the connection object "on the fly" if one wasn't specified.

In any event, I'm now successfully using a TAdoConnection object, setting its connection string, and setting Connected to True. Then I use TAdoQuery to do the record processing.

Thank you!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question