Connection MSSQL with Oracle

Hai Pals:
I need a solution where I can access,Update values of MSSQL from Oracle and vice versa.
Could you provide a solution..
Take care
byeHello,

you can use ADBC to update datas from Oracle to MSSQL and vice versa.
Pls download http://www.alligatorsql.com/download/alligator.zip

If you need help, pls send an e-mail to m.peter@.alligatorsql.de

Best regards
Manfred Peter
Alligator Company Software GmbH
http://www.alligatorsql.com

Connection Breaks on StProc text UPDATE

Hi,
We have a simple stored procedure that has a text parameter, among others.
Inside the procedure the text parameter is assigned to a text column in a
simple SET clause of a simple UPDATE statement. We pass a 15 character
string as an argument for the parameter, and even though the string is
stored to the table, we get this error message (running in Query
Analyzer)...
*-*-*-*
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
*-*-*-*
Any of the following make the error message go away...
1) Pass NULL as the argument
2) Comment out the assignment in the SET clause
3) Change the parameter to varchar(8000)
Anyone have any ideas?
--
Thank you,
Daniel Jameson
Children's Oncology Group
http://www.childrensoncologygroup.orgCan you show the CREATE TABLE statement and the CREATE PROCEDURE code?
Also, tell us the result of SELECT @.@.VERSION
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"danjam" <djameson@.childrensoncologygroup.org> wrote in message
news:e6y2#eMxDHA.3416@.tk2msftngp13.phx.gbl...
> Hi,
> We have a simple stored procedure that has a text parameter, among others.
> Inside the procedure the text parameter is assigned to a text column in a
> simple SET clause of a simple UPDATE statement. We pass a 15 character
> string as an argument for the parameter, and even though the string is
> stored to the table, we get this error message (running in Query
> Analyzer)...
> *-*-*-*
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
> *-*-*-*
> Any of the following make the error message go away...
> 1) Pass NULL as the argument
> 2) Comment out the assignment in the SET clause
> 3) Change the parameter to varchar(8000)
> Anyone have any ideas?
> --
> Thank you,
> Daniel Jameson
> Children's Oncology Group
> http://www.childrensoncologygroup.org
>|||There are some known bugs that cause this or similar errors - it would
help to see your stored procedure. It could be an issue with UNION,
with an INSTEAD OF trigger, certain query structures, or an unknown
bug... It does sound like a bug, though.
SK
danjam wrote:
>Hi,
>We have a simple stored procedure that has a text parameter, among others.
>Inside the procedure the text parameter is assigned to a text column in a
>simple SET clause of a simple UPDATE statement. We pass a 15 character
>string as an argument for the parameter, and even though the string is
>stored to the table, we get this error message (running in Query
>Analyzer)...
>*-*-*-*
>[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
>(CheckforData()).
>Server: Msg 11, Level 16, State 1, Line 0
>General network error. Check your network documentation.
>Connection Broken
>*-*-*-*
>Any of the following make the error message go away...
> 1) Pass NULL as the argument
> 2) Comment out the assignment in the SET clause
> 3) Change the parameter to varchar(8000)
>Anyone have any ideas?
>
>|||Steve,
Thank you for responding. I have posted additional info under Aaron's post.
I do have an INSTEAD of trigger, but there are no UNION's involved.
--
Thank you,
Daniel Jameson
Children's Oncology Group
http://www.childrensoncologygroup.org
"Steve Kass" <skass@.drew.edu> wrote in message
news:uIFJ5pMxDHA.2556@.TK2MSFTNGP10.phx.gbl...
> There are some known bugs that cause this or similar errors - it would
> help to see your stored procedure. It could be an issue with UNION,
> with an INSTEAD OF trigger, certain query structures, or an unknown
> bug... It does sound like a bug, though.
> SK
> danjam wrote:
> >Hi,
> >
> >We have a simple stored procedure that has a text parameter, among
others.
> >Inside the procedure the text parameter is assigned to a text column in a
> >simple SET clause of a simple UPDATE statement. We pass a 15 character
> >string as an argument for the parameter, and even though the string is
> >stored to the table, we get this error message (running in Query
> >Analyzer)...
> >
> >*-*-*-*
> >[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
> >(CheckforData()).
> >Server: Msg 11, Level 16, State 1, Line 0
> >General network error. Check your network documentation.
> >
> >Connection Broken
> >*-*-*-*
> >
> >Any of the following make the error message go away...
> > 1) Pass NULL as the argument
> > 2) Comment out the assignment in the SET clause
> > 3) Change the parameter to varchar(8000)
> >
> >Anyone have any ideas?
> >
> >
> >
>

Connectio String .SDE Vs .DBO

Hi. i have a problem.

I want to Update a Database like this GISETS.SDE.CADENA, but it sais that it wants update this GISETS.DBO.CADENA (Database that doesn′t exist).

I use a connection string .sde but it gets a conflict because the reference is for a database .dbo. how can I fix it?

thanks for advance. Sorry for my english.

Fernando.

which version of sql server is this? IF its 2005 then Object is owned by Schema and if its 2000 then the objects are owned by User. So *SDE* here is either schema (2005) or its a User(2000). First check who is the owner of CADENA Table. if the owner is DBO change the FQN (Fully qualified name) GISETS.DBO.CADENA or change the owner ship to SDE schema/user

Madhu

|||

Good Morning Madhu (I′m from Spain).

I Use 2005, and the schema of CADENA table is SDE. In the propierties I can′t see who is the owner of the table, where i can see this? How can I change the FQN and where?

thanks in advance.

Fernando.

|||

In 2005, Schema is the object owner. where as in 2000 user is the object owner. So SDE is the owner of the table. You can't change FQN, what i said what when we refer object , refer it like Database.Schema.TableName. Before changing Schema of table CADENA to DBO , think twice. why because the object may be refered in many place with schema SDE.

To change CADENA table schema from SDE to DBO run following query

ALTER SCHEMA DBO TRANSFER SDE.CADENA

Madhu

Connectio String .SDE Vs .DBO

Hi. i have a problem.

I want to Update a Database like this GISETS.SDE.CADENA, but it sais that it wants update this GISETS.DBO.CADENA (Database that doesn′t exist).

I use a connection string .sde but it gets a conflict because the reference is for a database .dbo. how can I fix it?

thanks for advance. Sorry for my english.

Fernando.

which version of sql server is this? IF its 2005 then Object is owned by Schema and if its 2000 then the objects are owned by User. So *SDE* here is either schema (2005) or its a User(2000). First check who is the owner of CADENA Table. if the owner is DBO change the FQN (Fully qualified name) GISETS.DBO.CADENA or change the owner ship to SDE schema/user

Madhu

|||

Good Morning Madhu (I′m from Spain).

I Use 2005, and the schema of CADENA table is SDE. In the propierties I can′t see who is the owner of the table, where i can see this? How can I change the FQN and where?

thanks in advance.

Fernando.

|||

In 2005, Schema is the object owner. where as in 2000 user is the object owner. So SDE is the owner of the table. You can't change FQN, what i said what when we refer object , refer it like Database.Schema.TableName. Before changing Schema of table CADENA to DBO , think twice. why because the object may be refered in many place with schema SDE.

To change CADENA table schema from SDE to DBO run following query

ALTER SCHEMA DBO TRANSFER SDE.CADENA

Madhu