rileybloke
New Member
- Joined
- Feb 7, 2013
- Messages
- 43
Hi, I am trying to connect to a Pervasive database using the Pervasive ODBC connection.
The ODBC connection works fine via the standard data query in Excel, I able to see the table of the database.
But when I build the ODBC string in powerpivot the ODBC connection dialog test is ok, but the powerpivot query shows the error...
Failed to connect to the server. Reason: ERROR [08004] [Pervasive][ODBC Client Interface]Missing '=' in connection string.
I have tried many variations of the string...
Provider=MSDASQL.1;Persist Security Info=False;DSN=CAPTUREIT
Provider=MSDASQL.1;DSN=CAPTUREIT
The DSN is CAPTUREIT, and I have found that if I remove the spaces in the field names from within the string then powerpivot accepts it, but then errors with no tables available in database.
I am surprised that standard data query in Excel works but PowerPivot does not like it.
Thanks in advance.
The ODBC connection works fine via the standard data query in Excel, I able to see the table of the database.
But when I build the ODBC string in powerpivot the ODBC connection dialog test is ok, but the powerpivot query shows the error...
Failed to connect to the server. Reason: ERROR [08004] [Pervasive][ODBC Client Interface]Missing '=' in connection string.
I have tried many variations of the string...
Provider=MSDASQL.1;Persist Security Info=False;DSN=CAPTUREIT
Provider=MSDASQL.1;DSN=CAPTUREIT
The DSN is CAPTUREIT, and I have found that if I remove the spaces in the field names from within the string then powerpivot accepts it, but then errors with no tables available in database.
I am surprised that standard data query in Excel works but PowerPivot does not like it.
Thanks in advance.