Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skumar
Starting Member
10 Posts |
 Posted - 2006-08-24 : 09:20:18
|
| Hi guys,i'm trying to create a data source using Sql server (which is on a different server).after creating a system DSN, test connnection works fine. but when i'm trying to access a table, it give me an error: "Your server does not have a sql connection option, please check with your system admin"..Now, i have already checked my MSSQLSERVER service which shows "Started"..i have tried the same thing on my PC where SQL server is on the same machine, i have created the DSN and it works fine... i'm doing the same for the servers but i get error...Please HELP!!!Thanx |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-08-24 : 10:50:24
|
| Check to see if you have a fire wall and port 1433 is open |
 |
|
|
skumar
Starting Member
10 Posts |
Posted - 2006-08-24 : 11:23:02
|
| there is no fire wall; and port 1433 is not in use... cann't see in list when i did, netstat |
|
|
|
skumar
Starting Member
10 Posts |
Posted - 2006-08-24 : 15:56:02
|
| got it... thanx though |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-08-24 : 17:20:44
|
quote:
Originally posted by skumar
got it... thanx though
...mind sharing the solution ??? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-25 : 01:37:54
|
| Post your connection string here. and the query.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Server does not have a sql connection