Re: NEWBIE - SQL Connection not working when app is installed on another machine

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dave (nospam_at_yahoo.com)
Date: 10/29/04

  • Next message: Kevin Yu [MSFT]: "Re: NEWBIE - SQL Connection not working when app is installed on another machine" 
    Date: Fri, 29 Oct 2004 16:16:44 -0400

    Kevin,

    Thanks for your willingness to help. Below is my connection string:

    workstation id=xxxx;packet size=4096;user id=sa;data
    source="CARDASIA-NEW";persist security info=True;initial
    catalog=NOVA;password=xxxxx

    This connection string works fine locally. In this instance, I am using SQL
    authentication.

    Thanks,

    -Dave

    "Kevin Yu [MSFT]" <v-kevy@online.microsoft.com> wrote in message
    news:QBE3WvVvEHA.3984@cpmsftngxa10.phx.gbl...
    > Hi Dave,
    >
    > First of all, I would like to confirm my understanding of your issue. From
    > your description, I understand that you received a "Invalid Element Value"
    > exception when trying to get data from a SQL Server. If there is any
    > misunderstanding, please feel free to let me know.
    >
    > Based on my experience, this exception might be thrown when there is
    > something wrong with the connection string. Please try to check if you're
    > using quotes outside the data source names or other elements. What kind of
    > authentication are you using? SQL authentication or Windows integrated?
    > Could you please post your connection string here, so that we can deliver
    > our assistance more quickly.
    >
    > Kevin Yu
    > =======
    > "This posting is provided "AS IS" with no warranties, and confers no
    > rights."
    >

  • Next message: Kevin Yu [MSFT]: "Re: NEWBIE - SQL Connection not working when app is installed on another machine"

    Relevant Pages

    • Re: VB code for filtering mail merge
      ... SQL statement area. ... The filtering options I selected while recording that macro did produce the ... What actually works depends largely on the data source and partly on the ... Connection string so that when you try to re-execute the recorded macro, ...
      (microsoft.public.word.mailmerge.fields)
    • Re: VB code for filtering mail merge
      ... Peter thank you very much. ... database icon to select your Word data source, specify query options, then ... field and you should see what the SQL looks like. ... Connection string so that when you try to re-execute the recorded macro, ...
      (microsoft.public.word.mailmerge.fields)
    • Re: VB code for filtering mail merge
      ... record in the macro recorder in Word 2002/3. ... database icon to select your Word data source, specify query options, then ... field and you should see what the SQL looks like. ... Connection string so that when you try to re-execute the recorded macro, ...
      (microsoft.public.word.mailmerge.fields)
    • Re: How to prevent connection string from user?
      ... I directly send connection string to DB then another ... > can filter my account and password. ... When you want to connect with Windows authentication, ... the desired SQL Server login needs to be specified. ...
      (microsoft.public.sqlserver.security)
    • Re: Can no longer connect as sa
      ... > Is there a reason you need to connect using SQL authentication? ... >> Login failed for user 'sa'. ... >> I can't figure out what is slightly different in the connection string. ...
      (microsoft.public.sqlserver.setup)