I cannot read from the file on a server.
Below is the error I am getting. When I create the grid on my own computer it works fine, as soon as I publish I am getting the error below. (see picture)
I have checked all of my settings and the ALpha 5 server version is running under my own credentials.
So I don't understand why the information does not get displayed like on my own machine. ANY help would really be appreciated.
Error running Grid:
Error opening Grid table/view: Database API specific error
Your database has returned the following error code and description to Alpha Five.
Consult your database documentation for further information.
-5036 - '[Microsoft][ODBC Excel Driver] Failure creating file.
SQL State is: HY000
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
SQL State is: IM006
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
SQL State is: IM006'
Below is the error I am getting. When I create the grid on my own computer it works fine, as soon as I publish I am getting the error below. (see picture)
I have checked all of my settings and the ALpha 5 server version is running under my own credentials.
So I don't understand why the information does not get displayed like on my own machine. ANY help would really be appreciated.
Error running Grid:
Error opening Grid table/view: Database API specific error
Your database has returned the following error code and description to Alpha Five.
Consult your database documentation for further information.
-5036 - '[Microsoft][ODBC Excel Driver] Failure creating file.
SQL State is: HY000
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
SQL State is: IM006
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Excel Driver]Invalid connection string attribute HDR
SQL State is: 01S00
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
SQL State is: IM006'