Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

SQL SERVER

Discussion in 'Information Technology' started by Frank, Jul 28, 2006.

Tags:
  1. Frank

    Frank
    Expand Collapse
    Guest

    im trying to make a new database (entering new info) but it says that i can
    not connect because it iether does not exist or or its denied...how do i get
    the right server to log-in???
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Try making an ODBC connection and linking to the data. Use the wizard in the
    Control Panel to create a DSN to do it. Alternatively, you can use an OLEDB
    connection in code:

    strConnect = "Provider=SQLOLEDB;Data Source=ComputerName;" & _
    "Initial Catalog=SQLDBName;" & _
    "User ID=UserName;password=ItsASecret"
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Frank" <Frank@discussions.microsoft.com> wrote in message
    news:A106C653-9423-4F8F-82B7-4221090B59B1@microsoft.com...
    > im trying to make a new database (entering new info) but it says that i
    > can
    > not connect because it iether does not exist or or its denied...how do i
    > get
    > the right server to log-in???
     

Share This Page