Looking at the properties of the tempdb, going to the files tab, 6 different logical names listed. Each logical name has it's own seperate path. Is there a...

Thanks , but I got it working. All links are querying the databases as they should.

The site was created in Frontpage 2K from what it looks like. Re establishing the...

I just noticed that the Datasource: Web SQL is not right. Shouldnt the Datasource: be the name of the server? Web SQL is not the name of the SQL...

Ok , forget the restore, the real issue is I need to fix dead links on our intranet since my rebuild.

The intranet has links to sql databses that run queries...

Below is what the .idc file looks like....

Datasource: Web SQL

Username: ReadOnlyIntranet

Template: DistSumSetDirect.htx

SQLStatement:

+SELECT Core.dbo.Customer.CustID

+ FROM Core.dbo.Customer

+ WHERE (Core.dbo.Customer.CustID=%AcctNum%)

I added a system DSN - Web SQL pointing to the local SQL...

No its not there. Do I need to add it then?

So Do I create a DSN? User, System, or File DSN? I wish I knew how to fix this.

Its driving me crazy and I have users screaming at me to...

Datasource: WEB SQL

Username: ReadOnlyIntranet

Template: DistSumSetDirect.htx

SQLStatement:

+SELECT Core.dbo.Customer.CustID

+ FROM Core.dbo.Customer

+ WHERE (Core.dbo.Customer.CustID=%AcctNum%)

This is what the idc file says.

There are a about 20 idc files in the scripts/idi folder. The Datasource says...

How do I change link strings?

No cluster. just the server name I am referring to

I do not know how to change a link string. How do I do that?

All good, query returned the correct node name.

Now I have an .idc error. When in the app that connects to the sql database, there is a link to IE that...

Actually, one more quest...I had to rebuild the server a few weeks ago on a new box.

The new server was built on a node name caled sqltest. After I moved...

Yes. I did find this in the forums.

Thx.

One more Q: The database I had an issue with is about 2.4GB. What are my options to clean it up and make it smaller? I've been reading that shrinking...

OK! I performed a restore and that error is not appearing now! Just out of curiosity,why did the

error appear in the first place? Is is b/c something happened on...