By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,434 Members | 2,963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,434 IT Pros & Developers. It's quick & easy.

How can I connect to a remote database?

P: n/a
I am using ODBC to connect to dBase data on a remote server. The ASP.NET app
will be running on Win 2k or 2003 server. I have tried to make it work but
all I can get is an error.

System.Data.Odbc.OdbcException: ERROR [HY024] [Microsoft][ODBC dBase 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. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY024] [Microsoft][ODBC dBase 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.

Everything works fine if the data and the .net app are on the same machine
but won't work if separated.

I'm using the DSN. The driver is Microsoft dBase driver. Any ideas besides
changing to OleDB?

Thanks
Nov 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi Dave,

The problem is that you're not trying to connect to a database server, such
as SQL Server, Oracle, or MySQL. You're trying to connect over a network to
a file-based database.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.

"Dave F." <df******@gmail.com> wrote in message
news:OM**************@TK2MSFTNGP10.phx.gbl...
I am using ODBC to connect to dBase data on a remote server. The ASP.NET
app will be running on Win 2k or 2003 server. I have tried to make it work
but all I can get is an error.

System.Data.Odbc.OdbcException: ERROR [HY024] [Microsoft][ODBC dBase
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. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY024] [Microsoft][ODBC dBase 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.

Everything works fine if the data and the .net app are on the same machine
but won't work if separated.

I'm using the DSN. The driver is Microsoft dBase driver. Any ideas besides
changing to OleDB?

Thanks

Nov 19 '05 #2

P: n/a
the asp.net process does not have network permission by default, so the
driver can not access the share. on you 2003 server, create an app pool with
a domain account, with permissions to the share, and setup your site to use
the app pool. on win2k, use the <identity> section in web.config to set a
domain account

-- bruce (sqlwork.com)
"Dave F." <df******@gmail.com> wrote in message
news:OM**************@TK2MSFTNGP10.phx.gbl...
I am using ODBC to connect to dBase data on a remote server. The ASP.NET
app will be running on Win 2k or 2003 server. I have tried to make it work
but all I can get is an error.

System.Data.Odbc.OdbcException: ERROR [HY024] [Microsoft][ODBC dBase
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. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY024] [Microsoft][ODBC dBase 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.

Everything works fine if the data and the .net app are on the same machine
but won't work if separated.

I'm using the DSN. The driver is Microsoft dBase driver. Any ideas besides
changing to OleDB?

Thanks

Nov 19 '05 #3

P: n/a
Bruce,

Thanks for the help. I think we are on to something now. Our SQL database is
about a year away. I'm sure that will make life much easier.

Dave

"Bruce Barker" <br******************@safeco.com> wrote in message
news:eB**************@TK2MSFTNGP14.phx.gbl...
the asp.net process does not have network permission by default, so the
driver can not access the share. on you 2003 server, create an app pool
with a domain account, with permissions to the share, and setup your site
to use the app pool. on win2k, use the <identity> section in web.config to
set a domain account

-- bruce (sqlwork.com)
"Dave F." <df******@gmail.com> wrote in message
news:OM**************@TK2MSFTNGP10.phx.gbl...
I am using ODBC to connect to dBase data on a remote server. The ASP.NET
app will be running on Win 2k or 2003 server. I have tried to make it work
but all I can get is an error.

System.Data.Odbc.OdbcException: ERROR [HY024] [Microsoft][ODBC dBase
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. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY024] [Microsoft][ODBC dBase 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.

Everything works fine if the data and the .net app are on the same
machine but won't work if separated.

I'm using the DSN. The driver is Microsoft dBase driver. Any ideas
besides changing to OleDB?

Thanks


Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.