Professional Web Applications Themes

ADODB Cmd with DSN - Microsoft SQL / MS SQL Server

To add to Edwin's response: Dim oCmd As ADODB.Command Dim oCnn As ADODB.Connection Set oCnn = New ADODB.Connection oCnn.Open "DSN=MyDSN;UID=User1;PWD=qwerty" Set oCmd = New ADODB.Command Set oCmd.ActiveConnection = oCnn -- Hope this helps. Dan Guzman SQL Server MVP ----------------------- SQL FAQ links (courtesy Neil Pike): http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800 http://www.sqlserverfaq.com http://www.mssqlserver.com/faq ----------------------- "Maligor" <net> wrote in message news:phx.gbl...  User1  doesnt ...

  1. #1

    Default Re: ADODB Cmd with DSN

    To add to Edwin's response:

    Dim oCmd As ADODB.Command
    Dim oCnn As ADODB.Connection
    Set oCnn = New ADODB.Connection
    oCnn.Open "DSN=MyDSN;UID=User1;PWD=qwerty"
    Set oCmd = New ADODB.Command
    Set oCmd.ActiveConnection = oCnn

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
    http://www.sqlserverfaq.com
    http://www.mssqlserver.com/faq
    -----------------------

    "Maligor" <net> wrote in message
    news:phx.gbl... 
    User1 
    doesnt 


    Dan Guest

  2. #2

    Default Re: ADODB Cmd with DSN

    Okie thx to both.... ive already try this and you were right... thats my
    fault I didnt debug far enought to find the real problem that I have found
    now!

    Im using the command object to retrieve an Output Stream and while using a
    DSN its saying that:

    "Current provider does not support output streams"

    if im using this connection: "DSN=MyDSN;UID=User1;PWD=qwerty"

    But if im using this one (not using the DSN tho....)

    :"provider=sqloledb;data source=MyServer;initialcatalog=DB;user
    id=User1;password=qwerty;"

    it WORKs! but this is not using the DSN so.... Any way to get Output stream
    with a DSN?

    "Maligor" <net> wrote in message
    news:phx.gbl... 
    User1 


    Maligor Guest

Similar Threads

  1. ADODB Connection
    By JW in forum ASP Database
    Replies: 2
    Last Post: September 27th, 03:44 PM
  2. ADODB Insalation??? HOW????
    By Clint Bailey in forum PHP Development
    Replies: 2
    Last Post: September 18th, 04:35 PM
  3. adodb and php5
    By Gilberto Garcia Jr. in forum PHP Development
    Replies: 1
    Last Post: September 8th, 08:56 PM
  4. [PHP] adodb and php5
    By Jay Blanchard in forum PHP Development
    Replies: 1
    Last Post: September 8th, 08:55 PM
  5. ADODB connections
    By Jon Kraft in forum PHP Development
    Replies: 0
    Last Post: July 15th, 09:38 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139