Hi all, this little program sends data from the defined range below. Open "Dat_Tidsrapport", New Con, ad Open Dynamic, ad Lock Optimistic For Each rng In rng.
The strange scenario is if i open the excel file and enter some data it works lika a sharm, no error and the data apperas in the database. Recordset Dim rng As Range Set rng = Active Workbook.
With some ODBC drivers, executing a complex stored procedure may fail with an error similar to: "Cannot open a cursor on a stored procedure that has anything other than a single select statement in it". Also, some drivers don't support the optional row_number parameter in - Windows - OS- Apache- ODBC-Connction to MS-Access DB on a:- Network Share After many hours searching here´s how it works:- Map the Network Drive where the mdb is located- Setup System DSN in Control Panel with mapped Drive- Open Registry at: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC_INI- Edit the for example "M:\" to "\server\..."- Close Regedit- The Apache-Service must run with a Domain (network)-User!!
I couldn't understand what was going on and after a bit of research I found out that with My SQL they recommended using mysql_pconnect() for INSERT queries. If using Openlink to connect to a Microsoft Access database, you will most likely fine tha odbd_connect() works fine, but discover that ANY query will produce odd results; with SELECT queries failing with "[Open Link][ODBC][Driver]Driver not capable, SQL state S1C00 in SQLExec Direct in on line xx" and INSERT / DELETE queries warning "No tuples available at this result index". This had me stumped for quite some time; because it was the odbc_exec() which was seemingly at fault...
:) Siggy A VERY IMPORTANT NOTE OF CAUTION FOR WINDOWS USERS DEVELOPING ON NON-NETWORKED SYSTEMSIf like me you are developing on a stand-alone system (Windows XP professional running IIS).
If i write to DB first several times there is no problem to update the table via dataconnection, it's the other way around as described on first line.
Access advance settings : Default Open Mode = Shared Default record Locking = No Locks Data Connections strings looks like below in excel for one table import: Provider=Microsoft. OLEDB.12.0; User ID=Admin; Data Source=G:\Logistik\Enhet Grngesberg\Tidsrapportering\Tidsrapport.accdb; Mode=Share Deny Write; Extended Properties=""; Jet OLEDB: System database=""; Jet OLEDB: Registry Path=""; Jet OLEDB: Engine Type=6; Jet OLEDB: Database Locking Mode=0; Jet OLEDB: Global Partial Bulk Ops=2; Jet OLEDB: Global Bulk Transactions=1; Jet OLEDB: New Database Password=""; Jet OLEDB: Create System Database=False; Jet OLEDB: Encrypt Database=False; Jet OLEDB: Don't Copy Locale on Compact=False; Jet OLEDB: Compact Without Replica Repair=False; Jet OLEDB: SFP=False; Jet OLEDB: Support Complex Data=False; Jet OLEDB: Bypass User Info Validation=False; Jet OLEDB: Limited DB Caching=False; Jet OLEDB: Bypass Choice Field Validation=False Well, The problem is when I've run a table update just to import new data via a ordinary connection string and then run the VBA code to write data to DB.
Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009 in SQLConnect in d:\apache\cm\on line 13So...
I started looking al around and looks like the ODBC driver has some severe problems:1.
If you (still) get that annoying error like and you're using Access: MSaccess DSN(Microsoft Jet engine couldn't open the database 'Unknow'.
Another user is using it exclusively, or you dont have permission to useit).
I open the file and can easily write data to access DB.
Close Set New Con = Nothing End Sub Ok, the code itself seems to be fine now.
You cannot make a system DSN with a UNC (\Server\resource), so you must map the drive Cute isn't it? I quit on ODBC and went via ADO, this is the code that works:=== CODE ===$db = '\\server\resource\db.mdb';$conn = new COM('ADODB.