can you use crystal reports 11 to connect to an as/400 database?
116143
You absolutely can through an ODBC connection.  Are you using DB2 on an AS/400?\n\nSee the following instructions:\nhttp://support.businessobjects.com/library/kbase/articles/c2016569.asp
1054783
Dude... whoever said "use the connection wizard" just isn't creative at all...\n---------------------------------------------------------\n\nHere is code that helps you get started:\n\npublic DataTable listExistingForAdmin()\n{\n//a temporary table for storing the data into a dataset\nstring temptable = "yourTableNameHere";\n\n//prepare the SQL statement...\nstring sql = "EXEC df_groups_listExistingForAdmin"; //your SQL code here\n\n//open the connection - use your connection string!!!\nthis.con = new SqlConnection("packet size=4096;user id=dbuser;password=dbuser;data source=YourDbServerName;persist security info=False;initial catalog=yourDbName");\nthis.con.Open();\n\n//instantiate the command\nthis.com = new SqlCommand(sql, this.con);\nthis.com.CommandText = sql;\n\n//instantiate the data adapter\nSqlDataAdapter adapt = new SqlDataAdapter();\nadapt.SelectCommand = this.com;\n\n//instantiate the DataSet\nDataSet ds = new DataSet();\n\n//complete the transaction\nadapt.Fill(ds, temptable);\nDataTable dt = ds.Tables[temptable];\n\n//clean house\nadapt.Dispose();\nthis.com.Dispose();\nthis.con.Close();\n\nreturn dt;\n}//end ()\n\nHope this helps!!
1086641
FOR Crystal Reports Tutorial this is all you need to know\nhttp://www.insightdirect.com/docs/crystal/
992679
Download the oracle drivers classes12.jar. That will let you connect to Oracle
636142
you need a connection string that tells your program where to point. then use your ADO datasource and set its command string. then just make a call to the database for whatever you want from it.\n\nhttp://msdn.microsoft.com/vbrun/vbfusion/usingsqlexpress/\n\nThe above resource connects to a sqlexpress database. The concept is the same for connecting to a sql2000 dbase the only thing that changes is the connectionstring.
488741
You would have to either write an interface between COBOL program and MS Access, or dump the data base to a text file and have COBOL read the text file. Either way, you would have to write the COBOL program.\n\nIf you are loading to a relational data base, just use Access.
1118985
if your using .net platform than look up the oracle client\n\nSystem.Data.OracleClient.OracleConnection\nIf your using any other windows implemetation of C, C++ use odbc
677608
Ooh, it would be so much easier if you could use VB.NET 2.0.\n\nWhy?\n\nBecause there is a drag and drop control that links directly to SQL Server Reporting Services (either SQL 2000 or 2005)\n\nThen your app would be ready in 5 minutes.\n\nIf not...then you could use a web control and just point it at the 'report manager' part of SQL Server Reporting Services.\n\nIf not...then you are probably best off doing something with the Crystal Reports control.\n\nSeriously though, Reporting Services is a free product and   I would advise you to use it if at all possible. It will pay for itself in no time.
850443
ok I give some hints\nIf you want to refer to a database from Excel you need to add the ADO 2.8 objects Library. \nHow to proceed?\nFrom the Visual basic editor, click on tools (menu bar) and then reference. look for Microsoft Activex Data objects 2.8 library and tick it.\nNow you should have access to ADO objects.\nTo learn how to use these objects try the msdn microsoft website, full of advice and templates\n\nIf you want an example from me, give me a valid email address where i can send you an excel workbook and small access data base for it takes too long to explain
1167306
The short answer is that you have to have an external (remote) database setup, then you can use odbc to connect to it.
676495
Its been awhile since i've mucked around with crystal but isn't there a table object that you can put into the report to display 10 rows and 6 cols? you can then just populate this table object with data from your database
481740
The required files are here. Make sure that they are registered on your user's computer or they may not be found by the crystal runtime engine.\n\nhttp://support.businessobjects.com/library/kbase/articles/C2012421.asp
1124098
In VS.NET Xpress u can connect with databases using \n1.SqlClient, 2. OleDb, 3. Odbc\nThese classes hav inbuild methods that makes everything simpe and sweet.\n\nFor indepth coverage on these topic visit microsoft's MSDN, Also go thru sqljunkies.com, dotnetjunkies.com\n\nOleDb Code Sample\n************************************************\n\n\nusing System;\nusing System.Data;\nusing System.Data.OleDb;\n\nclass Sample\n{\npublic static void Main()\n{\nOleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind");\n\nOleDbCommand catCMD = nwindConn.CreateCommand();\ncatCMD.CommandText = "SELECT CategoryID, CategoryName FROM Categories";\n\nnwindConn.Open();\n\nOleDbDataReader myReader = catCMD.ExecuteReader();\n\nwhile (myReader.Read())\n{\nConsole.WriteLine("&#92;t{0}&#92;t{1}", myReader.GetInt32(0), myReader.GetString(1));\n}\n\nmyReader.Close();\nnwindConn.Close();\n}\n}\n\nOdbc Code Sample\n************************************************\nusing System;\nusing System.Data;\nusing System.Data.Odbc;\n\nclass Sample\n{\npublic static void Main()\n{\nOdbcConnection nwindConn = new OdbcConnection("Driver={SQL Server};Server=localhost;" +\n"Trusted_Connection=yes;Database=northwind");\n\nOdbcCommand catCMD = new OdbcCommand("SELECT CategoryID, CategoryName FROM Categories", nwindConn);\n\nnwindConn.Open();\n\nOdbcDataReader myReader = catCMD.ExecuteReader();\n\nwhile (myReader.Read())\n{\nConsole.WriteLine("&#92;t{0}&#92;t{1}", myReader.GetInt32(0), myReader.GetString(1));\n}\n\nmyReader.Close();\nnwindConn.Close();\n}\n}
1064841
kindly go through below website\nhttp://www.codeproject.com/vb/net/CrystalReports_in_VBNET.asp
766570
To connect to an MS Access databse use this code:\n\n<CFQUERY NAME="rs" \n DBTYPE="dynamic" \n CONNECTSTRING="Driver={Microsoft Access Driver (*.mdb)};Dbq=c:&#92;db&#92;mydb.mdb;Uid=Admin;Pwd=;"\n>\nSELECT SeekId, SeekUsername, SeekPassword from Seekers\n</CFQUERY> \n\nIncase you wan't to use an extended path use this code. \n<CFQUERY NAME="rs" \n DBTYPE="dynamic" \n CONNECTSTRING="Driver={Microsoft Access Driver (*.mdb)};Dbq=#ExpandPath('..&#92;bettergig&#92;cgi-bin&#92;bettergig.mdb')#;Uid=Admin;Pwd=pass;"\n>\nSELECT SeekId, SeekUsername, SeekPassword from Seekers\n</CFQUERY>\n\nBoth the connections that I have described above are DNS-less connection or ready-to-connect. So you need not setup any DSN.
237318
Crystal Reports are templates that can be used to put the info in your database into usable format.  The company where I work is currently switching over to a iweb - eweb based software to handle our member database, and the new software will utilize Crystal to produce many of the reports that we need.
332491
Try digdb excel add-in\n\nthis is the linke you need