How do i connect to a server using OLE DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access Database on a server, how can I connect to this and get
information from it to be displayed within Outlook? I am using Outlook 2000!
 
The easiest way is to create a connection using ODBC manager in the control
panel then reference the saved connection in you OLEDB connect string. This
will allow you to test the connection before trying to work with it in code.

You can also get the full connect string from the UDL editor. Create a text
file in any convenient place and rename it to filename.udl. Be sure the
extension is udl and not txt. double click on the file and the UDL editor
will open. After browsing to the connection type and file and testing the
connection you can open the file as a text file and it will have a complete
copy of the connect string for you to cut and paste into your code.
 
Back
Top