MS Access project with SQL Server - connect adp project to sql express via LAN

Author

connect adp project to sql express via LAN

James Page

2006-03-06, 7:30 pm

Hi all

I need a bit of advice - I've created a FE using ADP the BE is on SQL Express.

Connecting to the BE on the same computer is fine, but i now need to connect
to the BE via a LAN.

I can't seem to find a simple guide on how to do this. any pointers would be
welcome.

Thanks

Alex Dybenko

2006-03-06, 7:30 pm

Hi,
idea is the same - in connection properties enter SQL Server name,
login/password and select database

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"James Page" < JamesPage@discussion
s.microsoft.com> wrote in message
news:82943115-AD90-49BF-93BC- BAFD7EF40B40@microso
ft.com...
> Hi all
>
> I need a bit of advice - I've created a FE using ADP the BE is on SQL
Express.
>
> Connecting to the BE on the same computer is fine, but i now need to
connect
> to the BE via a LAN.
>
> I can't seem to find a simple guide on how to do this. any pointers would
be
> welcome.
>
> Thanks

James Page

2006-03-06, 7:30 pm

Hi Alex

Tried that but access won't connect. Using the following:

server name = h1\sqlexpress (the instance name on the server machine)
windows integrated security = on

Access comes back and says:

"Test connection failed because of an error in initializing provider.
[DBNETLIB][ConnectionOpen (conect()).]SQL Server dows not exist or access
denied."

Am I missing something fundamental here??

James Page

2006-03-06, 7:30 pm

I've found the answer at this location:

http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx

If there is another way please let me know

Thanks

Alex Dybenko

2006-03-06, 7:30 pm

Hi James,
you also have to make sure that TCP/IP enabled on SQL Server. I think lesson
you found will guide you through whole process

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"James Page" < JamesPage@discussion
s.microsoft.com> wrote in message
news:E9ABE179-ECF7-470D-A33A- FC50BF1E3A86@microso
ft.com...
> Hi Alex
>
> Tried that but access won't connect. Using the following:
>
> server name = h1\sqlexpress (the instance name on the server machine)
> windows integrated security = on
>
> Access comes back and says:
>
> "Test connection failed because of an error in initializing provider.
> [DBNETLIB][ConnectionOpen (conect()).]SQL Server dows not exist or access
> denied."
>
> Am I missing something fundamental here??
>
>

Sponsored Links