Professional Web Applications Themes

How should I connect from VB to SQL Server? - Microsoft SQL / MS SQL Server

Hi, If u r using ASP it is better to use ADODB. make use of the connection provider I think the provider is sqloledb the connection string should be like the following "Provider = sqloledb.1;UserId = sa;Password=;DataSource=ServerName ;Initial catalog =DBName" LIN "Erik" <com> wrote in message news:e54#phx.gbl...  a  ..NET).  very  answer ...

  1. #1

    Default Re: How should I connect from VB to SQL Server?

    Hi,

    If u r using ASP it is better to use ADODB.
    make use of the connection provider
    I think the provider is sqloledb
    the connection string should be like the following

    "Provider = sqloledb.1;UserId = sa;Password=;DataSource=ServerName ;Initial
    catalog =DBName"

    LIN


    "Erik" <com> wrote in message
    news:e54#phx.gbl... 

    ..NET). 
    very 
    answer 


    LIN Guest

  2. #2

    Default Re: How should I connect from VB to SQL Server?

    Hi Erik,

    If you need a bunch of info on this, take a look at our WBC911 course info
    at www.whitebearconsulting.com (under courseware).

    It specifically covers lots of issues in using VB6/SQL Server and directly
    applies to VB Script (ASP) as well.

    HTH,


    --
    Greg Low (MVP)
    MSDE Manager SQL Tools
    www.whitebearconsulting.com

    "Erik" <com> wrote in message
    news:e54%phx.gbl... 

    ..NET). 
    very 
    answer 


    Greg Guest

  3. #3

    Default Re: How should I connect from VB to SQL Server?

    Erik,

    How to Access SQL Server in Active Server Pages
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;169377

    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Erik" <com> wrote in message
    news:e54%phx.gbl... 

    ..NET). 
    very 
    answer 


    Dinesh.T.K Guest

Similar Threads

  1. Can't connect to Apache Server (jrun server not found)
    By TwistedMind1979 in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: June 16th, 08:58 PM
  2. Replies: 2
    Last Post: September 12th, 10:44 PM
  3. Replies: 0
    Last Post: August 23rd, 05:27 PM
  4. Replies: 1
    Last Post: September 27th, 09:18 PM
  5. Replies: 0
    Last Post: July 1st, 02:04 PM

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