Community discussion forum

Help in using data link

• • Reply

  8 months ago

  by HazLex14

  Hazlex Panis

  Bataan/Caloocan, Philippines

  Joined 1 year ago
  Im working on with building a database connection at runtime, and i've done it in visual basic 6 using datalink and i only want the connection string from it, but im having a problem getting the connection string using datalink in vb2005, here are some of the code i used: Dim oDataLinks, sRetVal oDataLinks = CreateObject("DataLinks") On Error Resume Next ' Trap Cancel button sRetVal = oDataLinks.PromptNew On Error Goto 0 varConStr = sRetVal ' conversion from type connection to type string is invalid ' if converted to string it only returns "System.__ComObject" oDataLinks = Nothing how can i get the connection string, could someone help me?...i really want to know how...
  Report abuse