Post reply

Remote connection with vb script to SQL Server 2008 R2

  • March 19, 2012 at 5:27 pm

    #270388

    Hello.

    I'm trying to stablish a connection to a SQL Server 2008 R2 from a vb script based application, the connection that I'm using is:

    cnConTemp.Open "Provider=sqloledb;Server=BACCROCAN04\CANALESCRI;Database=Prueba;User ID=SQL_user;Password=SQL_Pass;Trusted_Connection=tue;"

    I belive that the problem is in the specification of the server because I used a PHP connection with the user and password and I don´t found a problem.

    Please help me.

  • March 19, 2012 at 11:24 pm

    #1461443

    http://www.connectionstrings.com/

    This should guide you.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • March 28, 2012 at 9:49 am

    #1465772

    Thank you Henrico Bekker.

    I used that web site; the connection works if I use a local server, but, when I use a remote server don't work.

    What could be?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply