Hey Gurus,
I am trying to install a mini-network with two machines on it, one of
the machines has sql server 2008 enterprise evaluation edition and the
other will be the client
when we are trying to open an odbc connection between the two we get the
following error sql state 01000 error 233 and error 11....Remember this
is an evaluation edition... According to msdn the error 233 means that
there is no process at the other end?? and 11 means that there is no
description??
Is this due to the edition or is it the network?? or something else
Google has no answer
help please


Wisord

*** Sent via Developersdex http://www.developersdex.com ***

Did you try anything other than ODBC? How exactly are you "opening an odbc
connection"? Did you try both server name and local IP address? What
happens when you try to connect via Management Studio, or C#, or even
VBScript using OLEDB e.g. open notepad, paste the following, save as x.vbs
and double-click:



set conn = CreateObject("ADODB.Connection")
connstr = "Provider=SQLOLEDB.1; " & _
"Data Source = <ip address of DB server>;" & _
"User ID = <username>;" & _
"Password = <password>;" & _
"Network = DBMSSOCN;"
on error resume next
conn.open connstr
if err.number <> 0
msgbox err.description
else
msgbox "Connected fine."
conn.close : set conn = nothing





On 8/18/09 3:00 PM, in article etTv1YDIKHA.4004 (AT) TK2MSFTNGP05 (DOT) phx.gbl,
"Bill_Orova" <nospam (AT) devdex (DOT) com> wrote: