Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Info on extracting table/data from Pervasive to SQL Server
I'm looking at setting up a test with an SQL 2008 Express. Company is looking at finding the best solution to extract data daily from a pervasive database (Timberline) to an SQL database. I have SQL 2008 express and managed to create a LInKED server to the pervasive database. Basically, need...- RonMck
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Setup and Administration
-
Received Error "Cannot Find Column -1" when exporting
When tryying to use the Data Import export feature, i recaive the final error for each table: dbo.<tablename> "Cannot Find Column -1" I'm using the .net framework provider for ODBC (as for seems like the Pervasive interface doesn't work) I select the ODBC Connection to the Pervasive Database...- RonMck
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
-
How to limit Subreport detail are to only print 5 records
I have a report that pulls up equiopment info. Within this report, there is a subreport that pulls up all maintenance info for that piece of equipment. There may be up to 100+ records, though I only want to print 5. The sub report on the main report it linked by the master and child field. (The...- RonMck
- Thread
- Replies: 5
- Forum: Microsoft: Access Reports
-
Excel VBA - Open Password protected Database
I've been trying to open a password protected MS Access database from Excel VBA. I've been using the following code to open nonm password protected database with out an issue. Is there an additional perameter that I need to add? Here is the partial code: Set G_Workspace =...- RonMck
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
