File sharing and Port 139

[RSK]

Hi,

I have a network in an isp that run win2000 servers.
I need to setup an ODBC Datasource on one computer that
the DataBase is on the other computer. For this reason I
need to share the Database drive but port 139 is blocked
for security purpose and the "Network Path not found"
error occured. is there another way to do this?

Best regards,
RSK.

 

[andy]

-----Original Message-----
Hi,

I have a network in an isp that run win2000 servers.
I need to setup an ODBC Datasource on one computer that
the DataBase is on the other computer. For this reason I
need to share the Database drive but port 139 is blocked
for security purpose and the "Network Path not found"
error occured. is there another way to do this?

Best regards,
RSK.
.
I don't know why you would need file sharing open for an

ODBC connection. Typically, database connections do not
run like this. For instance, to connect to SQLPlus in
Oralce it starts on TCP 1521. You can use Connection
Manager if you have Oracle. If you have SQL, it uses
only one port to connect to.

 

[Jeff Cochran]

I have a network in an isp that run win2000 servers.
I need to setup an ODBC Datasource on one computer that
the DataBase is on the other computer. For this reason I
need to share the Database drive but port 139 is blocked
for security purpose and the "Network Path not found"
error occured. is there another way to do this?

First, stop using ODBC and switch to OLEDB. You don't mention a
database server type, but if it's SQL or Access you could use a remote
provider connection.

Might also check: http://www.aspfaq.com/show.asp?id=2168

Jeff

 

[Karl Levinson [x y] mvp]

Unless I am mistaken, your ODBC connection and/or SQL Client software
are configured to use Named Pipes or Multiprotocol, which can require
you to do Windows authentication over TCP 139 before even intitiating
the data connection.

Try switching the "Client Configuration" to TCP/IP instead when you
set up the ODBC connection.

 

[RSK]

Hi,
The problem is that I have a accounting software that use
ODBC access driver and I need to setup an ODBC (in system
DSN)On the computer that contain web server that the
desired Database in other computer (for security). but
when i want to select the database from the NETWORK button
(in ODBC administrator) the "network path was not found"
message appear and the database file is not accessible.
???

Best Regards,
RSK.

 

[RSK]

Hi,
The problem is that I have a accounting software that use
ODBC access driver and I need to setup an ODBC (in system
DSN)On the computer that contain web server that the
desired Database in other computer (for security). but
when i want to select the database from the NETWORK button
(in ODBC administrator) the "network path was not found"
message appear and the database file is not accessible.
???

Best Regards,
RSK.

 

[RSK]

Hi,
The problem is that I have a accounting software that use
ODBC access driver and I need to setup an ODBC (in system
DSN)On the computer that contain web server that the
desired Database in other computer (for security). but
when i want to select the database from the NETWORK button
(in ODBC administrator) the "network path was not found"
message appear and the database file is not accessible.
???

Best Regards,
RSK.

-----Original Message-----

 

[Karl Levinson [x y] mvp]

I'm no expert at this, but it sounds like perhaps the database type you are
trying to access or the way you're trying to access it [I'm still not clear
on what type of database this is exactly] can only be accessed by using
NetBIOS to access the file and file share. Moving the data to a different
database such as MS SQL, the free Microsoft MSDE, the free mySQL, etc. if at
all possible would let you access these files without opening TCP 139 and
UDP 138.

Or, you could use the existing database and open up those ports just for the
one IP address for the server that needs to access it.