Hello, I am installed php 5.3.28 with apache 2.2 and mysql 5.5.38 on windows 64 bit machine, despite configuring php correctly with apache and also enabled the extensions, its not able to recognise the mysql extension loaded. The connection attempt through adodb throws the error "call to undefined function mysql_connect() in adodb\drivers\adodb-mysql.inc.php on line 460". Also the function_exists('mysql_connect') return false; I would appreciate your quick suggestions. thank you.

Member Avatar
Member Avatar
+0 forum 3

If your Excel spreadsheet is laid out as regular columns and rows with a header row that identifies the columns then this code will allow you to read the data using ADODB the same way you would read records from a database table. To try this code 1. Create a new project 1. Add a ListBox control named ListBox1 1. Add a project reference to **adodb** 1. Replace the project code with the snippet code To create a test Excel spreadsheet just download the attached **test.zip** and unzip it. The file, **test.xls** contains a table of authors, books and a …

Member Avatar
Member Avatar
+1 forum 2

can someone help me to identify what is wrong with my code? i recheck and recode it many times as possible but still cant figure out the one error. it doesnt run.

Member Avatar
Member Avatar
+0 forum 7

hi my name is vishal for past 10 days i have been going nuts on how to combine selected datas from 3 or more tables into single sql select query in vb6. i have 4 tables named table1 name: Inward column Name DataType mfr_ref_number text no_of_bundle integer supplier_id integer DC_date date/time INV_date date/time row_upd_date date/time courier_name text inward_type text user_id long(contains 0 as value for all entries) DC_NO text closed_status boolean(true for some agn only) to_dept text agn long table2 name: item_master Column Name DataType user_id long(contains 0 as value for all entries) row_upd_date date/time deleted_status boolean(contains false value for …

Member Avatar
Member Avatar
+0 forum 3

Add the snippet in your module. **Requirements:** * Make sure you have reference to M$ ActiveX Data Objects Library (ADODB) * A table field with OLE Object / BLOB as datatype * A recordset that is already oppened and ready to be use **To save Image on your table field, call `SetRSBlob` function** Make sure that your **recordset is already loaded or openned** Lets assume that our recordset `rs` is already oppened and ready to be updated. Dim ret as Boolean ret = SetRSBlob("C:\image1.jpg", rs, "image") TRUE will be returned if image was set to the recordset field. All you …

Member Avatar
+1 forum 0

Hello people, First of all, i'm not an experienced ASP coder at all, i usually do php/java so i'm still kinda puzzled by this language. For my current project, i need to update a piece of an intranet, written completely in ASP. since it can't be reached from my position, the owner send me the complete code, and the database. (litterally a copy-paste of it). Before my first attempt to run the script, i corrected the link to the database file, and checked the file's permissions just to be sure. but i still get this error Microsoft OLE DB Provider …

Member Avatar
Member Avatar
+0 forum 2

Hello all! I am getting errors when I try to use this adodb.connection and command in my code. The error I am getting is saying that the connection and command are not defined. I read online that depending on your version of vb that you might use the "OLE" connection instead of ADODB but I am new to vb so I really don't know. I am really confused but I posted my code below.... Please help me or direct me to any sites that might help me with this [CODE]Imports System.Text.RegularExpressions Imports System.Data.OleDb Imports System.Data.SqlClient Imports System Partial Class _Default …

Member Avatar
Member Avatar
+0 forum 2

What's wrong with the code, pls help: setCon adoJOReport adoJOReport.RecordSource = "Shape{Select SUM(Cost) as SC,SUM(Price) as SP,Brand From Temp_JOMaster Where JoNumber='" & txtJO.Text & "'Group by Brand} " _ & "Append ({Select * From Temp_JOMaster " _ & "Where JOnumber='" & txtJO.Text & "'} Relate Brand To Brand) As Command2" adoJOReport.Refresh Any help will be greatly appreciated.

Member Avatar
Member Avatar
+0 forum 2

The End.