Hello,

I can ping SQL from the client - no problems. I am using IP connections.

BTW: All my clients are having this same issue with SQL and DSN error.

Thanks,

Dan

Hello,

I have just stumbled upon this same problem myself (same exact error). My application which uses these DSN's I have created some time ago, do work, because I have the...

Thanks for the reply.

I have done the insert with a quantity of 600000 records at a pop with a shrink in between and it worked fine, but... if I have...

Hello,

My Log File is giving me a hard time by filling up before my insert is complete. I am trying to do an insert into of about 1.2 million records....

Perfect... Will give it try.

Thanks,

Dan

Hello again,

According to Antares686 he mentions that you can add NT Groups to SQL. Can you explain how this is done? Is it different than adding a user to SQL?

Thanks...

Hello All,

Thanks for all of the good suggestions. Those last few sound like the way to go.

Will give it a try and let you know if there are problems.

Thanks again,

Dan

...

Thanks for the quick reply.

I will give your suggestion a try, and if I have trouble I will post here again.

Thanks again,

Dan

Steve,

We ended up installing the client network utility, and it looks like that solved the problem.

Thanks for your suggestions,

Dan

Steve,

Sorry, I did not answer your 1st question.

We can not connect to SQL Server with NT auth nor SQL Server auth on these machines.

Thanks,

Dan

Steve,

Thanks for the reply...

We are running SQL Server 2000.

The Clients are Win 98. Of the two clients that we were able to establish a connection with, they are Win 98...