Oracle connection LIVECODE comercial License
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Oracle connection LIVECODE comercial License
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
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
Re: Oracle connection LIVECODE comercial License
same problem here.
It doesn't work on LC6.7 and 7.0
It doesn't work on LC6.7 and 7.0
Re: Oracle connection LIVECODE comercial License
Does anyone have any advice to solve the problem?
Thanks!
Thanks!
Re: Oracle connection LIVECODE comercial License
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
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
Re: Oracle connection LIVECODE comercial License
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
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
Re: Oracle connection LIVECODE comercial License
Hi sai,
a quick look into the dictionary brings enlightment!
...
## BAD:
## put "ORCL" into dbType
## Good:
put "oracle" into dbType
...
Best
Klaus
a quick look into the dictionary brings enlightment!
...
## BAD:
## put "ORCL" into dbType
## Good:
put "oracle" into dbType
...
Best
Klaus
Re: Oracle connection LIVECODE comercial License
Thanks K....
Re: Oracle connection LIVECODE comercial License
My name is Klaus, I think you should take that much time!
Re: Oracle connection LIVECODE comercial License
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
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
Re: Oracle connection LIVECODE comercial License
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
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
Re: Oracle connection LIVECODE comercial License
Hie Klaus,
Ya iam Connecting now through ODBC.
Thank You.
Ya iam Connecting now through ODBC.
Thank You.