R
Rob
Hi Everyone,
First, if MSDE 2000 is (local) on trusted NT credentials on my machine, I
can connect to it from Access just fine. But later I may wish to experiment
with TCP/IP and/or Named Pipes. To that eventual end, there is something
I'm noticing when my Access 2000 launches: it's trying to go to Destination
IP: 255.255.255.255, Port 1434.
I have MSDE 2000 on 192.168.0.1, Port 1433 on a local loopback. Is this the
reason why Access keeps throwing variations on this pie in my face:
[Pipes or TCP/IP Sockets]SQL Server does not exist or access denied.
[Pipes or TCP/IP Sockets]ConnectionOpen (Connect()).
My second question is: Where--in which directory--is NorthwindCS.sql
supposed to reside in order to get recognized by NorthwindCS.adp?
(I've never done this Access to SQL Server stuff before.) Thank you for any
assistance that you can provide.
First, if MSDE 2000 is (local) on trusted NT credentials on my machine, I
can connect to it from Access just fine. But later I may wish to experiment
with TCP/IP and/or Named Pipes. To that eventual end, there is something
I'm noticing when my Access 2000 launches: it's trying to go to Destination
IP: 255.255.255.255, Port 1434.
I have MSDE 2000 on 192.168.0.1, Port 1433 on a local loopback. Is this the
reason why Access keeps throwing variations on this pie in my face:
[Pipes or TCP/IP Sockets]SQL Server does not exist or access denied.
[Pipes or TCP/IP Sockets]ConnectionOpen (Connect()).
My second question is: Where--in which directory--is NorthwindCS.sql
supposed to reside in order to get recognized by NorthwindCS.adp?
(I've never done this Access to SQL Server stuff before.) Thank you for any
assistance that you can provide.