SQL Server (or the lack of it) problems....

phobos · 17-04-2001 03:27AM #1

Hey all,

To be honest I never thought I would have anything to post on the Admin thread, but I think this is the only place I would expect to get an answer.

I am a Java programmer (student) working on the Win98/NT platforms. I am trying to write server side software to connect to a database. 2nite I ran in to problems because:

- I am running a Java web server on this system (Win98)
- The server program runs on the web server
- the database system (Access) is running on the localhost

What I cannot understand is that I cannot connect to the database from the server app, even when both server and client exist on the same machine. Just to make sure I was not ****ing up in the code I created a stand alone program (not a server one) that tried to connect to the local database (and it did!). I tried doing all the obvious things like specifying (/localhost, or /127.0.0.1) on the server on to see it that would help and still nothing.

I think it has something to do with the Access Drivers in the Control Panel I have setup. It does say in there that, the drivers will only accept connections from local apps. Does this mean that I will need to get my hands on something like SQL Server?? So I can create a DB driver that can accept connections from remote hosts.

I have encountered this problem and are rather ****ed off, since this is supposed to be an n-tier project. Any help would really be appreciated.

Thanks in advance...
:-phobos-)

Stephen · 17-04-2001 04:08AM

Have you tried the programming/webmaster boards yet?

ecksor · 17-04-2001 09:07AM

*moves*

He has now.

ecksor · 17-04-2001 09:13AM

Actually, fancy showing the connection code and detailing how you set up the database connection?

kayos · 17-04-2001 09:30AM

Hold up here what I take you to mean is the following Your tring to get your Web Server to talk to a Database on the Client PC???? If this is so all I can say is WTF

To be honest I have never come across any problems connecting into a database with Web apps (mainly ASP) The best and easist thing to try is setting up a System DSN to your access db and try connecting using straight ADO in VBS or JScript if you can do that its your connection code otherwise I'm at a loss until I have a bit more info.

kayos

yossarin · 17-04-2001 10:41AM

you does be having to set up the database file as a data source on your system - use the ODBC thingie in control pannel - make sure that the DS name is the same as the file, also the ODBC WILL have to remember any username/password you've put on the database.

read up on JDBC - it'll have all of this stuff detailed
also...after searches/etc. you might have problems 'cos of Access read/write locking, so you might have to get your code to explicitly release it [bad grammer, BAD]

hope that helped the issue rather than confusing it

[This message has been edited by yossarin (edited 17-04-2001).]

Evil Phil · 17-04-2001 10:44AM

When you specify the localhost to the server it will only connect to itself (the localhost). Would you not put the database on the same machine as the server, or is this what your doing? If the db is on the server then set up a system dsn (as already stated) on the client and use this to connect to the db. You made also need the MDAC if you don't have Access already installed on the server. Post some code so we can say hmmm and ohhh and come up with some suggestions.

SQL Server (or the lack of it) problems....

Comments