Data view to oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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