Recent content by RyanGlas

Does anyone have any sugestions on where I can go to figure out the code to do a search with zip codes. I have a database with the zip codes, lat & long. I would like to know how to program a search so that when someone searches their zip code they can find anything within X amount of miles...

Well I checked the port and the firewall. There was a firewall on my connection. I allow the IP to go through that and also tried just disabling the firewall. I was still getting the same message. It's only when I try to open up a table or create a new table. I am able to rename the tables...

Also this afternoon I uninstalled SQL and reinstalled it making sure that I installed service packs 1,2&3. Still getting the same message.

Yes. No matter if I just want to return all row or go into the table through design view it comes back with the "catastrophic failure" message. This also happens when I try to create a new table as well. I haven't tried to delete a table for the obvious resons that I can't create a...

My connection seems to keep dropping when I try to do anything that requires opening a table on my server. It comes back at me with a "Catastrophic Failure" message. When I work on my local drive everything is fine. I am able to log onto the server fine and view all the tables but...

Yah it has to be something like that. However, it only happens once I am trying to open a table and it never did this prior to the other day. Do you think that SQL is sending something somewhere on my hard drive when it is doing this that my network doesn't like and disconnects for a split second.

For some reason I am having issues connecting to my SQL Database online. When I am finally able to view the tables in the database I go to "open table" and select "return all rows". Then out of nowhere I get a message saying. "An unexpected error happened during this...

For some reason I am having issues connecting to my SQL Database online. When I am finally able to view the tables in the database I go to "open table" and select "return all rows". Then out of nowhere I get a message saying. "An unexpected error happened during this...

I just wanted to let you know that the issue is solved. It was the DBO that did not have the correct username / userlogin. thank you for your help!!!

For some reason I am having issues connecting to my SQL Database online. When I am finally able to view the tables in the database I go to "open table" and select "return all rows". Then out of nowhere I get a message saying. "An unexpected error happened during this...

Terry - Thank you. Here is a more detailed view of my issue. I am using the DTS Import/Export Utility. I am having this trouble on both my PC and Laptop. I have tried importing and exporting data off of the server and onto the server. I keep getting the follow error message, "Failed to...

I have been having an issue with SQL not bringing the primary key and the idenity with the tables when I upload them onto my server online. I am going through copy tables option. Also when I go through copy objects I always get an error about half way through saying can not copy from SQL...

I have been having an issue with SQL not bringing the primary key and the idenity with the tables when I upload them onto my server online. I am going through copy tables option. Also when I go through copy objects I always get an error about half way through saying can not copy from SQL...

I just went in and changed both of the names just to workgroup and it still didn't make a difference. Same error message just different workgroup name.

Yep. Both computers are in the same work group. STUDENT TRADERS. Checked the spelling and everything.