Recent content by Marcha

well the one is the manager process (the console you use to modify, update etc your server), the other is the server itself. Have fun! Marcha

A little addition to the Image question: You should read the SQL Books online, so far I'v found lot of useful info on using, storing etc... Have fun! Marcha

Well you could try to do it the same way as images are stored (binary/varbinary) however I'm not quite sure about how large files can be. Or store a referecnce to a file or archive (example user points to a file, use zip/whatever then write referecne into field). Hmm quite difficult question, I...

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...

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...

As I said I tried both (from the Enterprise Manager Console & Query Analizer) the problem seems to be the connection/configuration related (becouse when I tried inputing invalid data it also added the linked server and the error this time was the same, however the dummy linked server pointed to...

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...