ODBC Connection String changes after close

[aaronmbrown]

I am connecting Power Pivot to a Pervasive database using a connection string that tests ok and a valid query. The connection works just fine until I save and close Excel. When I re-open and try to refresh the data I receive an error that the connection cannot be made. I check the connection string and it has changed from what I entered. I can re-enter the correct string and the connection test comes back ok. The data still will not refresh using the refresh button on the ribbon. I have to open the table properties and wait for the screen to enter edit mode. Then I can click save and the table will update. I am hoping someone can tell me why the connection string changes when I close Excel.

 

[aaronmbrown]

I am connecting Power Pivot to a Pervasive database using a connection string that tests ok and a valid query. The connection works just fine until I save and close Excel. When I re-open and try to refresh the data I receive an error that the connection cannot be made. I check the connection string and it has changed from what I entered. I can re-enter the correct string and the connection test comes back ok. The data still will not refresh using the refresh button on the ribbon. I have to open the table properties and wait for the screen to enter edit mode. Then I can click save and the table will update. I am hoping someone can tell me why the connection string changes when I close Excel.

I was able to find a work around that seems to work.

 

[contactdoug]

I have an issue trying to connect powerpivot to a pervasive db using odbc...No LUCK. What does your connection string look like? The error message I receive states that I'm missing a '='.
Thanks
Doug

 

[aaronmbrown]

I have an issue trying to connect powerpivot to a pervasive db using odbc...No LUCK. What does your connection string look like? The error message I receive states that I'm missing a '='.
Thanks
Doug

DSN=AssignedDSNName;CODEPAGE=1252;DATABASETYPE=1;DBQ=\\database location\;DICTIONARYMODE=0;MAXCOLSUPPORT=255;PWD=Mil45P221;SHORTENNAMES=0;STANDARDMODE=0;UID=myuserID;

Hope that helps

 

[contactdoug]

DSN=AssignedDSNName;CODEPAGE=1252;DATABASETYPE=1;DBQ=\\database location\;DICTIONARYMODE=0;MAXCOLSUPPORT=255;PWD=Mil45P221;SHORTENNAMES=0;STANDARDMODE=0;UID=myuserID;

Hope that helps

Thanks for your response but I still get the same error. This is what my connection string looks like...I know...It's a mess but I can't find anything else to put into it or what to modify. It still responds with the missing '='

Provider=MSDASQL.1;
Persist Security Info=True;
Driver={Pervasive ODBC Client Interface};
DSN=Prodro;
ServerName=192.168.1.3.1583;
ArrayFetchOn=1;
ArrayBufferSize=8;
TransportHint=TCP:SPX;
DBQ=TEMPDB;
ClientVersion=11.30.051.000;
CodePageConvert=1252;
PvClientEncoding=CP1252;
PvServerEncoding=CP1252;
Initial Catalog=TEMPDB;
CODEPAGE=1252;
DATABASETYPE=1;
DICTIONARYMODE=0;
MAXCOLSUPPORT=255;
DSN=TEMPDB;
ArrayFetchOn=1;
ArrayBufferSize=8;
TransportHint=TCP:SPX;
DBQ=TEMPDB;
ClientVersion=11.30.051.000;
CodePageConvert=1252;
PvClientEncoding=CP1252;
PvServerEncoding=CP1252;
SHORTENNAMES=0;
STANDARDMODE=0;
Trusted_Connection=yes;