Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 12th, 2006, 10:25 AM
Authorized User
 
Join Date: Nov 2005
Posts: 72
Thanks: 3
Thanked 0 Times in 0 Posts
Default Can´t connect using ODBC

Hi,

On the server I have made a DNS conection for a DbaseIV file using the MS dbf driver.
Now after testing the code I wanted to link it to the real directory. So I changed the data in the ODBC admin, but now executing the ASp page I get the next error:

[Microsoft][Controlador ODBC dBase] '(desconocido)' no es una ruta de acceso válida. Asegúrese de que la ruta está escrita correctamente y que está conectado al servidor donde se encuentra el archivo.

if I trun back to the previous directory I can execute the code.
The test directory is located on the same server, diff. drive, where my \\Initpub is. The realy directory is located on another server.

In my ASP file is written:

Set conn = server.createobject("adodb.connection")
conn.open "DSN=datafarma"
set rs = server.createobject("adodb.recordset")

Should I make here somewhere a change?

Many thx Already,

Johny





Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect using MYOB ODBC driver mat41 Classic ASP Professional 0 August 7th, 2008 12:56 AM
connect jdbc/odbc bridge to ms- sql server 2000 sushant2002 SQL Server 2000 0 July 3rd, 2007 08:28 PM
How to connect Pervasive Software ODBC-32 in ASP kh Classic ASP Databases 0 June 12th, 2006 10:45 PM
Strange: get data but can´t see it rtr1900 Classic ASP Databases 1 January 11th, 2006 11:46 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.