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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB6 Component Issue with TDBGRID 0
ViewSonic VP16-OLED Unboxing: High-End Portable Monitor Designed for Creators 2
Access OLE Object error in Access 2010 2
Access Can't start the OLE server...? 0
Transmitting Outlook data to a web server 2
Restart OLE Server??? 1
troubles with dns-less connection to sql 0
Exchange Rooms Calendar 1

Back
Top