ODBC Connection

[sudsburg]

I created dynamicxls in system DSN to connect to another server J:
it showed J:/weekly/suspenselist.xls

then
I created Data source in ColdFusion Administrator
i used ODBC socket then created name dynamicxls in data source
then choose dynamicxls from list of odbc


Connection verification failed for data source: dynamicXLS2
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Excel Driver] '(unknown)' is not a valid path. Make
sure that the path name is spelled correctly and that you are connected to the
server on which the file resides.

The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Microsoft][ODBC Excel Driver] '(unknown)' is not a valid
path. Make sure that the path name is spelled correctly and that you are
connected to the server on which the file resides.

[tzimmerman]

Make sure the ColdFusion MX ODBC Service and Agent are set up to start as the
user that mapped the drive. When you define the datasource in the CF
Administrator use the unc path (\\server_name\path\to\database) rather than
drive letter.

Ted Zimmerman

[sudsburg]

I am talking about EXCEL.

ODBC Adminstrator wont let me to use path \\server\pathto\.....

[tzimmerman]

I was remembering what worked with Microsoft Access. Check out the following
which is pretty close to what I mentioned initially:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17010[/url]

Ted Zimmerman

[sudsburg]

ok

let me explain again

i have a access and excel files in drive J (SAN)

I already set up system dsn in ODBC administration

then do cold fusion administration on data source to use odbc socket.

the biggest issue is cf admin wont recogize a path set up in odbc adminstration

[sudsburg]

System Adminstrator created virtual directory for that but ODBC Adminstration wont recogize it