473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

very urgent please

284 100+
i am using vb6 and msaccess database.
i open the connection in module with this code

Expand|Select|Wrap|Line Numbers
  1. DataPath = App.Path & "\dinner.mdb"
  2. con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & DataPath & ";Persist Security Info=False
"




it show proble , now i had insert a dataenvironmet1 in the project
and when i made a connection to database how we can write app path
in dataenvirement connection so it
i had upload a pictured please correct it the code of picture
Attached Images
File Type: jpg upload.JPG (4.4 KB, 138 views)
Feb 28 '08 #1
5 995
muddasirmunir
284 100+
please also see the follwoing link where i had place a big picture

for you to describe properly

http://www.dreamincode.net/forums/showtopic44648.htm
Feb 28 '08 #2
VBWheaties
145 100+
please also see the follwoing link where i had place a big picture

for you to describe properly

http://www.dreamincode.net/forums/showtopic44648.htm
You need to look at the Dataenvironment object which is a class from which you can access the Connection object.

Like this:

Expand|Select|Wrap|Line Numbers
  1.  
  2. DataEnvironment1.Dinner.ConnectionString = "your connection string here"
  3.  
  4.  
Feb 28 '08 #3
muddasirmunir
284 100+
can you please guide me more where to put code
and what to write on a box whose picture i had shown you




You need to look at the Dataenvironment object which is a class from which you can access the Connection object.

Like this:

Expand|Select|Wrap|Line Numbers
  1.  
  2. DataEnvironment1.Dinner.ConnectionString = "your connection string here"
  3.  
  4.  
Feb 29 '08 #4
VBWheaties
145 100+
Are you looking to programatically apply connectionstring to your connection in the DataEnvironment?

If so, your DataEnvironment instance is global. Just like a form (frmMain), it can be referenced in code.

Assuming you gave it the default name, DataEnvironment1, it is a simple matter of using it in your code like so

Expand|Select|Wrap|Line Numbers
  1.    DataEnvironment1.Connection.ConnectionString = "my connection string"
  2.  
Doing it this way overrides the manual method of using the connection string wizard while in the IDE.
Feb 29 '08 #5
muddasirmunir
284 100+
i will try this and then tell you did i am able to solve or not




Are you looking to programatically apply connectionstring to your connection in the DataEnvironment?

If so, your DataEnvironment instance is global. Just like a form (frmMain), it can be referenced in code.

Assuming you gave it the default name, DataEnvironment1, it is a simple matter of using it in your code like so

Expand|Select|Wrap|Line Numbers
  1. DataEnvironment1.Connection.ConnectionString = "my connection string"
  2.  
Doing it this way overrides the manual method of using the connection string wizard while in the IDE.
Feb 29 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Joao Santa Barbara | last post by:
Hi all i have this error reading one registry key , can anyone assist me .. please very urgent i try in one computer, and work fine, but in other computer it didn´t work and throws this error...
2
by: Bill Yin | last post by:
Please tell me where can download <Beginning C# web Applications with Visual studio .net> 's code Thanks in advance!
4
by: pargat singh | last post by:
Hi I format my M/C and install fresh copy of Win2000 and ISS.First thing after that i install VS.net and every thing goes well without any error.When i try to open asp.net application i am...
0
by: Tulasi | last post by:
Hello, any one help me the problem due to Shopping cart. I am developping a project in that project,I want to connect shopping Carts in Vb.net.The shopping carts...
0
by: IT Recruiter | last post by:
*Very Urgent Rek - SQL Server DBA from Direct Client: Full time* @ New Jersey ***Please send your resumes IMMEDIATELY to nslakshmi@eprocorp.com*** Job Title: SQL Server Developer with...
33
by: dembla | last post by:
Hey Frnds can anyone help me in this i need a program in 'c' PROGRAM to print NxN Matrix 9 1 8 1 2 3 2 7 3 as 4 5 6 6 4 5 7 8 9 in sorted form
1
by: alok sengar | last post by:
hi, I have already tried this URL's code "http://www.java2s.com/Code/CSharp/Network/SimpleSNMP.htm" but I am getting error when i am creating a UDP type Socket and recieving packet from this...
3
by: settyv | last post by:
Hi, I need to generate PDF stream when i click on Linkbutton in datagrid ..At present i hardcoded the DMS Id and now it is working.But i need to pass DMS ID when click linkbutton.How can i do...
0
by: Balamurugan Ranganathan | last post by:
I want to calculate the execution time of a sql query through C#.net this is to analysis two queries to compare their execution time it is very Urgent Please help me Please help Me ...
6
by: jenipriya | last post by:
Hi all... its very urgent.. please........i m a beginner in oracle.... Anyone please help me wit dese codes i hv tried... and correct the errors... The table structures i hav Employee (EmpID,...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.