Hello, I am having issue connecting my Access database to my PHP site via ODBC. Here is what I am doing: <?php $dbName = "F:\Data\Web\_Home\TickSys\TickSys.accdb"; if (!file_exists($dbName)) { die("Could not find database file."); } print "Found DB File."; $db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=$dbName; Uid=; Pwd=;"); ?> The error I receive is: Found DB File. Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified' in F:\Data\Web\_Home\TickSys\index.php:20 Stack trace: #0 F:\Data\Web\_Home\TickSys\index.php(20): PDO->__construct('odbc:DRIVER={Mi...') #1 {main} thrown in F:\Data\Web\_Home\TickSys\index.php on line 20 What I have tried: …

Member Avatar
Member Avatar
+0 forum 1

please i need help on making data report which the database is access 2007 with accdb format. what connection will i use and how and sample codes. thanks a lot in advance.

Member Avatar
Member Avatar
+0 forum 2

Hello I am having some trouble here, I created a Microsoft Access dataset (.accdb) It is being used with some listboxes, comboboxes etc. The problem is when I publish the whole thing the datasets do not publish along with it and my program opens but there are not values. Anyone have any idea to allow the .accdb file to publish as a resource or something. Thanks

Member Avatar
Member Avatar
+0 forum 6

I know i'm probably goin about this bassackwards. But, window is loaded, binded textboxes get filled, user edits textboxes and clicks a save button it works, all except crashing with a "vb.net 2010 Concurrency violation: the UpdateCommand affected 0 of the expected 1 records." most of the time but the data does get updated any ideas on how to be rid of this error will be much appreciated thnx n adv [CODE]'form.vb code for button_click Dim dtNewRow As DataRow dtNewRow = dbDataSet.Table.NewRow() dtNewRow.Item(dbDataSet.Table.Column) = Textbox.Text '<--this line is followed by 33 more that vary on column and textbox BindingNavigatorDeleteItem.PerformClick() dbDataSet.Table.Rows.Add(dtNewRow) …

Member Avatar
Member Avatar
+0 forum 1

The End.