|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
August 29th, 2003, 02:44 PM
|
|||
|
|||
|
Having problams setting up a SQL server with ODBC
Having problems with SQL server 2000 (trail, dunno if it matters).
I am trying to set up a server and i get this error ============ Connection failed: SQLState: '01000' SQL Server Error: 2 [Microsoft][ODBC SQL Driver][Shared Memory]ConnectionOpen (Connection()) Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Driver][Shared Memory]SQL Server does not exist or access denied. ============ Anyone have any ideas?? Running XP pro with norton anti-virus and Personal Firwall (but i tried it with the Firewall dissabled and no joy) If you need more info just ask Thanx, Snowball
|
|
#2
August 29th, 2003, 08:45 PM
|
||||
|
||||
|
I think the trial version does matter. I am presuming you are trying to access it across a network, and I think the trial version doesn't allow that. Run 'netstat -an' and see if anything (actually, I believe you can add the flag 'o' (not zero!) and get the PID of the process that owns the port and check with task manager and see if that is SQLServer) is listening on port 1433, the default for SQLServer. If you are trying to access from on the same machine you may have provided an invalid username and/or password. Try to make a connection directly via an ODBC DSN, there is a tab to check the connection. You can also try to run Query Analyzer and try to connect and see what you get.
__________________
Left DevShed May 28, 2005. Reason: Unresponsive administrators. Free code: http://sol-biotech.com/code/. Secure Programming: http://sol-biotech.com/code/SecProgFAQ.html. Performance Programming: http://sol-biotech.com/code/PerformanceProgramming.html. It is not that old programmers are any smarter or code better, it is just that they have made the same stupid mistake so many times that it is second nature to fix it. --Me, I just made it up The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore, all progress depends on the unreasonable man. --George Bernard Shaw
|
|
#4
August 31st, 2003, 01:41 PM
|
|||
|
|||
|
Can you connect using Enterprise Manager?
The error looks like you may have selected an incorrect provider in your connection information. You should use the OLEDB Provicer for SQL Server if possible, or for ODBC use the SQL Server ODBC driver.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Having problams setting up a SQL server with ODBC |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
