If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
The generic ODBC is indeed shown in the image.That's why I was asking for it.
Would be great when connecting with other databases by ODBC. So how to get it.
In my case I want to connect with MS-SQL express 2014.
I tried to do it with a script, but without succes. As well as an direct connectionstring as well as with DNS (odbc).
Strange thing is that when I put the same script in een php-editor (I use NuSphere PHP) then it works fine.
So it can be that SC blocks this because of commercial reasons. Because of the need to upgrade to a license with as well MySQL as MySQL.
Who can help with a script in SC for the connection?
hi guys, can anyone just give me a hint how it will work with ODBC? i have a server that have ODBC connection to external MSSQL server, works fine, and i have mysql server on this "physcial" server, will, if i build something on sc and put on this "physical" server will allow me to use this connection to connect to the remote MSSQL or i have to have the direct connection details in order to connect to the remote server?? anybody can explain this to me, because it is yet dull i can't understand how this invention works
I understand the upgrade.
But still I donot understand why I cannot make a connection over PHP.
There must be something different in SC-PHP and working with PHP scripts outside SC
You can do an ODBC connection using PHP, SC don't limits to this, but you can't integrate with SC objects (grid, forms, and so on) For this you need to create a SC connection, and for ODBC you need Enterprise. You can from PHp code do a OdBc connection and whatever you want, but you must establish all data for connection and manipulation of information (http://php.net/manual/es/book.uodbc.php )
Itsme3. ODBC is an standard for connection to databases (please, take this words just as conceptual for explanation). You have DSN pointing to a database and you can use it form anywhere (PHP, excel, Visual Basic, and so on). Said this, yes, you can use it from SC to retrieve or post data to your MsSQL database. Odbc is another layer, normally, is slower than using native drivers.