Thank you, Craig.
>. means local server. You can also use (local)
>
>I would leave out the version number.
>
>>Hi,
>>
>>I am making some baby steps in learning to use CursorAdapter with DataSourceType 'ADO'. But I need to understand better a few things:
>>
>>1. This is the sample connection string (that works):
>>
>>.ConnectionString = 'Driver={SQL Server Native Client 10.0};Trusted_connection=Yes;Server=.;database=MYDatabase'
>>>>
>>Does the period (.) after Server=. mean "default" server name? I have only one server on this PC so it works and this is why I assumed that this is what it means. I also tried to replace the period (.) with the name of the server and it works too.
>>
>>2. If I replace the 'SQL Server Native Client 10.0' with 'SQL Server Native Client' the connection still works. Is it better to always specify the version of the native client or leave it out and rely on the default setting?
>>
>>TIA.
"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
