Hey Wench,
No, I never figured it out. I even swallowed my pride and called Microsoft. They reviewed my asp and didn't have any problem with my code. They did have me switch to OLE DB but that didn't help. They looked at the stored procedures in SQL server and didn't find any problem with...
Hi everyone,
I have an ASP application that accesses (through ODBC) a SQL Server 2000 database. Sometimes IIS will stop talking to SQL server. All the ASP pages that access data will hang without an error or timeout. In SQL server I see a connection from IIS whose last batch is one of my stored...
Hi everyone,
I have an ASP application that accesses (through ODBC) a SQL Server 2000 database. Sometimes IIS will stop talking to SQL server. All the ASP pages that access data will hang without an error or timeout. In SQL server I see a connection from IIS whose last batch is one of my stored...
What version of access are you using? How is access getting the data from SQL server, through a pass through query or some other means?
You should be able to just set up a linked table to the Data_Cust table in SQL server. After that you can use the linked table like any other access table.
-Mike
Why not just do this? (assuming it is a character data type it should work just fine)
select name, address
from clientinfo
where [Date] = (select max([Date]) from clientinfo)
Wouldn't the following return data from multiple years since it is only using the date's month?
WHERE...
I figured it out the block size thing. I feel stupid. I'm going to stop asking questions now. Ya see, my company's network administrator is out for another month or so. So I get to have fun learning how to do that job now.
Thanks for your help everyone. I just found out there is only 128 megs of RAM on the server. The volume I'm adding the name space to is 1.23 gigs. I have a special bonus question. Are you ready???
How do I determine the block size of a volume?
Thanks Again!
I'm planning on adding long file names to a netware 4.2 volume soon. I would appreciate hearing about anybody's experience with this. Even if everything went okay for you.
I'm planning on having a full backup. Is there anything else I should be aware of? Any issues with Arcserve???? I haven't...
I work for a publishing company that uses a really old order entry program written in Data Bus called CATS. Believe me, the program is wierd. I want to pull invoice information with bill to and ship to information as well. But since I'm linking to the customer table twice the query returns...
I can't alias the column name because of the ODBC driver I'm using. So no "As" allowed. It's the only driver that exists for this data source so I'm kind of stuck. Thanks for the response though.
I have a pass-through query that returns two columns with the same name and I can't figure out how to refer to the second one. Using 'CustName' returns the value from the first column named CustName in the query. How can I refer to the second one?
Note: I can't alias the field names in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.