what is function of -> Myconnection.Provider

Results 1 to 2 of 2

Thread: what is function of -> Myconnection.Provider

  1. #1
    Chang Cao Zen Guest

    Default what is function of -> Myconnection.Provider

    I want to ask about this script :<BR><BR>Set Myconnection= createobject("ADODB.Connection")<BR>Myconnection.p rovider " xxxxxxx"<BR><BR><BR>i got error on -&#062; Myconnection.provider " xxxxxxx"<BR><BR>and i dont know what is funtion of .provider ?<BR><BR>thanks for helping<BR>Chang Cao Zen<BR><BR><BR><BR>

  2. #2
    rick@fortiers.com Guest

    Default RE: what is function of -> Myconnection.Provi

    Provider can be used when you using a linked server. This means that you can make it appear that you are querying one server when actually you are linking to another. This is for OLE DB.<BR>Why do you think that you need it?<BR><BR>Look for help on sp_addlinkedserver on the web.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts