Is your DSN a system DSN? If not, it needs to be. The webserver run's as a
different user. This is normal.
Quoting "Gonzalez, Juan" <JGonzalez@stripped>:
> Today I have more information about this problem.
> I install myodbc 3.51 driver and define a System DSN.
> The results are the same as with 2.x version.
> I run the test from the DSN configuration and connect successfully, but from
> ASP page (below you see the code) the message is the same: Provider not
> found.
> -------------- ASP connection
> <%@ LANGUAGE = VBScript %> <!-- #include file="adovbs.inc" -->
> <HTML>
> <HEAD> <TITLE>Simple ADO Query</TITLE> </HEAD>
> <BODY
> BGCOLOR="white" topmargin="10" ><!-- Display Header -->
> <b>Simple ADO Query with ASP</b></font><br>
> <%
> Dim oConn
> Dim oRs
> ' Create ADO Connection Component to connect
> ' with sample database
> Set oConn = Server.CreateObject("ADODB.Connection")
> oConn.Open "DSN=ludconsultas"
> oRs.close
> oConn.close
> %>
> </BODY> </HTML>
>
>
> Tipo de error:
> ADODB.Connection (0x800A0E7A)
> No se encontro el proveedor especificado. Es posible que no este instalado
> correctamente.
> /asp/sample.asp, linea 21
>
> Using the freeware soft odbctest v 2.7 of Jorgen Grosbol I can connect, do a
> select and disconnect without problems. In this case myodbc generates the
> log, in the ASP case not because the odbc driver was not called... perhaps
> here is begining my problem.
> I think that many programs can reach the myodbc driver and other not. The
> myodbc.dll is in c:\windows\system32 (default root directory).
> How many forms can i say that i pretend connect to that driver? or better
> than this: where the microsoft programs look to find odbc drivers?
>
> Of course I have not the response and even this questions are not the
> corrects.
>
> The myodbc.log result of the connection is the following (i apologize if its
> too much data)
> Thanks very much by any aid you can give me.
>
> | | : ----------------------------------------------------------
> | | : -- MySQL ODBC 3.51 Driver, VERSION: 03.51.06 --
> | | : -- --
> | | : -- DEBUG LOGGING --
> | | : -- --
> | | : -- TIMESTAMP: 030613 8:26:01 --
> | | : ----------------------------------------------------------
>
>
> | | info: option_flag: 524295 client_flag: 66
>
>
> | <get_client_flag
> | >mysql_real_connect
> | | enter: host: localhost db: lud_sd user: tst
> | | info: Server name: 'localhost'. TCP sock: 3306
> | | >vio_new
> | | | enter: sd=336
> | | | >_mymalloc
> | | | | enter: Size: 84
> | | | | exit: ptr: fb1118
> | | | <_mymalloc
> | | <vio_new
> | | >_mymalloc
> | | | enter: Size: 8192
> | | | exit: ptr: fa7588
> | | <_mymalloc
> | | >vio_fastsend
> | | | exit: 0
> | | <vio_fastsend
> | | >vio_keepalive
> | | | enter: sd=336 set_keep_alive=1
> | | <vio_keepalive
> | | >vio_is_blocking
> | | | exit: 1
> | | <vio_is_blocking
> | | >vio_read
> | | | enter: sd=336 size=4
> | | | exit: 4
> | | <vio_read
> | | >vio_read
> | | | enter: sd=336 size=46
> | | | exit: 46
> | | <vio_read
> | | packet: Memory: fa7588 Bytes: (10)
> 0A 34 2E 30 2E 31 32 2D 6D 61
> | | info: mysql protocol version 10, server=10
> | | >init_dynamic_array
> | | | >_mymalloc
> | | | | enter: Size: 64
> | | | | exit: ptr: fb1088
> | | | <_mymalloc
> | | <init_dynamic_array
> | | >get_charsets_dir
> | | | info: charsets dir='C:\mysql\\share\charsets\'
> | | <get_charsets_dir
> | | >my_fopen
> | | | my: Name: 'C:\mysql\\share\charsets\Index' Flags: 0 MyFlags: 0
> | | | >_mymalloc
> | | | | enter: Size: 31
> | | | | exit: ptr: fb12b8
> | | | <_mymalloc
> | | | exit: stream: 10090498
> | | <my_fopen
> | | >init_dynamic_array
> | | | >_mymalloc
> | | | | enter: Size: 128
> | | | | exit: ptr: fb2f68
> | | | <_mymalloc
> | | <init_dynamic_array
> | | test: my_once_malloc 4060 byte malloced
> | | >my_fclose
> | | | my: stream: 10090498 MyFlags: 0
> | | | >_myfree
> | | | | enter: ptr: fb12b8
> | | | <_myfree
> | | <my_fclose
> | | >_myfree
> | | | enter: ptr: fb2f68
> | | <_myfree
> | | >my_multi_malloc
> | | | >_mymalloc
> | | | | enter: Size: 80
> | | | | exit: ptr: fb2f98
> | | | <_mymalloc
> | | <my_multi_malloc
> | | >_mymalloc
> | | | enter: Size: 4
> | | | exit: ptr: fb12d8
> | | <_mymalloc
> | | >_mymalloc
> | | | enter: Size: 4
> | | | exit: ptr: fb2f48
> | | <_mymalloc
> | | info: Server version = '4.0.12-max-nt' capabilites: 8236 status: 2
> client_flag: 8271
> | | info: user: tst
> | | >_mymalloc
> | | | enter: Size: 7
> | | | exit: ptr: fb2ef8
> | | <_mymalloc
> | | >net_flush
> | | | >vio_is_blocking
> | | | | exit: 1
> | | | <vio_is_blocking
> | | | >net_real_write
> | | | | >vio_write
> | | | | | enter: sd=336 size=28
> | | | | | exit: 28
> | | | | <vio_write
> | | | <net_real_write
> | | <net_flush
> | | >vio_is_blocking
> | | | exit: 1
> | | <vio_is_blocking
> | | >vio_read
> | | | enter: sd=336 size=4
> | | | exit: 4
> | | <vio_read
> | | >vio_read
> | | | enter: sd=336 size=5
> | | | exit: 5
> | | <vio_read
> | | exit: Mysql handler: a236c
> | <mysql_real_connect
> | >_mymalloc
> | | enter: Size: 13
> | | exit: ptr: fb2e98
> | <_mymalloc
> | >_mymalloc
> | | enter: Size: 7
> | | exit: ptr: fb2e48
> | <_mymalloc
> | >_mymalloc
> | | enter: Size: 10
> | | exit: ptr: fb2de8
> | <_mymalloc
> | >_mymalloc
> | | enter: Size: 4
> | | exit: ptr: fb2d98
> | <_mymalloc
> | >_mymalloc
> | | enter: Size: 4
> | | exit: ptr: fb2d48
> | <_mymalloc
> <SQLConnect
> >set_connect_defaults
> <set_connect_defaults
> >SQLGetDiagRec
> | values: 2,0xa2368,1,0x6f224,0x0,0x0,0,0x6f788
> | exit : SQL_NO_DATA_FOUND
> <SQLGetDiagRec
> >SQLGetFunctions
> | enter: fFunction: 999
> | exit : SQL_SUCCESS
> <SQLGetFunctions
> >SQLGetInfo
> | enter: fInfoType: 23, cbInfoValueMax :2
> | exit : SQL_SUCCESS
> <SQLGetInfo
> >SQLGetInfo
> | enter: fInfoType: 24, cbInfoValueMax :2
> | exit : SQL_SUCCESS
> <SQLGetInfo
> >SQLAllocStmt
> | >list_add
> | | enter: root: 0 element: a55a0
> | <list_add
> | >init_dynamic_array
> | | >_mymalloc
> | | | enter: Size: 1280
> | | | exit: ptr: fa61e0
> | | <_mymalloc
> | <init_dynamic_array
> | exit : SQL_SUCCESS
> <SQLAllocStmt
> >SQLGetStmtAttr
> | enter: Atrr: 10010, ValuePtr: 0x861f80, BufLen: -4, StrLenPtr: 0x6f368
> | exit : SQL_SUCCESS
> <SQLGetStmtAttr
> >SQLGetStmtAttr
> | enter: Atrr: 10011, ValuePtr: 0x86200c, BufLen: -4, StrLenPtr: 0x6f368
> | exit : SQL_SUCCESS
> <SQLGetStmtAttr
> >SQLGetStmtAttr
> | enter: Atrr: 10012, ValuePtr: 0x862098, BufLen: -4, StrLenPtr: 0x6f368
> | exit : SQL_SUCCESS
> <SQLGetStmtAttr
> >SQLGetStmtAttr
> | enter: Atrr: 10013, ValuePtr: 0x862124, BufLen: -4, StrLenPtr: 0x6f368
> | exit : SQL_SUCCESS
> <SQLGetStmtAttr
> >SQLExecDirect
> | >SQLPrepare
> | | >_mymalloc
> | | | enter: Size: 25
> | | | exit: ptr: fb2cd8
> | | <_mymalloc
> | | enter: select * from sanciones
> | | info : Parameter count: 0
> | | exit : SQL_SUCCESS
> | <SQLPrepare
> | >SQLExecute
> | | enter: stmt: 0xa5568
> | | >SQLFreeStmt
> | | | enter: stmt: 0xa5568 option: MYSQL_RESET_BUFFERS
> | | | >mysql_free_result
> | | | | enter: mysql_res: 0
> | | | <mysql_free_result
> | | | exit : SQL_SUCCESS
> | | <SQLFreeStmt
> | | >do_query
> | | | >mysql_real_query
> | | | | enter: handle: a236c
> | | | | query: Query = "select * from sanciones "
> | | | | >vio_is_blocking
> | | | | | exit: 1
> | | | | <vio_is_blocking
> | | | | >vio_blocking
> | | | | | enter: set_blocking_mode: 0
> | | | | <vio_blocking
> | | | | >vio_is_blocking
> | | | | | exit: 1
> | | | | <vio_is_blocking
> | | | | >net_flush
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >net_real_write
> | | | | | | >vio_write
> | | | | | | | enter: sd=336 size=29
> | | | | | | | exit: 29
> | | | | | | <vio_write
> | | | | | <net_real_write
> | | | | <net_flush
> | | | <mysql_real_query
> | | | >mysql_read_query_result
> | | | | >vio_is_blocking
> | | | | | exit: 1
> | | | | <vio_is_blocking
> | | | | >vio_read
> | | | | | enter: sd=336 size=4
> | | | | | exit: 4
> | | | | <vio_read
> | | | | >vio_read
> | | | | | enter: sd=336 size=1
> | | | | | exit: 1
> | | | | <vio_read
> | | | | >free_old_query
> | | | | <free_old_query
> | | | | >read_rows
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=23
> | | | | | | exit: 23
> | | | | | <vio_read
> | | | | | >_mymalloc
> | | | | | | enter: Size: 40
> | | | | | | exit: ptr: fb2c68
> | | | | | <_mymalloc
> | | | | | >_mymalloc
> | | | | | | enter: Size: 8136
> | | | | | | exit: ptr: fab610
> | | | | | <_mymalloc
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=27
> | | | | | | exit: 27
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=32
> | | | | | | exit: 32
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=31
> | | | | | | exit: 31
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=31
> | | | | | | exit: 31
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=27
> | | | | | | exit: 27
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=27
> | | | | | | exit: 27
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=40
> | | | | | | exit: 40
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=1
> | | | | | | exit: 1
> | | | | | <vio_read
> | | | | | exit: Got 8 rows
> | | | | <read_rows
> | | | | >unpack_fields
> | | | | | >_mymalloc
> | | | | | | enter: Size: 8136
> | | | | | | exit: ptr: fad628
> | | | | | <_mymalloc
> | | | | | >free_root
> | | | | | | >_myfree
> | | | | | | | enter: ptr: fab610
> | | | | | | <_myfree
> | | | | | <free_root
> | | | | | >_myfree
> | | | | | | enter: ptr: fb2c68
> | | | | | <_myfree
> | | | | <unpack_fields
> | | | <mysql_read_query_result
> | | | >mysql_store_result
> | | | | >_mymalloc
> | | | | | enter: Size: 104
> | | | | | exit: ptr: fb2c28
> | | | | <_mymalloc
> | | | | >read_rows
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=44
> | | | | | | exit: 44
> | | | | | <vio_read
> | | | | | >_mymalloc
> | | | | | | enter: Size: 40
> | | | | | | exit: ptr: fb2bb8
> | | | | | <_mymalloc
> | | | | | >_mymalloc
> | | | | | | enter: Size: 8136
> | | | | | | exit: ptr: fab610
> | | | | | <_mymalloc
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=34
> | | | | | | exit: 34
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=36
> | | | | | | exit: 36
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=34
> | | | | | | exit: 34
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=32
> | | | | | | exit: 32
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=54
> | | | | | | exit: 54
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=50
> | | | | | | exit: 50
> | | | | | <vio_read
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=4
> | | | | | | exit: 4
> | | | | | <vio_read
> | | | | | >vio_read
> | | | | | | enter: sd=336 size=1
> | | | | | | exit: 1
> | | | | | <vio_read
> | | | | | exit: Got 7 rows
> | | | | <read_rows
> | | | <mysql_store_result
> | | | >fix_result_types
> | | | | >_mymalloc
> | | | | | enter: Size: 16
> | | | | | exit: ptr: fb2b58
> | | | | <_mymalloc
> | | | <fix_result_types
> | | | exit : SQL_SUCCESS
> | | <do_query
> | | exit : SQL_SUCCESS
> | <SQLExecute
> | exit : SQL_SUCCESS
> <SQLExecDirect
> >SQLRowCount
> | info : Rows in set: 7
> | exit : SQL_SUCCESS
> <SQLRowCount
> >SQLFreeStmt
> | enter: stmt: 0xa5568 option: SQL_DROP
> | >mysql_free_result
> | | enter: mysql_res: fb2c28
> | | >free_root
> | | | >_myfree
> | | | | enter: ptr: fab610
> | | | <_myfree
> | | <free_root
> | | >_myfree
> | | | enter: ptr: fb2bb8
> | | <_myfree
> | | >free_root
> | | | >_myfree
> | | | | enter: ptr: fad628
> | | | <_myfree
> | | <free_root
> | | >_myfree
> | | | enter: ptr: fb2c28
> | | <_myfree
> | <mysql_free_result
> | >_myfree
> | | enter: ptr: fb2b58
> | <_myfree
> | >_myfree
> | | enter: ptr: fb2cd8
> | <_myfree
> | >_myfree
> | | enter: ptr: fa61e0
> | <_myfree
> | exit : SQL_SUCCESS
> <SQLFreeStmt
> >my_SQLDisconnect
> | >mysql_close
> | | >free_old_query
> | | <free_old_query
> | | >vio_is_blocking
> | | | exit: 1
> | | <vio_is_blocking
> | | >vio_blocking
> | | | enter: set_blocking_mode: 0
> | | <vio_blocking
> | | >vio_is_blocking
> | | | exit: 1
> | | <vio_is_blocking
> | | >net_flush
> | | | >vio_is_blocking
> | | | | exit: 1
> | | | <vio_is_blocking
> | | | >net_real_write
> | | | | >vio_write
> | | | | | enter: sd=336 size=5
> | | | | | exit: 5
> | | | | <vio_write
> | | | <net_real_write
> | | <net_flush
> | | >end_server
> | | | info: Net: TCP/IP (336)
> | | | >vio_close
> | | | <vio_close
> | | | >_myfree
> | | | | enter: ptr: fb1118
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: fa7588
> | | | <_myfree
> | | | >free_old_query
> | | | <free_old_query
> | | <end_server
> | | >_myfree
> | | | enter: ptr: fb2f98
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: fb12d8
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: fb2f48
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: fb2ef8
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | | >_myfree
> | | | enter: ptr: 0
> | | <_myfree
> | <mysql_close
> | >_myfree
> | | enter: ptr: fb2e98
> | <_myfree
> | >_myfree
> | | enter: ptr: fb2e48
> | <_myfree
> | >_myfree
> | | enter: ptr: fb2de8
> | <_myfree
> | >_myfree
> | | enter: ptr: fb2d98
> | <_myfree
> | >_myfree
> | | enter: ptr: fb2d48
> | <_myfree
> | exit : SQL_SUCCESS
> <my_SQLDisconnect
> >SQLFreeConnect
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> | exit : SQL_SUCCESS
> <SQLFreeConnect
> >_myfree
> | enter: ptr: fb1658
> <_myfree
> >_myfree
> | enter: ptr: fb1788
> <_myfree
> >_myfree
> | enter: ptr: fb1608
> <_myfree
> >_myfree
> | enter: ptr: fb1088
> <_myfree
> >TERMINATE
> | safe: Maximum memory usage: 26216 bytes (26k)
> <TERMINATE
>
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=1
>
>
-------------------------------------------------
This mail sent through IMP: http://mail.pbc.ottawa.on.ca
