| Author |
 Topic  |
|
|
Biddyman
Starting Member
32 Posts |
 Posted - 03 January 2008 : 23:13:51
|
| This may be a stupid question for I'm learning this stuff. Say you have an identical Access database tbl and SQL database tbl. Other than the connection string, is the code all the same to dump data into each database? |
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 04 January 2008 : 00:53:02
|
| Not quite. Each database (Access, MySQL, SQL Server, Oracle, etc) has its own "dialect" of the SQL language. While the majority of the commands and functions are the same, there are differences. If there are specific questions you have, ask them here or Google them, but there are enough differences that it's hard to just list them. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 04 January 2008 : 02:00:20
|
| as long as you don't do anything complex and avoid using dateTime fields in the db then all should be ok |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 04 January 2008 : 09:19:33
|
| Agreed. Stick to the basics, and you'll likely be fine without having to worry about database irregularities. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
Biddyman
Starting Member
32 Posts |
Posted - 04 January 2008 : 09:31:21
|
Thanks. I was looking at some universal ASP scripts and see how they have usually 3 connection lines, two of whick get ' out. I saw on the Snitz forum that it has a strDBType variable, but didn't see it past setup. I didn't look much either . So, is that used throughout the program for datetime stuff?
Anyways, I was looking at a form handling script that goes to Access and wondering if it was a matter of changing the connection. I know it has datetime field. Trial and error is what I will try. If I get an error, I'll google for the SQL syntax. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 04 January 2008 : 09:49:01
|
| no it is mainly used for determining if your db is mysql when returning limited datasets using the TOP XX command as that works differently in MySQL |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 04 January 2008 : 10:00:26
|
| Biddyman, you can also ask here if you run into errors. I've found that sometimes Snitz can be faster than Google (though it depends heavily on the time of day and the specific question). |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
machinehack
Starting Member
9 Posts |
Posted - 07 January 2008 : 15:30:13
|
There are differences in the default data fields, I found out the hard way.
To get the current date using default
Oracle: sysdate
SQL Server: getdate()
Access: DateTime.Now |
~MachineHack
http://www.machinehack.com |
|
|
| |
Topic |
|
Topic Locked
