Oracle connection LIVECODE comercial License

[jdarknet]

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

[D4vidrim]

same problem here.

It doesn't work on LC6.7 and 7.0

[D4vidrim]

Does anyone have any advice to solve the problem?

Thanks!

[sai]

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

[sai]

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

[Klaus]

Hi sai,

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

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

Best

Klaus

[sai]

Thanks K....

[Klaus]

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

[sai]

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

[Klaus]

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

[sai]

Hie Klaus,

Ya iam Connecting now through ODBC.

Thank You.