Page 1 of 1

DataLinks with ADO in FiveWin

Posted: Tue Nov 14, 2006 4:09 am
by byron.hopp
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,

Posted: Tue Nov 14, 2006 9:36 am
by Baxajaun
Hi Byron,

your code:

Code: Select all

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

Posted: Sun Jan 27, 2008 8:01 pm
by hua
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

msginfo(oConn:ConnectionString)