ADP & ODBC

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!!!
 
S

Sylvain Lafontaine

ADP don't use ODBC but OLEDB and it's also a better idea to use TCP/IP
instead of a named pipe. Instead of \\ServerName, try using ServerName or
even better, its TCP/IP address.

If you have still trouble connecting, then create an alias with the
SQL-Server Network Tool (not sure of the translation) and use it.

It's also possible that the type of login you are using it not OK for
accessing SQL-Server over the LAN.
 
A

ar013871 via AccessMonster.com

What do you mean by OLEDB? Where would I set that up?

Sylvain said:
ADP don't use ODBC but OLEDB and it's also a better idea to use TCP/IP
instead of a named pipe. Instead of \\ServerName, try using ServerName or
even better, its TCP/IP address.

If you have still trouble connecting, then create an alias with the
SQL-Server Network Tool (not sure of the translation) and use it.

It's also possible that the type of login you are using it not OK for
accessing SQL-Server over the LAN.
Okay, I'm just about at my wits end trying to get this to work. Here is
our
[quoted text clipped - 16 lines]
What am I doing wrong? Please help!!!
 
A

ar013871 via AccessMonster.com

Is it possible to have a SQL back end w/ Microsoft front end and not use ADP?
I know that if we do get te ADP connection to work (one computer w/ ADP file
connecting to SQL server back end, both on a LAN) then some of the queries we
have will need to be re-worked. We're finding out that in ADP you cannot
have queries based on information a user enters/selects on a form.

Sylvain said:
ADP don't use ODBC but OLEDB and it's also a better idea to use TCP/IP
instead of a named pipe. Instead of \\ServerName, try using ServerName or
even better, its TCP/IP address.

If you have still trouble connecting, then create an alias with the
SQL-Server Network Tool (not sure of the translation) and use it.

It's also possible that the type of login you are using it not OK for
accessing SQL-Server over the LAN.
Okay, I'm just about at my wits end trying to get this to work. Here is
our
[quoted text clipped - 16 lines]
What am I doing wrong? Please help!!!
 
S

Sylvain Lafontaine

From the File -> Connection menu.

If you are really new to SQL-Server and ADP, maybe using a MDF file with
linked tables would be a better idea than starting with an ADP project.

You can choose between these two options (ADP vs Linked Tables) when you are
using the Upsizing Wizard.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


ar013871 via AccessMonster.com said:
What do you mean by OLEDB? Where would I set that up?

Sylvain said:
ADP don't use ODBC but OLEDB and it's also a better idea to use TCP/IP
instead of a named pipe. Instead of \\ServerName, try using ServerName or
even better, its TCP/IP address.

If you have still trouble connecting, then create an alias with the
SQL-Server Network Tool (not sure of the translation) and use it.

It's also possible that the type of login you are using it not OK for
accessing SQL-Server over the LAN.
Okay, I'm just about at my wits end trying to get this to work. Here is
our
[quoted text clipped - 16 lines]
What am I doing wrong? Please help!!!
 
A

aaron.kempf

ADP is vastly superior. dont go to MDB

for the record; can't you just right-click link; files of type = ODBC
in ADP?

i mean seriously here

if it doesn't work for you; go in Enterprise Manager and set up a
linked server... be sure to set up the authentication / security for
that linked server also
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top