The service used in the demo was "Localhost". Make sure that you have the
provider for SQLServer 2008 installed, IIRC the provider for SQL Server
shipped with R2009 is not the one for the 2008 server.
--
Murph
www.map3d.wordpress.com
"dvmorris" wrote in message news:5970323@discussion.autodesk.com...
I am trying to connect to a local instance of SQL Server 2008, and I can't
seem to figure out what "service name" is actually referring to in the
connect dialog in Map3d 2009.
Is this the IP address? should i use "localhost"? Should I use the name of
the windows service (MSSQLSERVER)? There is no documentation that I can find
anywhere that says what this actually means, and I can't seem to find anyone
on the internet who has actually gotten this to work. I saw a video on
channel9.msdn.com where the Autodesk guy did it, but the screen was so
blurry I couldn't tell what he was typing in.
Also, does this allow me to use Windows Authentication to connect? Or do I
have to create a SQLServer user account? The documentation seems to be
specific to ORACLE, and generic for everything else. It's extremely
confusing, fyi for any Autodesk technical writers reading this. I'm not a
total idiot when it comes to connecting to databases etc... and I am
completely stuck.
Anyways, I'm desperate now, this thing is driving me crazy. Also, the bulk
copy command doesn't seem to work on sql server. I was able to connect to
the SQL Server instance by creating a system DSN and using the ODBC driver,
but it doesn't seem to recognize my geography data in my database. It only
recognizes a table where I have a field called latitude and one called
longitude.
Any help would be greatly appreciated. This is a Windows Server 2003 box
with SQL Server 2008, Visual Studio 2008, Autodesk Map 3d 2009 with sp1,
etc...