Hi All,
I'm trying to connect to SQL Server 2005 64 bit.
Using existing 4.2 DataDirect drivers.
I fail connecting to it (posting from home, so exact error will be posted later).
I was told that 64 bit SQL Server doesn't support ODBC all together .
Does anyone have any info or experiance working with this 64bit version of SQL server 2005?
I was trying to install the latest version of DataDirect from Eservices but the tar file doesn't seem to open successfully (failing on the wizard's jar file)
Thanks in advance for your time...
SQL Server 2005 64bit ODBC Connection
Moderators: chulett, rschirm, roy
SQL Server 2005 64bit ODBC Connection
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Thanks for the replies
Static ports you say
I hope the DBA will know what that means
Will update on how it goes
(entering hollydays here so might take 2 weeks to confirm )
Static ports you say
I hope the DBA will know what that means
Will update on how it goes
(entering hollydays here so might take 2 weeks to confirm )
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
The sql server browser service is new with 2005 and it is the default configuration for sql server. I could not get the default configuration to work with the odbc driver. That is, I could not use a named instance and connect to the sql browser service to retrieve the port of the running instance. We had to avoid the browser service and directly connect to the running instance by forcing the port number in both the odbc DSN and the sql server instance.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I can sense a DataStage (ODBC stage) enhancement request coming on. Who'd like to be first? There's a forum here for exactly that - all posts are forwarded to IBM, and we can guarantee that they are looked at there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.