SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 SQLBASE to SQL 2000
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

X002548
Not Just a Number

15586 Posts

Posted - 02/20/2004 :  10:31:29  Show Profile
Yeah, Yeah, it's standardization time here....

Who let all this crap in, in the first place, I'll never know....

Damn thing has got to be from the mid 80's

Trying to point ERWin at it (and we all know how GREAT their documnetation is for 3.51) But it keeps telling me that it can't find SQLWNTM.DLL in my Path or working directory.....

What's a working directory? It doesn't say...found the DLL though...

Anyway...I need to find a comparison doc (or make one myself) to aid in the migration...

Did you know, the syntax for an outter join is a.col1 = b.col1(+)...

Like Oracle...but they only allow 1 outter join per query...

And this damn thig sends money out the door....

Where is that half penney router I remeber hearing about....



Brett

8-)

jhermiz
Flowing Fount of Yak Knowledge

USA
3564 Posts

Posted - 02/20/2004 :  11:19:26  Show Profile  Visit jhermiz's Homepage
huh?

Regarding working directory: it is just that the directory you are working. In unix based systems its


pwd


and in windows based systems at a console its


cd


both return the current working directory. Your path can be set if you right click on my computer, goto properties, advanced tab, button reads 'environment variables' (at least it does in winxp).

As for the rest of your question I never have a clue what you're talking about (or smoking).
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 02/20/2004 :  12:01:16  Show Profile
quote:
Originally posted by jhermiz

huh?

Regarding working directory: it is just that the directory you are working. In unix based systems its


pwd


and in windows based systems at a console its


cd


both return the current working directory. Your path can be set if you right click on my computer, goto properties, advanced tab, button reads 'environment variables' (at least it does in winxp).

As for the rest of your question I never have a clue what you're talking about (or smoking).



Just Maragrittas these days my friend...

And its an ERWin message...

quote:

Establishing connection to SQLBase;
Unable to load sqlwntm.dll (0)
Check that sqlwntm.dll is in your path or working directory



I wish it were in the path of my commuter train right about now...



Brett

8-)
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 02/20/2004 :  12:17:20  Show Profile
google found this for you:

http://www.sqldirect-soft.com/faqs.html#q2

Look at the section for the client install, this DLL is part of the client.


-ec
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36907 Posts

Posted - 02/20/2004 :  12:31:50  Show Profile  Visit tkizer's Homepage
Brett, path information is a system environmental variable on your computer. If it can't find a file in the current directory, it checks for the file in the directories listed in your path.

To see your path, right click on my computer, go to properties, then to advanced, then to environmental variables button. I'm on XP, so to get to that button, it might be just a tad different.

You can also easily get to your path by typing path in a cmd window. Modifying your path though, I would suggest going to the environmental variables button.

So is that DLL in your path?

Tara
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 02/20/2004 :  14:41:17  Show Profile
Thanks eyechart/Tara

I got everything as it is suppose to be....I guess ERWin 3.5x on Win2k might be causing a problem....

Damn....

Maybe I'll try adding to the Path and place it in the root C:
What's a working dir again? I figure it's where ERWin Launces...yeah I put it there too...as well as about a dozen places....





Brett

8-)
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36907 Posts

Posted - 02/20/2004 :  15:02:33  Show Profile  Visit tkizer's Homepage
So when you say SQLBASE, are you referring to Centura SQLBase? If so, I think there is a sql.ini file on your machine that sets the working directory. It's been over 2 years now since I've worked on that DBMS, so I could be wrong. You'll probably find a few sql.ini files on your machine.

Tara
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 02/23/2004 :  14:17:17  Show Profile
Well I found it on the lan...do I need to install it's client tools?

I can access the damn thing through SQLTalk

I made all of the path chmages, ect, and I still get the same error...

Anyone know what I have to do with the SQL.INI File?

I wonder if I can use DTS?



Brett

8-)
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36907 Posts

Posted - 02/23/2004 :  15:15:23  Show Profile  Visit tkizer's Homepage
It's been too long since I've seen a sql.ini file. Yes you can use DTS to transfer the data, but the ODBC drivers will have to be installed on the database server or on a client machine such as yours. The ODBC drivers are installed when you install the tools.

Tara
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000