Re: MS SQL Server Perl DBI

[dbwiz]

It seems like you are asking very similar (or very confused) questions all the time.

• OT: Creating tables from others
• DBI error
• Perl DBI Insert row
• DBI Insert
• Creating table DBI
• Access to MS Server

Most important, you are not paying attention to what others are telling you.

You should really - REALLY - start with three basic steps:

1. Getting familiar with MS SQL server syntax and basic usage, because it looks like you are trying to use MySQL dialect with a DBMS that works in a completely different way.
2. Getting familiar with the DBI.
3. Reading out Tutorials, especially Before asking a database related question ...

If you go through these steps, we can help you much better.

As it is now, you are clearly using something you don't understand, and your help requests are unclear as well.

Try to make a simple - very simple - script to test the features of your database. If you are successful, then add some more complex feature (one at the time) and see if you still have problems. Don't go to the next step unless you have completed (and understood) the previous one.

HTH

[Win]

dbwiz...... Not everyboby can be blessed overnight with your wizzy db skills. I realise that I have a lot to learn and very little time to do it.

[dbwiz]

Not everyboby can be blessed overnight with your wizzy db skills.

No skills come overnight, especially database experience, which I got after years of studying, working, and listening to the ones who know more than me.

If you don't have time, I am afraid that you won't get what you're looking for. Knowledge can't be distributed as a whole, but for one piece at the time you're welcome to it.

The Monastery is not in the business of doing your job, but it will help you if you make a little effort of explaining what you need.

I was trying to be helpful, showing you the path to improve your skills. From that point on, it's up to you. If you are more interested in finding an alibi than solving your problem, then there is very little that I (or the other Monks) can do for you.

Good luck.

[Win]

Yes, I am at the stage that you were years ago.

An MS SQL Server book has just arrived today. There are few people that I am working with who can offer guidance.

Strategic questions were required because I was in the business of deciding on suitable approaches to get to the end product (several years down the line).

I realise that you were trying to be helpful and I am very interested in solving the problems. Some interesting points have come from this thread (not my previous post .. sorry about that).