RE: Using Oracle Rdb driver from System.Data.Odbc

#1

Try to simplify the DATAGBASE option, for example, DATABASE= 'filename'

Does the same problem occur?

If the same problem occurs, try to apply the MDAC 2.8 from
http:\\www.microsoft.com\data

Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

--------------------

Quote:

Content-Class: urn:content-classes:message
From: "Darin Peshev" <dpeshev (AT) axarosenberg (DOT) com
Sender: "Darin Peshev" <dpeshev (AT) axarosenberg (DOT) com
Subject: Using Oracle Rdb driver from System.Data.Odbc
Date: Wed, 24 Sep 2003 17:53:55 -0700
Lines: 22
Message-ID: <128601c382ff$7ebf3f40$a301280a (AT) phx (DOT) gbl
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcOC/36/WSrgRNG1RCKVnF2CNnR9ng==
Newsgroups: microsoft.public.dotnet.framework.odbcnet
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:3022
NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet

Hi,
I can't use Oracle Rdb Driver from System.Data.Odbc. My
connect string looks like this:

DRIVER=Oracle Rdb Driver;UID=myname;PWD=mypass;
DATABASE=attach 'filename recon_turtle:events';SVR=pinegv

This works fine with Microsoft.Data.Odbc. With 1.1 when I
use the OdbcConnection in System.Data.Odbc namespace I get
exception that indicates malformed connection string. This
is because of the aposthrophes in the DATABASE value. I
tried using {} brackets around its value and then I don't
have this exception but these get passed to the ODBC
driver and the ODBC driver generates errors in the ODBC
trace log. I tried also using " instead of ' but then I
get the same exception. This is strange because .NET
Framework help states that the unacceptable characters are
[]{}(),;?*=!@ and ' and " are not in the list. How can I
do this? Using DSN is not an option in my case.
Thanks,
Darin

#2

Hi Kevin,
When I try using DATABASE='filename' I don't get the
message that my connect string is malformed but the driver
generates DIAG [HY000] [Oracle][ODBC][Rdb]%SQL-F-
SYNTAX_ERR, Syntax error (-1) indicating that this is not
a valid connect string. This is not a new issue - you can
search in google for "rdb system.data.odbc" and you will
find few posts with people having the same problem. I want
to know what is the solution. I already have 2.8 because
I'm developing on Windows 2003 Server and it comes with
Data Access Components 2.8. Also this problem doesn't
exist when using Microsoft.Data.Odbc because old assembly
doesn't check (and generate exceptions) when ' is part of
the database specification.
Thanks,
Darin

Quote:

-----Original Message-----
Try to simplify the DATAGBASE option, for example,
DATABASE= 'filename'

Does the same problem occur?

If the same problem occurs, try to apply the MDAC 2.8
from
http:\\www.microsoft.com\data

Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and
confers no rights.
Get Secure! - www.microsoft.com/security

--------------------
| Content-Class: urn:content-classes:message
| From: "Darin Peshev" <dpeshev (AT) axarosenberg (DOT) com
| Sender: "Darin Peshev" <dpeshev (AT) axarosenberg (DOT) com
| Subject: Using Oracle Rdb driver from System.Data.Odbc
| Date: Wed, 24 Sep 2003 17:53:55 -0700
| Lines: 22
| Message-ID: <128601c382ff$7ebf3f40$a301280a (AT) phx (DOT) gbl
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOC/36/WSrgRNG1RCKVnF2CNnR9ng==
| Newsgroups: microsoft.public.dotnet.framework.odbcnet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.odbcnet:3022
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet
|
| Hi,
| I can't use Oracle Rdb Driver from System.Data.Odbc. My
| connect string looks like this:
|
| DRIVER=Oracle Rdb Driver;UID=myname;PWD=mypass;
| DATABASE=attach 'filename
recon_turtle:events';SVR=pinegv
|
| This works fine with Microsoft.Data.Odbc. With 1.1 when
I
| use the OdbcConnection in System.Data.Odbc namespace I
get
| exception that indicates malformed connection string.
This
| is because of the aposthrophes in the DATABASE value. I
| tried using {} brackets around its value and then I
don't
| have this exception but these get passed to the ODBC
| driver and the ODBC driver generates errors in the ODBC
| trace log. I tried also using " instead of ' but then I
| get the same exception. This is strange because .NET
| Framework help states that the unacceptable characters
are
| []{}(),;?*=!@ and ' and " are not in the list. How can
I
| do this? Using DSN is not an option in my case.
| Thanks,
| Darin
|
|

.

#3

Hi Darin,

I have found some similar issues that are resolved by using the latest
Oracle driver from Oracle. Therefore, I suggest you to contact Oracle to
get the patch at first.

If you stil have this problem, please do not hesitate to let me know.

Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

--------------------

Quote:

Content-Class: urn:content-classes:message
From: "Darin Peshev" <dvdv (AT) axarosenberg (DOT) com
Sender: "Darin Peshev" <dvdv (AT) axarosenberg (DOT) com
References: <128601c382ff$7ebf3f40$a301280a (AT) phx (DOT) gbl
jWOB#e0gDHA.1548 (AT) cpmsftngxa06 (DOT) phx.gbl
Subject: RE: Using Oracle Rdb driver from System.Data.Odbc
Date: Thu, 25 Sep 2003 09:02:05 -0700
Lines: 91
Message-ID: <01eb01c3837e$5daf8dd0$a301280a (AT) phx (DOT) gbl
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcODfl2vxhRfXwzPSBK8uZC5cMpM/Q==
Newsgroups: microsoft.public.dotnet.framework.odbcnet
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:3032
NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet

Hi Kevin,
When I try using DATABASE='filename' I don't get the
message that my connect string is malformed but the driver
generates DIAG [HY000] [Oracle][ODBC][Rdb]%SQL-F-
SYNTAX_ERR, Syntax error (-1) indicating that this is not
a valid connect string. This is not a new issue - you can
search in google for "rdb system.data.odbc" and you will
find few posts with people having the same problem. I want
to know what is the solution. I already have 2.8 because
I'm developing on Windows 2003 Server and it comes with
Data Access Components 2.8. Also this problem doesn't
exist when using Microsoft.Data.Odbc because old assembly
doesn't check (and generate exceptions) when ' is part of
the database specification.
Thanks,
Darin

-----Original Message-----
Try to simplify the DATAGBASE option, for example,
DATABASE= 'filename'

Does the same problem occur?

If the same problem occurs, try to apply the MDAC 2.8
from
http:\\www.microsoft.com\data

Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and
confers no rights.
Get Secure! - www.microsoft.com/security

--------------------
| Content-Class: urn:content-classes:message
| From: "Darin Peshev" <dpeshev (AT) axarosenberg (DOT) com
| Sender: "Darin Peshev" <dpeshev (AT) axarosenberg (DOT) com
| Subject: Using Oracle Rdb driver from System.Data.Odbc
| Date: Wed, 24 Sep 2003 17:53:55 -0700
| Lines: 22
| Message-ID: <128601c382ff$7ebf3f40$a301280a (AT) phx (DOT) gbl
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOC/36/WSrgRNG1RCKVnF2CNnR9ng==
| Newsgroups: microsoft.public.dotnet.framework.odbcnet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.odbcnet:3022
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet
|
| Hi,
| I can't use Oracle Rdb Driver from System.Data.Odbc. My
| connect string looks like this:
|
| DRIVER=Oracle Rdb Driver;UID=myname;PWD=mypass;
| DATABASE=attach 'filename
recon_turtle:events';SVR=pinegv
|
| This works fine with Microsoft.Data.Odbc. With 1.1 when
I
| use the OdbcConnection in System.Data.Odbc namespace I
get
| exception that indicates malformed connection string.
This
| is because of the aposthrophes in the DATABASE value. I
| tried using {} brackets around its value and then I
don't
| have this exception but these get passed to the ODBC
| driver and the ODBC driver generates errors in the ODBC
| trace log. I tried also using " instead of ' but then I
| get the same exception. This is strange because .NET
| Framework help states that the unacceptable characters
are
| []{}(),;?*=!@ and ' and " are not in the list. How can
I
| do this? Using DSN is not an option in my case.
| Thanks,
| Darin
|
|

.

#4

Hi Kevin,
Is there any progress with this? Is this newsgroup the
only way to get support from Microsoft?
Thanks,
Darin

#5

The particular incident that Kevin was referring to had to do with Decimal values and by elimination indicates that the Connection was not the problem in your case. With something
like this it would be best to call in and use one of your MSDN Support incidents since tracing this would probably require ODBC Trace logs be looked over and possible
escalation internally if it is in fact a bug in the product. . See below.

http://support.microsoft.com/default...s;prodoffer11a

If it turns out that it IS a microsoft bug, then your will not be decremented your incident or charged for the call, However if it is a coding issue or 3rd party product bug you may be.

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : scotr (AT) online (DOT) microsoft.com <Remove word online. from address>

This posting is provided “AS IS”, with no warranties, and confers no rights.

Get Secure!
http://www.microsoft.com/security
http://www.microsoft.com/protect

--------------------

Quote:

Content-Class: urn:content-classes:message
From: "Darin Peshev" <dvdv (AT) microsoft (DOT) com
Sender: "Darin Peshev" <dvdv (AT) microsoft (DOT) com
References: <128601c382ff$7ebf3f40$a301280a (AT) phx (DOT) gbl> <jWOB#e0gDHA.1548 (AT) cpmsftngxa06 (DOT) phx.gbl> <01eb01c3837e$5daf8dd0$a301280a (AT) phx (DOT) gbl> <BhiZOo
$gDHA.1548 (AT) cpmsftngxa06 (DOT) phx.gbl
Subject: RE: Using Oracle Rdb driver from System.Data.Odbc
Date: Tue, 30 Sep 2003 14:21:37 -0700
Lines: 5
Message-ID: <14e701c38798$d4df5250$a001280a (AT) phx (DOT) gbl
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcOHmNTfFo8gvPdGSHCHgXyk78NnrA==
Newsgroups: microsoft.public.dotnet.framework.odbcnet
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:3071
NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet

Hi Kevin,
Is there any progress with this? Is this newsgroup the
only way to get support from Microsoft?
Thanks,
Darin

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: Using Oracle Rdb driver from System.Data.Odbc

Dotnet Framework (ODBC.net) microsoft.public.dotnet.framework.odbcnet

RE: Using Oracle Rdb driver from System.Data.Odbc - 09-25-2003 , 05:30 AM

RE: Using Oracle Rdb driver from System.Data.Odbc - 09-25-2003 , 12:02 PM

RE: Using Oracle Rdb driver from System.Data.Odbc - 09-26-2003 , 02:47 AM

RE: Using Oracle Rdb driver from System.Data.Odbc - 09-30-2003 , 05:21 PM

RE: Using Oracle Rdb driver from System.Data.Odbc - 10-01-2003 , 06:31 PM