| Author |
Topic |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2007-11-30 : 09:59:27
|
| i installed ODBC drivers from openlink-install. and i don't know how to configure from ODBC from control panel. Test connection has failed. What are things i have to take care of. |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-30 : 10:01:09
|
Why did you start a new post? You need to provide more information for us to help you, we simply cannot help you without it.
Future guru in the making. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-11-30 : 10:04:18
|
| Ok installed ODBC drivers on one SQL server box. but when i am trying to configure from Admin tool-ODBC -system DSN -database-The test connection is failing. What exactly i have to put while configure becoz the connection is failing. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-30 : 10:07:40
|
What does it say in the box when it fails? It should indicate a reason for failure.
Future guru in the making. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-11-30 : 10:11:51
|
| It says connection failed even with my user account. while configuring system DSN , do i need to put database name .I put everything but still failed. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-30 : 10:15:41
|
First, are you planning to connect using SQL Authentication or Windows NT Authentication? You need to know the connection method on the SQL Server and then pick the appropriate choice in the ODBC configuration. If you select SQL Server Auth. you will want to check "Connect to SQL Server to Obtain default settings for the additional configuration options" checkbox and then type in the login ID and password for SQL Server.
Future guru in the making. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-11-30 : 10:40:40
|
| I tried with SQL authentication with my user account but its failing |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-30 : 10:52:56
|
If you selected SQL Authentication and put in a username and password it would fail prior to the test if that was the issue. Have you clicked on Client Configuration and checked the properties there? By default it will use TCP/IP, the server name should be in there also (or IP) and the port will be dynamic (1433) in grey. What you need to make sure of is that the server name is correct and that you can reach the server by the name from the machine you are configuring (test it with PING). Also, if you have a port other then 1433 configured for SQL Server you may want to plug it in. Also, you can check your surface area configurations on the SQL Server and make sure you are allowing remote connections.
Future guru in the making. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-11-30 : 10:56:38
|
| Thanks a lot |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-11-30 : 12:23:16
|
| Still didn't work . Actually its ODBC for openlink. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-30 : 14:10:27
|
Not familiar with it, sorry.
Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 00:09:51
|
| Does openlink use SQL authentication? Don't thinks, sounds nothing to do with sql server at all. |
|
|
|
|
Urgent ODBC help