marrowyung
asked on
Oracle DSN and ODBC connection.
hi,
I am testing on Oracle to MariaDB convert tools and I need to setup DSN or ODBC connection, but other tools It only need Oracle sid/service name , username and password to convert.
so what is the format of DSN and ODBC string?
do I have to create one in Windows server?
I am testing on Oracle to MariaDB convert tools and I need to setup DSN or ODBC connection, but other tools It only need Oracle sid/service name , username and password to convert.
so what is the format of DSN and ODBC string?
do I have to create one in Windows server?
To create a DSN with the ODBC administrator tool.
On a 64Bit OS there are two. Mentioned above, you need the one for the application bit version not the OS bit version:
https://support.microsoft.com/en-us/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and-the-64-bit-user-d
On a 64Bit OS there are two. Mentioned above, you need the one for the application bit version not the OS bit version:
https://support.microsoft.com/en-us/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and-the-64-bit-user-d
ASKER
yeah!
any appropriate way to setup it up, never work this way before, any URL ?
any appropriate way to setup it up, never work this way before, any URL ?
The wizard is pretty straight forward.
Depending on the user rights you can set up a system DSN or User DSN. Select 'Add' and the Oracle client. The rest should be self explanatory.
Depending on the user rights you can set up a system DSN or User DSN. Select 'Add' and the Oracle client. The rest should be self explanatory.
ASKER
hi,
I am now following this: http://wiki.ispirer.com/sqlways/users-guide/setting-up-database-connection/dsn_file
to setup file DSN.
but once created one for oracle the file content is so simple:
is that mean I MUST install oracle specified ODBC driver to create the file DSN ?
this is my new data source page:
oracle 12 c seems do not have any ODBC driver, any idea ?
I am now following this: http://wiki.ispirer.com/sqlways/users-guide/setting-up-database-connection/dsn_file
to setup file DSN.
but once created one for oracle the file content is so simple:
[ODBC]
DRIVER=Oracle in OraDB12Home1is that mean I MUST install oracle specified ODBC driver to create the file DSN ?
this is my new data source page:
oracle 12 c seems do not have any ODBC driver, any idea ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"
Yes, with very few exceptions, to connect to an Oracle database, you need an Oracle Client.
"
I have already installed the oralce 12c client, I installed one more time and it shown repeated item.
finally found out that the service name need this : <server name>:<port number>/<service name>
this is what it wants !
I am done!
Yes, with very few exceptions, to connect to an Oracle database, you need an Oracle Client.
"
I have already installed the oralce 12c client, I installed one more time and it shown repeated item.
finally found out that the service name need this : <server name>:<port number>/<service name>
this is what it wants !
I am done!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you mean to accept your "tks all" comment as the solution?
The easiest thing is to set up the data source on the client machine. Just remember that you need to create a 32 or 64 bit DSN depending on whether the application on the client machine is a 32 or 64 bit application.
Kent