LiveCode Forums.

Hi,

Has anyone been able to connect oracle from OS X?, I have LC commercially licensed, the message error is " revdberr, invalida database type"

Regards,


Julián

same problem here.

It doesn't work on LC6.7 and 7.0

Does anyone have any advice to solve the problem?

Thanks!

Please Answer for this Question..Oracle not responding while connecting this is my Code
on mouseUp
global gConnectionID
put "ORCL" in the dbType
put "localhost:1521" in the dbHost
put "DB_EXTRACT" in the dbName
put "DB_EXTRACT" in the dbUsername
put "DB_EXTRACT" in the dbPassword
put revOpenDatabase(dbType, dbHost,dbName, dbUsername,dbPassword) into tResult
if tResult is a number then
put tResult into gConnectionID
answer info "Connected to the database." & cr & "Connection ID = " & gConnectionID
else
put empty into gConnectionID
answer error "Unable to connect to the database :" & cr & tResult
end if

end mouseUp


ERROR THAT IAM GETTING:button "DbConnect": (Expression: bad factor), char 32 in livecode

Finally Got Solved i used "in the" in code changed "into"
It's Working Now Getting a New error

ERROR:Unable to connect the database:revdberr,invalid database type.

This is my code after chaging

on mouseUp
global gConnectionID
put "ORCL" into dbType
put "localhost:1521" into dbHost
put "XXXXX" into dbName
put "XXXXX" into dbUsername
put "XXXXX" into dbPassword

put revOpenDatabase(dbType, dbHost,dbName, dbUsername,dbPassword) into tResult
if tResult is a number then
put tResult into gConnectionID
answer info "Connected to the database." & cr & "Connection ID = " & gConnectionID
else
put empty into gConnectionID
answer error "Unable to connect to the database :" & cr & tResult
end if

end mouseUp

Hi sai,

a quick look into the dictionary brings enlightment!
...
## BAD:
## put "ORCL" into dbType

## Good:
put "oracle" into dbType
...

Best

Klaus

Thanks K....

My name is Klaus, I think you should take that much time!

Sorry Klaus...

Iam Trying to Connect SQL Express 2012 Database with LC...Want to Extract the data

put revOpenDatabase("SQL", "DSN",, "testuser", "password") into tResult

Iam Getting Following Error

ERROR : : The Specified DSN contains an architecture mismatch between the Driver and Application

How to Rectify It

Hi sai,

come on, why do you not take a look into the dictionary -> "revOpenDatabase", to see what types of databases are supported?
Whatever a "SQL Express 2012 Database" is, it is not directly supported by LC, see dictionary!

Maybe you can connect via ODBC, but I have no idea.


Best

Klaus

Hie Klaus,

Ya iam Connecting now through ODBC.

Thank You.