Thread: AUWhenWin
View Single Post
Old 08-22-2008, 05:20 AM   #3 (permalink)
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
My biggest problem with SQL is how does it set up the SQL database on the 'users' computer. Do they have to manually set up the ODBC settings? I guess I could create a small sample program and deploy it on one of my other computers.

I tried writing one today. I can easily create the SQL database, but I had to manually create the tables. I am looking for an easy way to just import all of the CSV files into a SQL database. I guess I do not need all of them. Once I get them into a SQL database, manipulating the data will not be too hard for me. I have read quite a bit on writing SQL code.

I did have one event that made me throw my hands up in the air and hit that X in the corner. I created a sample database, and everything worked good. (I have SQL 2008 on here), but when I manually entered some data, then closed the program, then reopened it, the data was not there. It dawned on me later that there was a setting that had to do something with copying the database to the work folder or something. I remember having this problem a couple of years ago when I started to tackle the problem.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote