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,
DataLinks with ADO in FiveWin
-
- Posts: 254
- Joined: Sun Nov 06, 2005 3:55 pm
- Location: Southern California, USA
- Contact:
DataLinks with ADO in FiveWin
Thanks,
Byron Hopp
Matrix Computer Services
Byron Hopp
Matrix Computer Services
Hi Byron,
your code:
is working for me, you can see the image
[img]
http://img300.imageshack.us/my.php?image=sshot1nb8.png
[/img]
Regards,
Felix
your code:
Code: Select all
Local oDataLink := CreateObject("Datalinks")
Local oConn := oDataLink:PromptNew()
[img]
http://img300.imageshack.us/my.php?image=sshot1nb8.png
[/img]
Regards,
Felix
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)