DataLinks with ADO in FiveWin

DataLinks with ADO in FiveWin

Postby byron.hopp » Tue Nov 14, 2006 4:09 am

FYI,

I wanted to utilize the Datalink Wizard to obtain a properly formatted ADO connection string below is how to do this.

Local oDataLink := CreateObject("Datalinks")
Local oConn := oDataLink:PromptNew()

I spend a long time trying to find this, I can't believe it was this easy...

Byron,
Thanks,
Byron Hopp
Matrix Computer Services
byron.hopp
 
Posts: 382
Joined: Sun Nov 06, 2005 3:55 pm
Location: Southern California, USA

Postby Baxajaun » Tue Nov 14, 2006 9:36 am

Hi Byron,

your code:

Code: Select all  Expand view  RUN
Local oDataLink := CreateObject("Datalinks")
Local oConn := oDataLink:PromptNew()


is working for me, you can see the image

[img]
http://img300.imageshack.us/my.php?image=sshot1nb8.png
[/img]

Regards,

Felix
User avatar
Baxajaun
 
Posts: 968
Joined: Wed Oct 19, 2005 2:17 pm
Location: Gatika. Bizkaia

Postby hua » Sun Jan 27, 2008 8:01 pm

I just want to add, if you want to see the value of the connection string, just tack the following at the end of Byron's code:
Code: Select all  Expand view  RUN
msginfo(oConn:ConnectionString)
hua
 
Posts: 1072
Joined: Fri Oct 28, 2005 2:27 am


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 58 guests