topic Direct Connects to 9.3 in Data Management Questions

Direct Connect DLLs

TedCronin — Thu, 22 Oct 2009 22:27:57 GMT

Original Post Date: Oct 22, 2009 4:27 PM PDT

On the old install for Desktop these were a part of the install, but then I heard they were on the same "disk" for SDE, is that the case, or are they just incuded as part of the install for desktop. Trying to connect from 94 to 931.

I get trying to connect to an older ...

TedCronin — Fri, 23 Oct 2009 14:55:04 GMT

This is without the installs, thinking they are automatically installed, I get the normal error that I cannot connect to an older SDE GDB.

Direct Connect Installs

TedCronin — Fri, 23 Oct 2009 16:26:45 GMT

:(I posted to Server, and haven't recieved any info, so I am putting it here as well , since this is the install it was apart of originally. Is this still a needed install for direct connect to previous databases? Will it be a separate download?

Need DC software for ARCSDE 9.3.1

VolkerMell — Fri, 23 Oct 2009 17:51:32 GMT

Same here!
I was going to test 9.4 desktop first and then later put the Server stuff on a virtual machine.
So far no connection to SQLServer based _ArcSde DBs, sniff.

Direct Connect DLLs

RobertWest — Mon, 26 Oct 2009 17:48:14 GMT

The libraries needed to direct connect to older geodatabases are automatically included in the desktop install. Can you report this as a bug, please, so we can try to figure out what's going on?

thanks,
Robert

Ok, good to know and Fantastic

TedCronin — Mon, 26 Oct 2009 18:11:02 GMT

I will and have, I just need to follow up with Support. Yeahhh, someone got back to me. I tried sde94:sqlserver:Servername, which triggered the backward support error, so let me get with support so we can move forward and actually start doing some real testing.

Attached is the Issue

TedCronin — Tue, 27 Oct 2009 18:32:34 GMT

Attached is the Issue, I have also sent this off to support. I have tried sde:, and sde94: in the dc service box. Is there something MS related I need to update??

Direct Connect DLLs

ShannonShields — Tue, 27 Oct 2009 19:19:58 GMT

Ted,

this message means that your SQL Server Native Client is not up to date. At 9.4, when connecting to SQL Server, you must have the SQL Server Native Client installed locally that matches, or is newer, than the SQL Server instance you are trying to connect to. If you are connecting to SQL Server 2008 you need to have the 2008 Native Client. It is downloadable from here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

-Shannon

Yeahhh

TedCronin — Tue, 27 Oct 2009 19:27:52 GMT

Shannon to the rescue. Thank you Shannon:p.

Everything worked.

TedCronin — Tue, 27 Oct 2009 20:11:33 GMT

Good to go, now we can really test.

Cannot create a new connection to an existing enterprise ArcSDE 9.2 database

MichaelOlkin — Tue, 27 Oct 2009 20:33:13 GMT

I just installed ArcGIS Desktop 9.4 beta & the first issue that I've found is that I'm unable to create a new connection from ArcCatalog 9.4 to our existing 9.2 ArcSDE Enterprise Geodatabase. I've tested out a couple *.sde connection files to that same database that we have on our network & these work on 9.4, but I just can't seem to create a new connection in 9.4. I've tested a couple different logins & I've verified that I have all of the parameters & credentials correct.

-Mike O

See this thread

TedCronin — Tue, 27 Oct 2009 20:39:25 GMT

http://forumsbeta.esri.com/showthread.php?t=91

This should help.

Direct Connect DLLs

RobertWest — Tue, 27 Oct 2009 23:11:02 GMT

Did you see the answers posted in the ArcGIS Server Installation/Config forum?

Robert

Yep

TedCronin — Tue, 27 Oct 2009 23:17:41 GMT

Yep, it was me who posted it there, originally. Very helpful. Oops, your not referring to me, are you?

This should be helpful.

Ted,

this message means that your SQL Server Native Client is not up to date. At 9.4, when connecting to SQL Server, you must have the SQL Server Native Client installed locally that matches, or is newer, than the SQL Server instance you are trying to connect to. If you are connecting to SQL Server 2008 you need to have the 2008 Native Client. It is downloadable from here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

-Shannon

Direct Connects to 9.3

BuddyNagel — Wed, 28 Oct 2009 11:05:32 GMT

I get a error message when connecting to ArcSDE 9.2 SP5 or 9.3 SQL Server 2000. Failed to connect to database. Connection was attempted with an older version.........

Buddy

Issue resolved: don't use the instance name

MichaelOlkin — Wed, 28 Oct 2009 13:29:30 GMT

Thanks for the response on this. I actually wasn't using direct connect & it turns out that the issue was my own error. My existing 9.2 enterprise geodatabase is on a SQL Server 2000 named instance; I was using this convention: <server>\<instance> when attempting to connect, when all that I needed was just the server name.

All set now!

Direct Connect DLLs

RobertWest — Wed, 28 Oct 2009 14:18:07 GMT

Please check this thread

http://forumsbeta.esri.com/showthread.php?t=91

and see if Shannon's answer is what you need.

Robert

No need make separate install for direct connect drivers with 9.4

EugeneYang — Wed, 28 Oct 2009 17:37:13 GMT

Regarding the original question.

If you installed ArcGIS 9.4 beta, you don't need to install any direct connect drivers separately. All the necessary pieces to make backward direct connect to 9.3, 9.3.1, 9.2SP6 are already included.

Eugene

except the native client

TedCronin — Wed, 28 Oct 2009 21:32:04 GMT

except the native client, mentioned above.

GDB_Items

SteveAdams — Thu, 29 Oct 2009 17:52:28 GMT

I had the same problem so I installed the Microsoft SQL Server Native Client for sql server 2005. I can now do Test connection and it works, but when I click ok I get another error.
DBMS table not found[Microsoft SQL Native Client: invalid object name 'databasename.dbo.GDB_Items'.][databasename.dbo.gdb_Items]