Hello

please can someone help?

I am trying to edit in frontpage2003 a sharepoints web site so that we can
link to an oracle 8 database. When I try and add the dataview using a
connection string (Provider=OraOLEDB.Oracle.1;Data Source=<server name>;User
Id=<user name>;Password=<password> I get the following message; Server
Error: An error occured while retrieving the list of databases from <server
name>: The server for the data source returned a non-specific error when
trying to execute your query. Check the format and content of your query and
try again. If the problem persists, contact the server administrator. I have
tried an oledb connection using vb.net from the same machine to the same
server and this works fine????

can anyone offer any solution?

thanks

It should look like this:
"Provider=OraOLEDB.Oracle;Your_Oracle_Database;User
Id=Your_Username;Password=Your_Password;"

You can also try this:
"Provider=MSDAORA;Data Source=Your_Oracle_Database;User
Id=Your_Username;Password=Your_Password;"

Or an ODBC connection:
"Driver={Microsoft ODBC for
Oracle};Server=Your_Oracle_Server.world;Uid=Your_Username;Pwd=Your_Password;"


Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

Neal wrote:
> Hello
>
> please can someone help?
>
> I am trying to edit in frontpage2003 a sharepoints web site so that we can
> link to an oracle 8 database. When I try and add the dataview using a
> connection string (Provider=OraOLEDB.Oracle.1;Data Source=<server name>;User
> Id=<user name>;Password=<password> I get the following message; Server
> Error: An error occured while retrieving the list of databases from <server
> name>: The server for the data source returned a non-specific error when
> trying to execute your query. Check the format and content of your query and
> try again. If the problem persists, contact the server administrator. I have
> tried an oledb connection using vb.net from the same machine to the same
> server and this works fine????
>
> can anyone offer any solution?
>
> thanks
>

Sorry tried all those - still gives the same error message


"Jens Peter Karlsen [FP MVP]" wrote:

> It should look like this:
> "Provider=OraOLEDB.Oracle;Your_Oracle_Database;User
> Id=Your_Username;Password=Your_Password;"
>
> You can also try this:
> "Provider=MSDAORA;Data Source=Your_Oracle_Database;User
> Id=Your_Username;Password=Your_Password;"
>
> Or an ODBC connection:
> "Driver={Microsoft ODBC for
> Oracle};Server=Your_Oracle_Server.world;Uid=Your_Username;Pwd=Your_Password;"
>
>
> Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
>
> Neal wrote:
> > Hello
> >
> > please can someone help?
> >
> > I am trying to edit in frontpage2003 a sharepoints web site so that we can
> > link to an oracle 8 database. When I try and add the dataview using a
> > connection string (Provider=OraOLEDB.Oracle.1;Data Source=<server name>;User
> > Id=<user name>;Password=<password> I get the following message; Server
> > Error: An error occured while retrieving the list of databases from <server
> > name>: The server for the data source returned a non-specific error when
> > trying to execute your query. Check the format and content of your query and
> > try again. If the problem persists, contact the server administrator. I have
> > tried an oledb connection using vb.net from the same machine to the same
> > server and this works fine????
> >
> > can anyone offer any solution?
> >
> > thanks
> >
>