You can still connect via SSMS now, correct?
Are you sure that SQL is (still) configured to allow remote connections in SQL configuration? Is TCP protocol enabled in SQL Configuration?
Is the SQL Browser service started in Services? Make sure it is. Set it to automatic.
>it worked yesterday!
>
>>Looks like the driver name isn't right. Look here
http://connectionstrings.com/sql-server-2008 for the ODBC connection string.
>>
>>>yesterday I installed SQL2008 developer
>>>
>>>I could connect with this:
>>>
>>>
>>>strConnectionString = [Driver={SQL Server};Server=OTT-LT1026;Database=kba_sql;Uid=sa;pwd=]
>>>strConnectionString = [Driver={SQL Server};Server=OTT-LT1026;Database=kba_sql;Trusted Connection]
>>>
>>>strSQL = [select * from claims where 1=1 ] && or what ever sql statement you are passing.
>>>csrCursorToBeReturned = [csrNames]
>>>
>>>intHandle = SQLSTRINGCONNECT(strConnectionString)
>>>
>>>intResults = SQLEXEC(intHandle, strSQL, csrCursorToBeReturned)
>>>
>>>
>>>
>>>today it times out
>>>with SQL management studio I connect just fine
>>>
>>>what could be wrong?
>>>
>>>Peter
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________