"Charles" <dengcharles@hotmail.com> wrote in message
news:bede28a1.0410181839.407a62c9@posting.google.com...
> Hi Sue,
>
> Thank you for interest to my quiz.
>
> No, "Dbnetlib" is not the only issue in my shoes.
> 1) My problem was caused by DNS server problem - I connect to a remote
> SQL Server 2000 in an intranet environment, in my local machine, after
> I add the following line in "C:\Windows\system32\drivers\etc\host"
> file
> 20.230.193.48 mydbservername
> I have not problem at all with both "dbmssocn"/"dbnetlib"
> 2) Interested thing is:
> If I use "dbnetlib" and DO NOT add "20.230.193.48 mydbservername" in
> "host" file, my program sometimes don't work (first run), and works
> perfectly after that.
> Of course if I use "dbmssocn" and DO NOT add "20.230.193.48
> mydbservername" in "host" file, my program will never work (Error
> message "SQL Server does not exist or access denied")
>
> I am confused by "dbnetlib" behavior.
>
> Thanks again
>
>
> Sue Hoegemeier <Sue_H@nomail.please> wrote in message
> news:<4ma6n0t3fdft4tkp7eak0n5d5rfsloqphm@4ax.com>...
>> Dbmssocn is the old TCP/P network library. Dbnetlib is the
>> new TCP/IP network library. Your MDAC versions probably
>> changed with the update to Excel XP.
>>
>> -Sue
>>
>> On 14 Oct 2004 17:06:18 -0700, dengcharles@hotmail.com
>> (Charles) wrote:
>>
>> >Hi All,
>> >
>> >An interest question about "Network Library=dbmssocn" in connection
>> >string.
>> >
>> >I have a Excel VBA application which I used to connect to SQL Server
>> >2000 server. my connection string is:
>> >"Provider=SQLOLEDB; Data Source=servername; Initial Catalog=dbname;
>> >User ID=username; Password=pwd; Network Library=dbmssocn"
>> >
>> >This string worked perfectly in Excel 2000, but after I update to
>> >Excel XP, I got the following error message
>> >
>> >[DBNETLIB]connectionOpen(Connect()) SQL Server does not exist or
>> >access denied.
>> >
>> >After I delete the above "Network Library=dbmssocn" info, it works
>> >again. I look online but can't find answer. Can anybody tell me why? I
>> >am using WinXP.
>> >
>> >Kind Regards,
>> >
>> >Charles

<rx330@online.nospam> wrote in message
news:OGvrgMttEHA.2956@TK2MSFTNGP12.phx.gbl...
>I have similar problem that occurs after I installed XP SP2. My program
>start to throw "[DBNETLIB][ConnectionOPen (Connect()).]SQL Server does not
>exist or access denied"
> If I switch to name piped it works fine but my client net work only use
> TCP/IP. I will try your DNS/Host file entry to see if this resolve this
> problem.
> Any other suggestion is welcome because I need to have this resolve
> soon...
> Thanks,
> Vinh,
>
> "Charles" <dengcharles@hotmail.com> wrote in message
> news:bede28a1.0410181839.407a62c9@posting.google.com...
>> Hi Sue,
>>
>> Thank you for interest to my quiz.
>>
>> No, "Dbnetlib" is not the only issue in my shoes.
>> 1) My problem was caused by DNS server problem - I connect to a remote
>> SQL Server 2000 in an intranet environment, in my local machine, after
>> I add the following line in "C:\Windows\system32\drivers\etc\host"
>> file
>> 20.230.193.48 mydbservername
>> I have not problem at all with both "dbmssocn"/"dbnetlib"
>> 2) Interested thing is:
>> If I use "dbnetlib" and DO NOT add "20.230.193.48 mydbservername" in
>> "host" file, my program sometimes don't work (first run), and works
>> perfectly after that.
>> Of course if I use "dbmssocn" and DO NOT add "20.230.193.48
>> mydbservername" in "host" file, my program will never work (Error
>> message "SQL Server does not exist or access denied")
>>
>> I am confused by "dbnetlib" behavior.
>>
>> Thanks again
>>
>>
>> Sue Hoegemeier <Sue_H@nomail.please> wrote in message
>> news:<4ma6n0t3fdft4tkp7eak0n5d5rfsloqphm@4ax.com>...
>>> Dbmssocn is the old TCP/P network library. Dbnetlib is the
>>> new TCP/IP network library. Your MDAC versions probably
>>> changed with the update to Excel XP.
>>>
>>> -Sue
>>>
>>> On 14 Oct 2004 17:06:18 -0700, dengcharles@hotmail.com
>>> (Charles) wrote:
>>>
>>> >Hi All,
>>> >
>>> >An interest question about "Network Library=dbmssocn" in connection
>>> >string.
>>> >
>>> >I have a Excel VBA application which I used to connect to SQL Server
>>> >2000 server. my connection string is:
>>> >"Provider=SQLOLEDB; Data Source=servername; Initial Catalog=dbname;
>>> >User ID=username; Password=pwd; Network Library=dbmssocn"
>>> >
>>> >This string worked perfectly in Excel 2000, but after I update to
>>> >Excel XP, I got the following error message
>>> >
>>> >[DBNETLIB]connectionOpen(Connect()) SQL Server does not exist or
>>> >access denied.
>>> >
>>> >After I delete the above "Network Library=dbmssocn" info, it works
>>> >again. I look online but can't find answer. Can anybody tell me why? I
>>> >am using WinXP.
>>> >
>>> >Kind Regards,
>>> >
>>> >Charles
>
>

On Mon, 25 Oct 2004 09:15:35 -0400, <rx330@online.nospam> wrote:

>After further testing it's the DBNETLIB that works and the dbmssocn will not
>work. So the question would be how to find out which driver to use?
>by ADO version or OS version? if so anyone have a suggestion on how to
>detect what ADO version is running on the machine in Delphi code?
>Thanks,
>Vinh,
>
><rx330@online.nospam> wrote in message
>news:OGvrgMttEHA.2956@TK2MSFTNGP12.phx.gbl...
>>I have similar problem that occurs after I installed XP SP2. My program
>>start to throw "[DBNETLIB][ConnectionOPen (Connect()).]SQL Server does not
>>exist or access denied"
>> If I switch to name piped it works fine but my client net work only use
>> TCP/IP. I will try your DNS/Host file entry to see if this resolve this
>> problem.
>> Any other suggestion is welcome because I need to have this resolve
>> soon...
>> Thanks,
>> Vinh,
>>
>> "Charles" <dengcharles@hotmail.com> wrote in message
>> news:bede28a1.0410181839.407a62c9@posting.google.com...
>>> Hi Sue,
>>>
>>> Thank you for interest to my quiz.
>>>
>>> No, "Dbnetlib" is not the only issue in my shoes.
>>> 1) My problem was caused by DNS server problem - I connect to a remote
>>> SQL Server 2000 in an intranet environment, in my local machine, after
>>> I add the following line in "C:\Windows\system32\drivers\etc\host"
>>> file
>>> 20.230.193.48 mydbservername
>>> I have not problem at all with both "dbmssocn"/"dbnetlib"
>>> 2) Interested thing is:
>>> If I use "dbnetlib" and DO NOT add "20.230.193.48 mydbservername" in
>>> "host" file, my program sometimes don't work (first run), and works
>>> perfectly after that.
>>> Of course if I use "dbmssocn" and DO NOT add "20.230.193.48
>>> mydbservername" in "host" file, my program will never work (Error
>>> message "SQL Server does not exist or access denied")
>>>
>>> I am confused by "dbnetlib" behavior.
>>>
>>> Thanks again
>>>
>>>
>>> Sue Hoegemeier <Sue_H@nomail.please> wrote in message
>>> news:<4ma6n0t3fdft4tkp7eak0n5d5rfsloqphm@4ax.com>...
>>>> Dbmssocn is the old TCP/P network library. Dbnetlib is the
>>>> new TCP/IP network library. Your MDAC versions probably
>>>> changed with the update to Excel XP.
>>>>
>>>> -Sue
>>>>
>>>> On 14 Oct 2004 17:06:18 -0700, dengcharles@hotmail.com
>>>> (Charles) wrote:
>>>>
>>>> >Hi All,
>>>> >
>>>> >An interest question about "Network Library=dbmssocn" in connection
>>>> >string.
>>>> >
>>>> >I have a Excel VBA application which I used to connect to SQL Server
>>>> >2000 server. my connection string is:
>>>> >"Provider=SQLOLEDB; Data Source=servername; Initial Catalog=dbname;
>>>> >User ID=username; Password=pwd; Network Library=dbmssocn"
>>>> >
>>>> >This string worked perfectly in Excel 2000, but after I update to
>>>> >Excel XP, I got the following error message
>>>> >
>>>> >[DBNETLIB]connectionOpen(Connect()) SQL Server does not exist or
>>>> >access denied.
>>>> >
>>>> >After I delete the above "Network Library=dbmssocn" info, it works
>>>> >again. I look online but can't find answer. Can anybody tell me why? I
>>>> >am using WinXP.
>>>> >
>>>> >Kind Regards,
>>>> >
>>>> >Charles
>>
>>
>