none
Remote Oledb Connection RRS feed

  • Question

  • Hi All,

     

    I am unable to connect to SQL Server 2000 with oledb as a remote client. The IP addresses are correctly routed (i can ping the server) but there is no connection.

     

    I am using VB2005 EE.

     

    Could some one help.

    Friday, June 8, 2007 12:31 PM

All replies

  • Silly question but how do you know there is no connection?  Did you get an error, did you try to query and also why are you using oledb when you can use sqlclient?  Sorry for all the questions but we need a little more info Smile
    Friday, June 8, 2007 2:10 PM
  • I connect to the server to get user authentication. It says: Server not found or access denied!

    Regards

    Saturday, June 9, 2007 1:00 AM
  • Goto www.connectionstrings.com and make sure that the connection string you are using is correctly formatted.
    Sunday, June 10, 2007 6:03 AM
  • Hi Ehmer,
        I am moving this thread from Visual Basic Express Edition forum to the .NET Framework Data Access and Storage forum, since the issue is related to Connection string. There are more ADO.net experts in the .NET Framework Data Access and Storage forum.
    Thanks for your understanding!
    Monday, June 11, 2007 7:41 AM
  • Dear Feng,

     

    Could you please tell me if it is possible or not? I have a client waiting for reply!

     

    Thanks and regards,

    Ehmer

    Monday, June 11, 2007 9:23 AM