| T O P I C R E V I E W |
| Fshguy |
Posted - Nov 22 2008 : 08:48:02 AM
I have set up mysql 5.0 on my local dev machine and everything runs great.
When I deploy to my godaddy account I'm having issues.
The problem is locally, .NET refers to a table using it's schema.tablename. i.e. badgecalcx.taginfo. The problem is even if I name my database badgecalcx on godaddy, it doesn't allow me to access it as a schema.
So, I'm trying to strip off all of the schema references, but it seems to be a never ending battle with the auto generated code(which yes, I'm lazy and I want to use!!!)
Any ideas on how to keep .NET from autogenerating the schema or any experience on the mysqlphp interface??? Ack??!
Fish |
| 14 L A T E S T R E P L I E S (Newest First) |
| Cormyre |
Posted - Nov 24 2008 : 2:32:48 PM
quote:
Originally posted by Fshguy
If it weren't for the stupid stuff, we'd be way too productive and half of us would be out of jobs.
=P and 3v! |
| Fshguy |
Posted - Nov 24 2008 : 2:10:31 PM
I'm on a windows hosted environment for blaggspot. So everything app side is .net 2.0.
The database is hosted on unix, so thus the case sensitivity. Of coruse that's probably all based on you how install it. Our Oracle system here at work runs on Unix, tables/column names are not case sensitive, but data isn't...
If it weren't for the stupid stuff, we'd be way too productive and half of us would be out of jobs. |
| Mitsuho |
Posted - Nov 24 2008 : 1:15:43 PM
I know what you mean. I had a 3.99 package that didn't seem small until I tried Rubricks. |
| Cormyre |
Posted - Nov 24 2008 : 1:10:53 PM
huh, ok I don't think my package is that big....
er... robust?
err... yeah I don't think I have python, ror, nor perl... maybe I need to move |
| Mitsuho |
Posted - Nov 24 2008 : 1:06:45 PM
He's probably running the .NET on blaggspot. Secureserver.net supports Python, Ruby, ROR, PHP, and Perl. It might support CF, but I don't remember. |
| Cormyre |
Posted - Nov 24 2008 : 1:05:25 PM
I'll have to try that when I get home... I have a full package on my hosting plan including IIS and mysql... need to see if my tables are case sensitive =P
But yeah we're in a completely mixed environment here, windows, linux and a solitary mac box =P and friggin a handful of different linux distros that hurt my head every time I go to do one thing in one that works in the other but not that one! |
| squidpunch |
Posted - Nov 24 2008 : 12:57:09 PM
he is probably on a windows hosted for the webpages, but they are going to default there DB work to there database servers, which are MOST likely linux based, all we upgraded from SQL 2000 to 2005 at work a bit ago, and during that upgrade our tables became case sensitive - because there is apparently a setting to turn it on - but never knew that before.
but dont worry Mr fish...if you knew the number of times i sat and just said "WTF it should be fine.....and then it was as simple as a typo, or updating a different file than I thought i was....etc etc - happens to us all, and no it doesnt remove the frustration, but at least you know you aren't alone.
there was something to do C# on linux...called Mono, or something like that - but like i said, its more likely a split scenario
|
| Cormyre |
Posted - Nov 24 2008 : 12:47:46 PM
Sorry man, didn't come close to thinking about that when you opened the thread.
Hah, yeah I went through that about a year and a half ago, we migrated quite a few apps from windows to fedora and gentoo boxes, broke every single one of them "what do you mean it doesn't exist?!?! ITS RIGHT FRIGGIN THERE!!"...added much to my balding spot it did...
EDIT:
ERRR, I also didn't think of it since you said .NET o_O is possible to do .NET stuff on apache based web servers? Or your just using that as your database and have something different for your web server? |
| Fshguy |
Posted - Nov 24 2008 : 12:32:50 PM
quote:
Originally posted by squidpunch
Cormyre nailed it i would guess - it is unlikely godaddy DB servers are Windows based, and thus will be case sensitive - i think depending on the driver even windows can be case sensitive in some instances, but thats probably it 
I would imagine so... doesn't keep me from being annoyed.  I just hate the time I wasted, but now I know the answer, it's like doh!!! |
| squidpunch |
Posted - Nov 24 2008 : 11:57:00 AM
Cormyre nailed it i would guess - it is unlikely godaddy DB servers are Windows based, and thus will be case sensitive - i think depending on the driver even windows can be case sensitive in some instances, but thats probably it |
| Cormyre |
Posted - Nov 24 2008 : 11:40:06 AM
is the mySQL server on their end in a linux environment? I never checked to see if there was an option in the config but all of our linux mySQL installs are case sensitive on the databases and tables (like just about everything else when dealing with linux). |
| Fshguy |
Posted - Nov 24 2008 : 10:54:15 AM
Dang it... figured it out... I had two or three issues, but he main one that hung me up was that mysql table names are case sensitive on the godaddy installation!?!? Never had any issues on my local windows installation.
I've never ran into a DB system that had case sensitive tables?!!? arg... oh well.. progress has been made.... |
| Fshguy |
Posted - Nov 22 2008 : 4:07:43 PM
Thanks for the offer Squid... I'll play around with it. I haven't found any options for that for the mysql .net drivers.
I might try the odbc drivers which should give me the same functionality sql wise, but should be more developed.
Worst case, I'll manually rebuild the queries, it's just nice how well .net 2.0 wraps up the datatable/query stuff now.
I have a lot of incentive to go to mysql though, I only get two databases of 250 meg of sql server. With mysql, it's up to my disk quota amount. I have 100gig of disk quota. |
| squidpunch |
Posted - Nov 22 2008 : 09:52:38 AM
without really looking at the code i am not 100% sure - i never use the autogen stuff, so its a bit foreign to me.
im assuming the selections work WITHOUT the schema as you are asking to remove it. if you want to send some code my way to quickly check over I can give a it a look - i would venture to guess if the driver you are using allows you to set a default schema, that might help |
Copyright © 2006-2013 GamerDNA Media. All Rights Reserved.
LIVE GAMER, the Live Gamer logo, GAMERDNA, and the gamerDNA logo are registered or unregistered trademarks of Live Gamer, Inc. and its subsidiary, gamerDNA Media,
in the United States and/or other countries. Xbox, Xbox Live, and all other Xbox Live specific terms are registered trademarks of Microsoft Corp.
Other trademarks are the property of their respective owners.
