-
Jul 19th, 2012, 07:10 AM
#1
Thread Starter
Junior Member
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.
-
Jul 19th, 2012, 07:34 PM
#2
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 ...
-
Jul 20th, 2012, 01:14 AM
#3
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?
-
Jul 21st, 2012, 02:22 AM
#4
-
Jul 21st, 2012, 03:11 AM
#5
Thread Starter
Junior Member
Re: problem in connecting Databas trhough ODBC
Originally Posted by DataMiser
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.
-
Jul 21st, 2012, 09:26 AM
#6
Re: problem in connecting Databas trhough ODBC
Originally Posted by firoz.raj
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.
-
Jul 22nd, 2012, 02:54 AM
#7
Frenzied Member
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 .
-
Jul 22nd, 2012, 08:14 AM
#8
Re: problem in connecting Databas trhough ODBC
Originally Posted by firoz.raj
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.
-
Jul 24th, 2012, 02:43 AM
#9
New Member
Re: problem in connecting Databas trhough ODBC
perhaps your firewall on the database server is not configured to accept incoming connections,
-
Aug 19th, 2012, 09:25 AM
#10
Thread Starter
Junior Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|