I work on a third party language product which does dynamic binding via ODBC and a customer is wanting to be able to insert bound variables without a field list, i.e. INSERT INTO table VALUES (values), not INSERT INTO table (columns) VALUES (values). The problem is that in the former case for SQLServer bind variables, the AUTO_INCREMENT...
I am trying to something like this: string pathFiles = Path.Combine(Application.StartupPath, "DB"); string strconn = "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;" + "Dbq="+pathFiles+";"; OdbcConnection odbconn = new OdbcConnection(strconn); odbconn.Open(); ...
I am trying this to make a select and it works just fine string str = "SELECT * FROM FREE RIGHT JOIN TestTest ON FREE.DOCNO = TestTest.DOCNO"; DataTable dt = new DataTable(); OdbcDataAdapter da = new OdbcDataAdapter(str, odbconn); da.Fill(dt); I am trying this to create a .dbf and i get this OdbcException : string str0 = "Create...
Hi I am using this code to create a .dbf file and it works fine ( i use OdbcConnection ) string TblInventory = "Create Table Inventory (Id int , Date datetime, CreatedBy char(100))"; OdbcCommand cmd = new OdbcCommand(TblInventory, odbconn); cmd.ExecuteNonQuery(); Insert works well: "Insert Into Inventory (Id, Date , Creat...
Hi I have a problem here using .dbf files. I can make CRUD operations but i get an exception when i try to use transactions. I am doing like this: public void AddRolesToUser(string user, string[] roles) { using (OdbcConnection connection = new OdbcConnection(ConnectionString)) { OdbcCommand command = ...
I'm making a call to odbc32.dll (SQLBrowseConnect) to return a list of databases on a sql server. From running a trace I can see the query being executed is select name from master..sysdatabases where has_dbaccess(name)=1 If the credentials I pass aren't the sa user it returns just the system databases. Is there anyway I can use SQL...
I cant see what is wrong with my SQL statement syntax code is here: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Using Con1 As New Odbc.OdbcConnection("Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;Database=MyGame;User=root; Password=MyPasswordWhichIWontTellYou;") ...
I wonder any one is conneting Sybase ASE using pyodbc in Django? Any wrapper available for that? Any solution? Currently there are: - sqlany-django (http://code.google.com/p/sqlany-django/) for Sybase SQL Anywhere and not Sybase ASE - django-pyodbc (http://code.google.com/p/django-pyodbc/) for MS SQL Server through pyodbc Thanks. ...
we need to build a heroku app which stores data in a DB table. we have proprietary software that needs to connect via ODBC to the DB. what driver do we need? ...
I need to connect from a web LAMP (PHP) environment to a remote Navision installation which has ODBC drivers on the server. Does the web server need the ODBC drivers on it locally as well? Or does PHP connect to the Navision server environment with it's own local drivers? Also, can I drop SSL on this connection for security - if so whi...
I am in DataGrid hell right now but that's another post. Anyway, I wrote a view with a union query in SQL Server that grabs data from a linked SQL server. Anytime I try to add this object as a dataset in VB.NET it completely bombs out on me with this ugly error message... ERROR [42000] [Microsoft] [ODBC SQL Server Driver] [SQL Server]...
why can i use myob Odbc direct driver v7my with windows 7, i have tried using the same odbc driver with XP and vista and it works fine. please help me tnx. ...
Hello. Using ASP.NET as programming language on IIS Server. the Database is access and i connect to the database using ODBC. when i fill some form in the website and press submit i get an exception: Server Error in '/' Application. Description: An unhandled exception occurred during the execution of the current web request. Please re...
I am trying to execute an SQL query on an Adaptive Server Anywhere database. Here it is: SELECT count(*) AS s FROM ( SELECT column1, count(*) AS n FROM table1 GROUP BY column1 HAVING n > 1 ) In the subquery, I want to get all the rows that are duplicates and in the outer query I want a count of the rows that are dupli...
I am new to Joomla and new to php (wish I was so new in age too). I have installed joomla on a local apache webserver. I am trying to use some php code in a joomla article in order to fetch some data from a Sybase ASE 12.5 database. I installed sourcerer and started to try an ODBC connection using a system DSN (which I verified it is wor...
I've got a program that i've been supporting that recently was installed on a windows 7 machine. Everything has been working however recently this machine has started Receiving the following error when using the recordset.update method after modifying fields i've received the following error. -2147467259 ([MySQL][ODBC 3.51 Driver][...
i am using SQLite3 ODBC Driver as my connection string, Dim conn As ADODB.Connection Set conn = New ADODB.Connection Dim rs As New ADODB.Recordset Set conn = New ADODB.Connection conn.ConnectionString = "DRIVER=SQLite3 ODBC Driver;Database=test.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;" conn.Open rs.Open "sele...
I have recently installed Mono on our Fedora Linux system so that we are able to run ASP.NET applications on it. I was able to get this part up and running, but the problem is we use a Informix DB and Mono seems to stop the ODBC from working. Have anyone any experience of getting an ODBC to connect to an Informix DB with Mono instal...
I have an Excel spreadsheet with, among onther things, numbers that are identifiers. My odbc reader should return me something like '55201562000016', but too often it returns me something like '5.52016e+008'. I only do the following, but apparently it does not suffice to tell the reader that it should be treated as a string and not an e...
I do data conversions, and I am constantly connecting to a variety of different DBMS'. Certain DBMS' do not have JDBC drivers (MsAccess for example). Sun's JDBC-ODBC bridge driver was meant as a short term solution when JDBC drivers weren't widely available, and because of that, it is lacking functionality and is pretty buggy. I am to...