Connecting to a Database

[dcarlson]

How can I access a database that resides on a server other than the web server?

I have a database on a netware server that I want to connect to through a Windows 2000 web server.

Can I set up a DSN?

I believe that if you install gateway services for netware on the nt server, you can connect to the database on the netware server.

[dcarlson]

I've tried the gateway services with no luck. My Netware server is version 3.2

Is there something I'm missing with the Gateway Services?

[parksie]

What type of database is it?

If it's a single file database like an Access database then I'm sure you could just setup a samba share and map straight to it.

If the database runs as a service that you connect to (like SQL Server) then I'd have thought it wouldn't matter what kind of server it was on providing you had the appropriate driver to talk to it. You should be able to get an ODBC drive for most kinds of databases so you can then setup a DSN as normal.

What type of database is it?

[dcarlson]

It's a Visual FoxPro Database.

I've tried mapping a drive on the web server to the drive that holds the database. I've also tried the Gateway services with no luck. I've also tried connecting with a file DSN and a system DSN.

I've also tried installing a VB project on the web server that connects to the same database and it worked fine.

[vbfirelfy]

I am pretty sure this is to do with the Settings on the server (Chmod internal / external access).

What most webservers dont allow is the execution / access of files from any where other than there own server.

So...What I mean is, when you are accessing the programme you created and uploaded it to the server it is accessing the Database internally so no problem.

But you cant access it externally.

If you no CGI, its the same thing exactly.

Im sorry If I didnt explain very well, i will put it simply.

Your server DOES NOT ASLLOW YOU TO ACCESS THAT FILE FROM A REMOTE COMPUTER, but WILL ALLOW YOU TO ACCESS IT USING AN UPLOADED PROGRAME THUS INTERNAL ACCESS :-P

=Sorry but I think your looking up the ass of a dead duck, cause no matter what you try, you just wont be able to access that dbase, from a programme (.exe, .com) unless that programme is on your webserver where the dbase is. I know CGI is the same (as I have said) and I know how frustrating it is!!!

[dcarlson]

What's wierd is when I created the ASP app, I was using Personal Web Server on my system and was able to map a drive to the database and access it externally. I guess PWS doesn't have the sort of restrictions that windows 2000 has.

[Edited by dcarlson on 01-15-2001 at 09:46 AM]

[Brandito]

set conn = server.createobject("adodb.connection")
conn.open "dsn=mydatabase"

set rs = conn.execute(sql)

This is some sample code.
I use it for my buisness applications.
Im using Access with DSN.

[dcarlson]

I've tried that, I think the problem is that I can't share the remote data (Database on netware server) over the internet.

I think my last resort is hosting the database on the web server. Which sucks because I'll have to buy extra CALs for the web server.

Thanks anyway.