Well, you can always try WHERE textcolumn LIKE “%SUBSTRING%” – but this is guaranteed to be pretty slow, as your query can’t do an index match because you are looking for characters on the left side. It depends on the field type – a textarea usually won’t be saved as VARCHAR, but rather as (a … Read more
Microsoft has PHP Linux Drivers for SQL Server for PHP 7 and above on PECL. These are production ready. To download them, follow these steps: Ubuntu 16.04: sudo su curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add – curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list exit sudo apt-get update sudo ACCEPT_EULA=Y apt-get install -y msodbcsql mssql-tools unixodbc-dev sudo pecl install sqlsrv … Read more
If you’re using SQL Server, after your query you can select the @@RowCount function (or if your result set might have more than 2 billion rows use the RowCount_Big() function). This will return the number of rows selected by the previous statement or number of rows affected by an insert/update/delete statement. SELECT my_table.my_col FROM my_table … Read more
bool exists; try { // ANSI SQL way. Works in PostgreSQL, MSSQL, MySQL. var cmd = new OdbcCommand( “select case when exists((select * from information_schema.tables where table_name=”” + tableName + “”)) then 1 else 0 end”); exists = (int)cmd.ExecuteScalar() == 1; } catch { try { // Other RDBMS. Graceful degradation exists = true; var … Read more
Another option: Instead of creating a ODBC driver, implement a back end that talks the wire protocol that another database (Postgresql or MySQL for instance) uses. Your users can then download and use for instance the Postgresql ODBC driver. Exactly what back-end database you choose to emulate should probably depend the most on how well … Read more
ODBC Driver for SQL Server ODBC is the primary native data access API for applications written in C,C++, PHP, Python and others for connecting to SQL Server. It’s widely used in data integration scenarios. Also, it’s preferred if you are developing application on Windows and deploying it to Linux . SQL Server The full name … Read more
You can specify the connection string as one long string that uses semi-colons (;) as the argument separator. Working example: import pyodbc cnxn = pyodbc.connect(r’Driver=SQL Server;Server=.\SQLEXPRESS;Database=myDB;Trusted_Connection=yes;’) cursor = cnxn.cursor() cursor.execute(“SELECT LastName FROM myContacts”) while 1: row = cursor.fetchone() if not row: break print(row.LastName) cnxn.close() For connection strings with lots of parameters, the following will accomplish … Read more
None of these did it for me. I did find the answer on MSDN. There were hints to it though. The architecture in the error is referring to 32 vs 64 bits. My solution was to find out which my app is running under (Access) which 2010 is 32b. I found this by looking in … Read more
How about: return (returnValue == “1”); or as suggested below: return (returnValue != “0”); The correct one will depend on what you are looking for as a success result.
Got this error because I had the Data Source Name in User DSN instead of System DSN