Recent content by jan11

The following should help: :) Write this line at the top of your code page Imports System.Data.OleDb Then include this at the place where u want to establish a DB conn with sql server Dim cConnString As String Dim oConn As New OleDbConnection() cConnString = "Provider= SQLOLEDB;data source...

I have a abc.PRG file in visual foxpro 8.0. I can run this file using visual foxpro environment and it creates a table X.dbf in the same folder where this program file is and populates some data in the table. I want a way to run this abc.PRG file through VB.net environment. (Equivalent method...

Thank you Madawc and synapsevampire. Madawc i did not completely understand your solution,and as synapsevampire correclty pointed out, i had very less information. Hope the following will help. My table structure and data are as below: ClientName, Jan, Feb, Mar,......,Dec(these are field names)...

I have crystal 8.5. I am using ODBC to connect to FXP database through .NET. I want to create a crystal report which will display Jan-Mar values on 1st page, Apr to Jun on 2nd page,Jul to Sep on 3rd page and so on... My FXP table has structure as below: Fields:- ClientName Jan Feb...

I am using a DTS import option on a sql server 2000. I am trying to copy the tables and data from a sql server 7 database. The DTS import runs fine and copies over all the tables and data. The only problem is it does not copy over the default value settings of a column in a table. For example a...