Hey to the community!

I am running an internal server 2003 with its primary MS SQL database which all works perfectly with my newly bought Indoo G. module. However I also have an old Oracle 8g DB on the same network which I need to access. I have tried the ODBC connection, with following connection string:

My details: (masked as x,y,z)
Driver Name: "X"
Server: "Y"
Uid: "Z"
TNS Service name: "Q"

The standard connection string: Driver={X};;Server=Y;Uid=Z;Pwd=password;QTO=F;DBQ=Q

IndooGrid only accepts the connection string when I added the TNS Service name "DBQ=[TNS Service Name]". By providing the connction string above, indoo wizard doesnt show any errors, but I cant see the different tables when I try to select a table in the table wizard. Anbody know this issue and could help me out?

I have tried to use the built in datasource thingie in Excel where I can connect to the Oracle Database without any issues and by using the same info above. Here a query pops up and I can select the tables etc. After I connected, I looked in the connection properties and saw the following string:

DRIVER={X};;SERVER=Y;UID=Z;Pwd=password;DBQ=Q;DBA=W;APA=T;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;FRL=F;MTS=F;CSR=F;PFC=10;TLO=O;

As you can see, excel adds some other configuration parameters too and when I put this string into indoogrid, same thing happens: It connects (or doesnt give any connection errors) but no tables can be seen in the table wizard :-(

Hope some of you guys have a solution out there, I really dont want to manually refresh the details through an Excel sheet - nor do I want to invest 4000$ for an MS SQL Standard edition with the Scheduled DTS ability ;-)

Thanks,
David

Hey Pril,

Sorry for the delay, I kinda didnt check the notify me option but thought I did so have not checked the post in ages...

Nope, have not resolved it in terms of IndooGrid. Instead, I use the data loader http://www.dbload.com/ which is scheduled to import/update the data I need from the Orcale DB into my MS SQL Express DB which is connected to the Indoo modules.

The price to pay, besides the 100$ for the software, is ofcourse that it is not "live" - it suits me fine at the moment but would be REALLY great if there was a solution.

The issue I describe is in terms of the native oracle data provider... If I use the string "Data Source=XXX;User Id=XXX;Password=XXX;Integrated Security=no;" as I described I get by but no tables in the tables list dropdown. If I do the same with the ODBC I also get by and am presented with a "Table/view name: ______ "- when I do, it says "cannot access table [tablename]". That kinda doesnt tell me if indoo has established connection at all or why it says that... so im still stuck...

oh yeah, I only got the Data Loader software to avoid paying the 6000$ for a MS SQL server standard edition that provides the data import scheduling ability that I needed for this ;-)

Hope somebody will come by with an answer at some point of time ;)

Dave