Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Oracle & SQLS7 data type question!
Have anyone run into this? I have Oracle and sql server set up as linked servers (from SQLS), then I try select statement on some table, the result is weird: char and varchar columns are displayed properly but number (numeric) all are displayed as zeros (if i insert the number from SQL and then...- Marcha
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Error connecting to oracle
Possibly stupid question, but I'm desperate. I'm trying to link Oracle And SQLS7 the problem is I'm getting this error: Error Source: Microsoft OLE DB Provider for Oracle Error Description: An Oracle Error occured, but the message could not be determined. Context: Error initializing Provider...- Marcha
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Please help with linked servers?
I'm trying to link SQL server 7 and oracle with no success, all I get is that mistique error: 7399 'OLE DB Provider 'MSDAORA' Reported an error' without any explanations (when tried to query the linked server the error was a bit more specific: "OLE DB provider 'MSDAORA' reported an error...- Marcha
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
