Has anyone seen the BODI-1111341 error? I’m trying to create a datastore using DS 3.2.1.3 and SQL Server 2008. When I try to apply my Datastore specifications I get the message ‘Warning: Cannot establish database connection’. This is followed by the message ‘ODBC call for data source <>failed:<[Microsoft][ODBC SQL Server Driver][DNETLIB]Invalid connection.>.Notify Customer Support.’ (BODI-1111341)’.
Anyone got any ideas?
As always, thanks in advance.
Nemesis 
(BOB member since 2004-06-09)
have you installed SQL Server 2008 native client on the machine where DS Designer/Job Server is running ?
for SQL Server 2008 you will have to install SQL Server 2008 Native Client
manoj_d (BOB member since 2009-01-02)
No, we have SQL Server 2005 Native Client on the job server. I’ll forward your information onto the admin guys.
Thanks for the information.
We are accessing Designer via Citrix. Do you know if that makes any difference?
Nemesis (BOB member since 2004-06-09)
The admins installed SQL Server 2008 client, but this made no difference. Interestingly, I got a DBA to do a trace on the database server and found that the error message was caused by the ‘named pipes’ protocol being disabled. Once the protocol was enabled, I could create the datastore successfully.
However when I try to import table metadata I get a new error:-
‘Error: Cannot load metadata table <name=all>.’
'ODBC call for data source <> failed:<[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified>.Notify Customer Support. (BODI-1112346)
Nemesis (BOB member since 2004-06-09)
what is your Datastore Database type ? ODBC or SQL Server 2008 ?
manoj_d (BOB member since 2009-01-02)
It’s SQL Server 2008.
Nemesis (BOB member since 2004-06-09)
try testing the connection for the Database from System DSN by creating a DSN using SQL Server Native client (version 10.0)
also, set the order of TCP/IP protocol as 1
manoj_d (BOB member since 2009-01-02)