Error Invalid Data Source Vb6
Contents |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start invalid picture error in vb6 viewing messages, select the forum that you want to visit from the selection below. Results
Combobox Vb6 Data Source
1 to 3 of 3 Thread: error - "invalid data source " Tweet Thread Tools Show Printable Version Subscribe to this Thread… msflexgrid vb6 data source Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jan 24th, 2009,03:33 AM #1 samns View Profile View Forum Posts Thread Starter New Member Join Date Jan 2009 Posts 10 error - "invalid data source error invalid data source name " i m not getting as how to connect my data enviornment page to data report page its giving me an error of invalid data source so what code should i write in data enviornment page so that it gets connected to data report page and it does not give me this error please help its urgent Reply With Quote Jan 24th, 2009,05:35 AM #2 freeboy103 View Profile View Forum Posts Banned Join Date
Compile Error Invalid Outside Procedure Visual Basic
Jan 2009 Posts 3 Re: error - "invalid data source " In function Form Load add code vb Code: DataEnvironment1.Connection1.ConnectionString = "connection string here" Reply With Quote Jan 24th, 2009,06:05 AM #3 samns View Profile View Forum Posts Thread Starter New Member Join Date Jan 2009 Posts 10 Re: error - "invalid data source " in which form u have to write this code as in data enviornment form nor in data report form there is a form load method please help me out with this as i donot know anything about this Reply With Quote Quick Navigation Visual Basic 6 and Earlier Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net CodeBank Visual Basic 6 and Earlier CodeBank - Visual Basic 6 and earlier Modern Windows Experience (Metro) Office Development Mobile Development ASP, VB Script Database Development Reporting API Games and Graphics Programming Game Demos COM and ActiveX Network Programming Visual Basic FAQs Slow Chat with the Microsoft Visual Basic team .NET ASP.NET Visual Basic .NET MVC .Net C# WPF, WCF, WF Silverlight .NET Architecture and Design General General Developer Forum IoT, IoE, and Maker Forum Testers and Testing Application Testing Application Deployment Linux Development General PC VBForums Coding Contests Contest Entries Code It Better Maths Forum Ot
opened in my system, and i shared the database into another system,i was updating my datas from another system, form and database everything is working fine , but the problem is when i try to open the report it shows the "INVALID DATASOURCE" error, invalid data source vb6 data report in datareport property window i have assigned the datasourse as dataenviroment 1, but still the problem is is in datasource .can please anyone help me to sort out this problem, thankyou saksaz 5 posts since Jun 2010 Community Member 2Contributors 9Replies 10Views 6 YearsDiscussion Span 6 Years Ago Last Post by vb5prgrmr 0 vb5prgrmr 143 6 Years Ago Okay, it sounds like you have designed a DR on one machine (Computer1) and now are trying to use it from a http://www.vbforums.com/showthread.php?554956-error-quot-invalid-data-source-quot second machine (Computer2). Which means, it could be as simple as accidently hard coding the path to the database and since you are on another computer, that path is incorrect. Make sure you are specifying the correct path... Good Luck 0 Discussion Starter saksaz 6 Years Ago Set cn = New ADODB.Connection cn.Open ("Provider=SQLOLEDB.1;Persist Security Info=False;User ID="";password="";Initial Catalog=;Data Source="") this is which i gave connection for SQL and VB, it is working in another computer, but the problem is it not https://www.daniweb.com/programming/software-development/threads/292216/invalid-data-source opening the particular dataenvironment and that supporting commands from the project. plz help me 0 vb5prgrmr 143 6 Years Ago See http://www.connectionstrings.com just in case... and I see that you are using ???? Data Source as in an ODBC DSN? Did you create the ODBC DSN on the other computer? Good Luck 0 Discussion Starter saksaz 6 Years Ago i have tried, but the problem is in datareport data source, i have given the data report data source as "dataenvironment 1" in property window, but i can't access this data source from another computer. 0 vb5prgrmr 143 6 Years Ago If you create a ODBC DSN for your connection on your dev machine, you must create it on the target machine... Good Luck 0 Discussion Starter saksaz 6 Years Ago yes i have create the DSN on my target computer also,but again it shows the same error "invalid data source" 0 vb5prgrmr 143 6 Years Ago Did you test the ODBC DSN? Did you name it correctly? I mean exactly the same name as there may be a space in the name... Good Luck 0 Discussion Starter saksaz 6 Years Ago yes i checked, testing also successful, but still it shows same error. 0 vb5prgrmr 143 6 Years Ago Okay, so you have created the ODBC DSN on the target computer and have tested it and it works... So that means that the required drivers are on the machine for
question and get tips & solutions from a community of 418,513 IT Pros & Developers. It's quick & easy. Invalid Data Source P: 2 KHD Hey People ..I have Invalid Data Source Warning when I preview https://bytes.com/topic/visual-basic/answers/572758-invalid-data-source VB data report i am using ADODB recordset and SQL select starment. Please help me healing this ERROR thanks !!! Dec 4 '06 #1 Post Reply Share this Question 3 Replies P: 1 fifeer Hi KHD, i have the same problem. if you had solved , can you please write to me. thanks... Dec 26 '06 #2 reply 100+ P: 1,646 willakawill Hey People ..I have Invalid Data Source Warning when I preview VB data report i am using ADODB recordset and SQL data source select starment. Please help me healing this ERROR thanks !!! Hi. You will, no doubt, be aware that the pundits who frequent these pages rarely, if ever, boast about their psychic powers. In order to overcome this tragic failing on our part, would you kindly post your offending code? Thanks :) Dec 26 '06 #3 reply P: 2 KHD Dear All, here is the Function I am using to initializ the report [code]Private Function InitReport() As Boolean Dim rpt As Object Dim invalid data source rsRPT As New ADODB.Recordset If Not err.Number = 8520 Then Select Case State Case 1: 'rptData If Not txt_Field(0) = "" Then Set rptData = Nothing Set rsRPT = dbConnection.Execute("select Visits.* from visits where visits.Vis_no= " & Val(txt_Field(0)) & " order by Vis_No ") Set rptData.DataSource = rsRPT ' rptdata.ReportWidth = 200 InitReport = True Else: MsgBox "Error" End If End Select Else InitReport = False End If End Function[/CODE Thanks in advance Jan 6 '07 #4 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics Invalid postback or callback argument error ERROR: The state information is invalid for this page and might be corrupted The format of the file 'Microsoft.Practices.EnterpriseLibrary.Data' is invalid Invalid cast from System.Int32 to System.Byte[]. Invalid object name accessing SQL Invalid cast from SQL to other server error in asp : invalid attempt to read when no data is present Length of the data to decrypt is invalid. mmioDescendParent: invalid parameter oledb invalid path... Browse more Visual Basic 4 / 5 / 6 Questions on Bytes Question stats viewed: 4164 replies: 3 date asked: Dec 4 '06 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes | Advertise on Bytes | Contact Us Sitemap | Visual Basic 4 / 5 / 6 Answers Sitemap | Visual Basic 4 / 5 / 6 Insights Sitemap Follow us to get the Latest Bytes Updates