Search results for query: *

Logicalman, Sorry to leave you hanging. I have several different things going on and I tend to bounce from on to the other. I am using an include file, so all I have to do is determine the format of the connection string. I will find that in a search. So what's a copper? Jeff

Well to be honest, I am an engineer. While I have particular skill set in numerical modeling and simulation, I am not a programmer per se. I am definitely not a DBA. We sort of stumbled onto this project while supporting the Coast Guard, and I told them I could figure out how to create a...

I saw the window, but I closed it. I was trying to figure out how to save the error log. I did eventually figure it out. What was happening, is the wizard ordered the tasks alphabetically. That is, data is being copied into the database one table at a time according to the table name...

I found the wizard and set up a DTS package. About half of the transfers failed. Is there an error log somewhere that tells me why it failed. I know I am going to have to prepare the data in the Access tables. I just need to know what is inconsistent. Jeff

Logicalman, That was indeed my next question. Creating all of the tables and relationships did not take very long at all. I just spent some time performing some searches on copying my database to create a test database. I learned that I could detach the db, copy the data files in windows...

Thanks Logicalman and Leon. My schedule is all out of whack, so I did not get to read your messages until now. They are both very helpful. I am abonding the upsize wizard. It will only take a few hours for me to build all of the tables. And if I do it through EM, I will know exactly how the...

Logicalman, I have seen your gripe about the upsize wizard before. I have heard from other programmers, though, that it will do a decent job as long as the tables are prepared (data types are set to those that will convert). I was at least going to give it a try and see what happens because...

Alright. That makes sense - that is what I told it to do. So instead of using the new login, I entered my windows authentication, exactly as it shows in the enterprise manager. I am getting the same message. So I tried to change the security to accept SQL Server and Windows authentications...

I am reposting this message. I am hoping to attract a little more help because I am stumped. I am attempting to upsize from Access to sql2k using the upsize wizard. After geting SQL Server registered, and declaring a user (jc), I tried to use the wizard. On the second page of the wizard...

Thanks. The help guides do not say anything about that. I have set up permissions. By the way, I am setting this up on a development version. I now have four accounts for this instance: BUILTIN\Administrators Windows Group CDI-MARINE\jcullina Windows User jc...

I have read through a bunch of stuff in preparation for upsizing my db from Access to SQL Server 2000. I still have some questions though. The first page on the upsize wizard asks whether I want to create a new db or add to an existing db - I can handle that (I want a new one). The next page...

As I read through the book reviews and think back on other conversations I have had on this subject, I notice a blatantly clear distinction between programmers and DBAs. I do not understand how a person could be good at one while knowing little about the other. Is SQL Server so cumbersome that...

That is great information. Unfortunately, I am both the programmer and the supposed database expert - not sure I am qualified for either. I will consider converting to stored procedures as I go through this process. First I need to get the structure built and the data passed. It is not real...

Thanks. I was planning on using the upsizing wizard. I am glad I know not to. I was also unaware that the SQL was substantially different. I figured they are both MS products. About stored procedures. My application is a website. Rather than define queries and procedures in the database...

I should have checked FAQ first. My experience is that FAQ has never been helpful, so I do not think to look there anymore. I have performed a search, but the topic is fairly broad, so it is difficult to perform a useful search. I have a good place to start in the FAQ. Thanks.

I am about to push a database in Access 2000 to SQL Server. I am very familiar with Access, but I do not yet know anything about SQL Server. I am guessing the two are similar, though SQL Server is obviously going to be somewhat more complicated. What kind of complications can I expect in the...

It is currently in default (plain text) mode. The problem might only be related to the Request.Form object rather than referncing a variable defined on the page. I have been trouble shooting for quite some time to figure out exactly where the problem lies, but I am not quite there yet. When...

I am creating an email using CDONTS. It works fine with the exception of the formatting of the body content. Depending on the values and/or data types in the variables called in the body, sometimes the lines will appear bold or italicized, and sometimes they show up as plain text. I am using...

Anybody have a good book to recommend for ASPs and vbscript? I am fairly proficient in the language, but I would like an index of functions and other mid- to high-level techniques. Thanks - Jeff

I have two dates - 5/12/02 and 5/6/03. I am looking for a routing that will return the difference in a year,month,day format. For the given dates, the function should return something like 0 years, 11 months, 25 days. The datediff function rounds so I cannot get an accurate account. When I...