Creating Tables on Access/SQL/MSDE
-
Hi, I need to create a set of functions that will aid in the creation of tables (and fields) on Access/MS SQL/MSDE databases. I would like as much as possible to keep the same source code for all three database types, even though there might be a couple of small differences. I am looking for different methods of creating tables/fields. Till now I have come across the following: SQL Queries ADOX Am I right in assuming that both these technologies will allow me to create tables/fields on Access/MS SQL/MSDE databases? Are there other alternatives that I should look at? Which would be the best one to use in terms of reusable code? Jeremy. Jeremy Pullicino C++ Developer Homepage
-
Hi, I need to create a set of functions that will aid in the creation of tables (and fields) on Access/MS SQL/MSDE databases. I would like as much as possible to keep the same source code for all three database types, even though there might be a couple of small differences. I am looking for different methods of creating tables/fields. Till now I have come across the following: SQL Queries ADOX Am I right in assuming that both these technologies will allow me to create tables/fields on Access/MS SQL/MSDE databases? Are there other alternatives that I should look at? Which would be the best one to use in terms of reusable code? Jeremy. Jeremy Pullicino C++ Developer Homepage
Jeremy Pullicino wrote: SQL Queries Some syntaxt for ACCESS and SQLServer are different so you should be careful for that. If you use ADOX I think the only difference is connection string but maybe some functions are supported for one of them. there is no 100% way to do the same code.. Mazy No sig. available now.
-
Hi, I need to create a set of functions that will aid in the creation of tables (and fields) on Access/MS SQL/MSDE databases. I would like as much as possible to keep the same source code for all three database types, even though there might be a couple of small differences. I am looking for different methods of creating tables/fields. Till now I have come across the following: SQL Queries ADOX Am I right in assuming that both these technologies will allow me to create tables/fields on Access/MS SQL/MSDE databases? Are there other alternatives that I should look at? Which would be the best one to use in terms of reusable code? Jeremy. Jeremy Pullicino C++ Developer Homepage
ADOX sucks. Been a whole day on it and did not even manage to create a primary key... I will be try SQL queries now... maybe I should have gone for that option in the first place. Why do MS keep ADOX if it does not work? :mad::mad::mad::mad::mad: Jeremy Pullicino C++ Developer Homepage