I am trying to convert some code that was running against Jet to run with SQL Server tables, and I have a couple questions about pass through queries. Any thoughts are appreciated.
- I ran Doug Steele's code for creating DSN-less connections (http://www.accessmvp.com/DJSteele/DSNLessLinks.html). Seems to work great, but when I test pass through queries in the query builder I'm getting a pop-up asking for a DSN. I'm using SQL Server authentication and thinking maybe the password isn't stored, but then there has to be some way to run queries without being prompted for the password every time, right?
- Some code I'm converting has lots of action queries without query definition objects. An example could be something like
ssql = "Delete * from dbo_SomeTable"
db.execute(ssql)
My understanding is that the syntax of that SQL statement has to be changed to "Delete from dbo.SomeTable", which works when defined as a pass through query in the query builder (after prompting for the DSN). But is there a way to modify this in code, hopefully without creating query defs?
Thanks,
Sam
Tidak ada komentar:
Posting Komentar