ADP and Sql Server 2005

  • Thread starter Thread starter Ed Warren
  • Start date Start date
E

Ed Warren

Is it possible to connect to SQL Server 2005 from an APD project. When I
pull down the connection menu, it only shows the SQL 2000 server and does
not show the SQL 2005 server. Am I missing something simple here?

Ed Warren
 
Enter manually the name of the server, followed by the name of the instance
if necessary. For example: (local)\SQL2005 .

The design tools won't work but the data will be OK.
 
Thanks a lot, that works. I had thought I had tried that but I must have
made some 'fat finger mistake' it works like a charm now.

Ed Warren
 
so it lets you connect; but it won't let you write sprocs and views?

i sure hope that's a line of crap

it should work; i mean-- it's the current version of access and the
current version of sql

i think that we should all write a petition to MS to get this working
by SQL 2005 sp1
 
i mean.. this from the company that made access 2000 and sql 2000
incompatable.

idiots run the access dept at ms from what i see

shit; i went to some access users group meeting the other day and some
access pm couldn't write SQL to save his life.. lol

time to grow up, kids
 
i mean.. he was like

Select 'Aaron' From Employees
UNION
Select Firstname From Employees

i mean.. anyone else see the problem with that??
 
Back
Top