Re: Connection to SQLServer2000
Re: Connection to SQLServer2000
- Subject: Re: Connection to SQLServer2000
- From: Lotsa Cabo <email@hidden>
- Date: Thu, 15 Jul 2004 23:09:13 -0400
Bill,
I am a Microsoft developer (most proficient in .NET/C#/SQL2K). I have
been doing some cross-platform stuff with WebObjects and SQL2K for
about a year or so now. What I can tell you is this...
1. I have never tried using the MSDE; just a full install of SQL2K Dev
Edit;
2. Be sure to install the JDBC drivers as this is not part of the
default install; and,
3. Assuming you do #1 and #2, above, I promise that it will work
flawlessly.
I would HIGHLY recommend looking at Ravi Mendi's (sp?) book,
"WebObjects Development Guide." I used this last year and it was quite
straight forward. The only drawback, from a Microsoft standpoint, is
that it is written for Project Builder (the older Mac IDE). Other than
that, it's a great starting point and will surely get you past all of
the elementary areas. By the time you are done with the first few
chapters, you will be able to build web-based database apps without any
problems. As far as BUYING the book, don't bother at this point...
sign up for a free 14-day trial of Safari Bookshelf and you will have
full access to the book. All of the source can then be downloaded from
SamsPublishing.Com.
Hope this helps.
R/S
Ryan
_________________________
Tired of spam? Signup for a FREE SpamJammer.Com account and say
goodbye to junk email forever!
On Jul 15, 2004, at 5:33 PM, Bill Reynolds wrote:
> I'm trying to connect to a Windows data source and am a little (lot)
> in the
> dark.
>
> I have an XP machine running "MSDE" (Microsoft Desktop Engine),
> publishing a
> SQL Server 2000 database, for testing purposes named "Tigerpaw.mdf".
> The
> workstation is i.p. Address 10.0.0.23.
>
> My attempted connection string (in EOModeler) is "
> jdbc:SQLServer://10.0.0.23/Tigerpaw" which gives me a nice long error
> in
> EOModeler (error msg below).
>
> I must be making a bunch of elementary mistakes right out the gate.
> The
> idea that it would "simply work" is a bit far fetched. Can anyone
> lend a
> hand on the in's/out's of connecting/modeling?
>
> I appreciate any help :)
>
> Thanks,
>
> -Bill Reynolds
>
>
>
> Error Message from EOModeler:
> -----------------------------------
>
> JDBC connection failed for driver
> :'com.microsoft.jdbc.sqlserver.SQLServerDriver'. Driver not found in
> Java
> Runtime! Please verify your CLASSPATH environment variable. The current
> CLASSPATH for your application is :
> _______________________________________________
> webobjects-dev mailing list | email@hidden
> Help/Unsubscribe/Archives:
> http://www.lists.apple.com/mailman/listinfo/webobjects-dev
> Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.