Re: Inserting Data to MS SQL server without DBI

I have been trying to figure out a way to insert data into a MS SQL database with no luck. I cannot use the DBI module because

1. I wouldn't install correctly because I don't have make and a C-compiler on the device (Tried PurePerl as well)

Hmm, have you consulted the DBI mailing list about your problems? Are you using ActiveState or strawberry Perl? Strawberry Perl comes with a c-compiler and dmake for making things.

What exactly happened when you tried installing DBI::PurePerl? Again the DBI mailing list would appreciate specific details on your architecture, error msgs, etc. 2. I cannot install the unixODBC or EasySoft because I can't cross-compile it and don't have the needed space if I could.

I guess I'm at the point where I need either a new paradigm to my approach or a stern talking to of how to explaining how to accomplish the above.

Well, you could always use delimited text files and import the data. There are also other agile languages. I've used SQL Alchemy and Python successfully with MS-SQL.

The mantra of every experienced web application developer is the same: thou shalt separate business logic from display. Ironically, almost all template engines allow violation of this separation principle, which is the very impetus for HTML template engine development.

-- Terence Parr, "Enforcing Strict Model View Separation in Template Engines"

Comment on Re: Inserting Data to MS SQL server without DBI

Replies are listed 'Best First'.

Re^2: Inserting Data to MS SQL server without DBI
by clickingwires (Initiate) on Jul 13, 2011 at 14:52 UTC

Hmm, have you consulted the DBI mailing list about your problems? Are you using ActiveState or strawberry Perl? Strawberry Perl comes with a c-compiler and dmake for making things.

I haven't consulted the DBI mailing list, but I will be now. I not sure which type of Perl I am using because I did not build it. The company for the device built it. If I had to guess, ActiveState.

What exactly happened when you tried installing DBI::PurePerl? Again the DBI mailing list would appreciate specific details on your architecture, error msgs, etc.

The way I went about installing PurePerl was copy and paste. I tried to use the CPAN module to install it but it kept on hanging and quitting. The error that I got from perl in regards to the MySQL, for testing without installing unixODBC or EasySoft, was that it might not have been installed properly. Possibly because I took the copy paste method?

2. I cannot install the unixODBC or EasySoft because I can't cross-compile it and don't have the needed space if I could.

I guess I'm at the point where I need either a new paradigm to my approach or a stern talking to of how to explaining how to accomplish the above.

Well, you could always use delimited text files and import the data. There are also other agile languages. I've used SQL Alchemy and Python successfully with MS-SQL

I am trying to stay away from having the "Remote" server do anything because we have a server that is local to my building and full permissions. But there is a second server several hundred miles away and only have limited rights to access.

Also, I am trying to make this device as simple and easy to set up. The end goal is to have a technician level employee, with very limited command line skills, be able to execute a install script to completely install the device. I have been sticking to what comes factory installed on the device. The available memory on the system isn't very much and all my program, and libraries, are located on a compact flash card.

[reply]


P is for Practical
	PerlMonks