A
ar013871
Okay, I'm just about at my wits end trying to get this to work. Here is our
setup:
Windows Server 2003 w/ Microsoft SQL server version 8.0. We have a database
setup on the SQL Server along with an ADP project. The ADP project works as
expected. I copied the project and pasted it onto another computer w/n the
same network. I'm still a newbie with ADP and my instincts told me that in
order to connect to the SQL there needs to be an ODBC connection of some sort.
I tried creating that and I keep getting the error that the SQL Server
doesn't exist or I don't have access. I can ping the server with no problem
and made sure the server was listed as \\ServerName.
What am I doing wrong? Please help!!!
setup:
Windows Server 2003 w/ Microsoft SQL server version 8.0. We have a database
setup on the SQL Server along with an ADP project. The ADP project works as
expected. I copied the project and pasted it onto another computer w/n the
same network. I'm still a newbie with ADP and my instincts told me that in
order to connect to the SQL there needs to be an ODBC connection of some sort.
I tried creating that and I keep getting the error that the SQL Server
doesn't exist or I don't have access. I can ping the server with no problem
and made sure the server was listed as \\ServerName.
What am I doing wrong? Please help!!!