Results 1 to 10 of 10

Thread: problem in connecting Databas trhough ODBC

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jun 2012
    Posts
    23

    problem in connecting Databas trhough ODBC

    i am facing problem in connecting databas through my VB application.
    If I use application from the same comuputer where dabase resides then there is no problem. it connects and works. but when i run this application from different computer within a LAN, it do does not connect and raise error. I am trying to connect database through ODBC connection. I did try to establish ODBC from different computer but its unable to create and raise following error.

    Connection Failed
    SQL State '01000'
    SQL Server error 53
    [microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open connection Failed
    SQL Stat '08001
    SQL Error 17
    [microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does not exist or access denied.

    Awaiting for help.

  2. #2
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: problem in connecting Databas trhough ODBC

    It would be helpful if you post the code where you are connecting to the database
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

  3. #3
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    Re: problem in connecting Databas trhough ODBC

    Are you getting the error from your program or from the ODBC utility? Did you create a DSN via ODBC and test the connection?

    Is the PC the database is on set up to allow outside connections?

  4. #4
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    Smile Re: problem in connecting Databas trhough ODBC

    Why don't you use ado Control it is much better then old boredom way creating DSN Via ODBC ?

  5. #5

    Thread Starter
    Junior Member
    Join Date
    Jun 2012
    Posts
    23

    Re: problem in connecting Databas trhough ODBC

    Quote Originally Posted by DataMiser View Post
    Are you getting the error from your program or from the ODBC utility? Did you create a DSN via ODBC and test the connection?

    Is the PC the database is on set up to allow outside connections?
    i am not getting error from the program, i am getting error in configuring ODBC on the computer of my colleage who will run the application from his computer.

    However, on the computer where database resides, there is no problem in creating ODBC and running application on same computer using this ODBC.

  6. #6
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    Re: problem in connecting Databas trhough ODBC

    Quote Originally Posted by firoz.raj View Post
    Why don't you use ado Control it is much better then old boredom way creating DSN Via ODBC ?
    ado Control has nothing to do with it and I would not suggest using it. Always use ADO Code but the issue here is not the method but the connection.

    The problem here would seem to be the configuration of the database server itself.

    This thread should be moved to the database area.

  7. #7
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    Smile Re: problem in connecting Databas trhough ODBC

    ado Control has nothing to do with it and I would not suggest using it. Always use ADO Code but the issue here is not the method but the connection.

    The problem here would seem to be the configuration of the database server itself.

    This thread should be moved to the database area.

    i mean ado code not ado control . as he understood ! .what i said .

  8. #8
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    Re: problem in connecting Databas trhough ODBC

    Quote Originally Posted by firoz.raj View Post
    i mean ado code not ado control . as he understood ! .what i said .
    Why would you think that anyone understood that you meant ADO code when you said ADO Control? What was understodd is that this has nothing to do with the issue. If you can't connect to the DB via the ODBC manager then you are not going to get a connection from VB.

    BTW you can use ADO code and still use an ODBC DSN connection.

  9. #9
    New Member
    Join Date
    Sep 2002
    Location
    Philippines
    Posts
    11

    Re: problem in connecting Databas trhough ODBC

    perhaps your firewall on the database server is not configured to accept incoming connections,
    VbKid

  10. #10

    Thread Starter
    Junior Member
    Join Date
    Jun 2012
    Posts
    23

    Re: problem in connecting Databas trhough ODBC

    tanks for the help, my firewall was on.

Posting Permissions

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



Click Here to Expand Forum to Full Width