Groups | Blog | Home
all groups > sql server msde > april 2005 >

sql server msde : complete newbie - error when connecting from new .adp



Jesper Fjølner
4/20/2005 10:46:40 PM
I've installed the MSDE and my taskbar icon says it's running.
I'm then trying to create an Access project (.adp) and and I'm faced with
the connection screen.
I type "local" as the SQL server name and check "trusted connection".
I then get an error saying:

Connection failed:
SQLstate: '01000'
SQL server error 53
[Micrsoft][ODBC SQL server driver][DBNETLIB]connectionOpen(Connect()).
Connection failed:
SQLState '08001'
SQL Server error: 17
[Micrsoft][ODBC SQL server driver][DBNETLIB]connectionOpen(Connect()).

Do I need to "create" as database with the MSDE or dos-prompt first?
Is is just the engine that's runing but I don't in fact have a database yet?
I'm experienced with JET but have never used MSDE.
Thanks for any help.

--
Jesper Fjølner
Denmark

Jesper Fjølner
4/20/2005 10:50:22 PM
Back again. Just got it working. Dump typo on my part.
Hopefully I can come back for assistance with an actual problem.
Sorry for the inconvenience. .

--
Jesper Fjølner

AddThis Social Bookmark Button