[mapguide-users] Connection Problem-ORACLE ODBC Driver(configure odbc connection)

[Rahul]

Thks Zac,

                I treid to connect Oracle Database 10.1.0 with Oracle Instant Client 10.2.0.2 and  oracle odbc driver-win32 10.2.0.3 . I successfully able to create and connect DSN using the Oracle Odbc driver but when i want to connect that DSN in the ADSK MapGuideStudio 2008,I unable to connect and it shows FDO Error-An Exception Occured in FDO component.RDBMS:No Current open Database .
Do i require to install Oracle Instant Client 10.2.0.3.

Regarding the King Oracle FDO Provider ,I  tried it already with Oracle Spatial Database but I haven't tried with tables without any GEOMETRY,I think i have to create FDO Class Table in order to read the Point Data stored as Lat,Lon,a,b,c,d --------- etc.

Zac Can you provide little bit more detail in this case?

Thks
Max


----- Original Message ----
From: Zac Spitzer <zac.spitzer at gmail.com>
To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
Sent: Sunday, March 2, 2008 12:31:52 AM
Subject: Re: [mapguide-users] Connection Problem-ORACLE ODBC Driver(configure odbc connection)

Try King Oracle which is a FDO provider for Oracle

http://www.sl-king.com/fdooracle/fdooracle.html

there is a new test version for Mapguide 2.0 here @ ftp://www.sl-king.com/simon

On Sun, Mar 2, 2008 at 3:21 AM, Rahul <unicorn_admirer at yahoo.com> wrote:
>
> Hi,
>
> Thks Dave,Yestersday i figured it out about Driver Name Change and i changed
> it to Oracle in instantclient10_2  in the connection string but without any
> success.
>
> I have around 30,000 Records in a Oracle table with Lat ,Lon and other
> pertinent readings in the table and the readings use to get updated every 2
> hours or upon some event fired.Can you tell me what will be the better idea
> keeping in mind performance to go with -
>
> 1. Create DSN using Oracle ODBC Driver
> 2. Try to connect using Oracle Microsoft Driver after installing Oracle
> Client on the Server.
>
> Or do u have any other suggestions or ideas !!
>
> Thks
> Max
>
>
>
> ----- Original Message ----
> From: Dave Wilson <dave.wilson at autodesk.com>
> To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
> Sent: Friday, February 29, 2008 9:19:10 AM
> Subject: RE: [mapguide-users] Connection Problem-ORACLE ODBC
> Driver(configure odbc connection)
>
>
>
>
> The connection string option does not work. A defect internal to Autodesk
> has already been logged regarding this. As well when using the instant
> client your Driver name must change to reflect the instant client you are
> using "Oracle in instantclient10_2" would be the correct name, however even
> with that change it still doesn't work. Resolution of the TNSNAMES is not
> likely the issue based on testing we have done.
>
>
>
> The only option that works is to create a DSN wherever your server is
> installed.
>
>
>
> Regards,
>
> Dave
>
>
>
>
>
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rahul
> Sent: Friday, February 29, 2008 4:14 AM
> To: MapGuide Users Mail List
> Subject: [mapguide-users] Connection Problem-ORACLE ODBC Driver(configure
> odbc connection)
>
>
>
>
>
> Hi All,
>
>
>              I am using MGOS 1.2 and Map Guide Studio2008, I am trying to
> connect to Oracle Database 10.1.0 and i installed Oracle instant
> client-10.2.0.2 on my machine i.e. MapGuide Server, I also succesully
> installed oracle odbc driver-win32 10.2.0.3 in order to configure ODBC
> connection using Oracle(Oracle Driver) in the MapGuide Studio.
>
>
>
>
>
> I also set the PATH variable to oracle instant client directory as well as
> also defined ORACLE_HOME and TNS_ADMIN as system variable.
>
>
>
>
>
> I tried the connection string in th studio as follows -
>
>
>
>
>
> Driver={Oracle ODBC Driver};Dbq=Database Name;Uid=xxx;Pwd=yyyy;
>
>
>
>
>
> I also tried to use the another connection setting if it unable to get the
> values from tnsnames.ora hence i tried
>
>
>
>
>
>
> Driver={Oracle ODBC Driver};Dbq=10.X.X.X:1521/abcd;Uid=xxx;Pwd=yyyy;
>
>
> but i unable to connect to oracle and getting the FDO Error-An Exception
> Occured in FDO component.RDBMS:No Current open Database but the same
> database i can connect using the Fdo2Fdo Tools,Any kind of help will be
> really helpfull for me.
>
>
>
>
>
> Thks
>
>
> Max !!
>
>
>
>
>
>
>
>
>  ________________________________
>
>
> Never miss a thing. Make Yahoo your homepage.
>
>
> -----Inline Attachment Follows-----
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
>
>  ________________________________
> Never miss a thing. Make Yahoo your homepage.
> _______________________________________________
>  mapguide-users mailing list
>  mapguide-users at lists.osgeo.org
>  http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>



-- 
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users


      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080302/f45d0159/attachment.html