Results 1 to 3 of 3

Thread: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

  1. #1

    Default [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

    Hi,

    While browsing the website I am getting error
    Microsoft OLE DB Provider for SQL Server error '80004005'

    [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

    /includes/databaseFunctions.asp, line 22

    I am using ADODB connection object and OLEDB connection string
    like
    Set cnn = Server.CreateObject("ADODB.Connection")
    cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DAT ABASE=mydatabase "

    Please help...

  2. #2

    Default

    Hello ,

    You will need to check if you are using correct Data Source name in your connection string. If you are using localhost then try to use IP address of dedicated server. If you have SQL server with the Instance then use instance name with the server Ip in your connection string.

    Regards,
    Niraj

  3. #3

    Default

    Hi,

    I have changed the data source name with the SQL server name with the instance and its start working.

    Thank you very much for your help.

Posting Permissions

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