Page 2 of 2
Error using DSN with PrimalSQL 2011
Posted: Wed Aug 10, 2011 5:01 am
by davidc
Alter the ODBC connection string in 2011 to this: Driver={Microsoft ODBC for Oracle};Dsn=AR System ODBC Data Source;User ID=<user id>;Password=<password>Also keep the DSN in both System and User just in case. David
Error using DSN with PrimalSQL 2011
Posted: Wed Aug 10, 2011 6:06 am
by myitguy
Sorry to keep providing short answers.
That did not work either. Is there some debug logging that can be enabled, possibly?
Error using DSN with PrimalSQL 2011
Posted: Thu Aug 11, 2011 4:16 am
by davidc
Unfortunately
these errors originate in the providers, which I don't have access to. I will
have to do some more research and try to recreate the problem on our end. Right
now I can only recommend using the Oracle Connection.Just to test,
can you modify the connection string once again? Before when testing a DSN to a
SQL Database the following change helped:Dsn=AR
System ODBC Data Source;uid=<user id>;pwd=<password> David
Error using DSN with PrimalSQL 2011
Posted: Thu Aug 11, 2011 6:19 am
by myitguy
That allowed me to connect. Is there a way to browse the table information as in 2009?
Thank you, again for all your assistance.
Error using DSN with PrimalSQL 2011
Posted: Thu Aug 11, 2011 6:58 am
by davidc
Yes, the next service release will resolve the missing tables issue as well. David
Error using DSN with PrimalSQL 2011
Posted: Thu Aug 11, 2011 7:38 am
by myitguy
Excellent! Thank you again for all your help. Much appreciated.