To me the server name seems to be "questionable." In my experience the server name usually something like
computername\SQL2008 or computername\SQLEXPRESS. Check the name you see in the SSMS.
HTH.
>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
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
